Database port

What port does SQL Server 2000 is using for connection ?
What I want to do is I want to connect my application from my home machine
to my office server, so I need to open the port in my office server.
Do I need to have VPN in order to connect over the internet ?Alan,
On the Microsoft SQL Server group select Server Network Utility, select
TCP/IP and click Properties. You will see the default port (usually 1433).
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:
> What port does SQL Server 2000 is using for connection ?
> What I want to do is I want to connect my application from my home machine
> to my office server, so I need to open the port in my office server.
> Do I need to have VPN in order to connect over the internet ?
>
>|||Sorry, I can't find the Server Network Utility.
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:C2A4874D-96D8-4ABD-BAFD-C0B657C7F437@.microsoft.com...
> Alan,
> On the Microsoft SQL Server group select Server Network Utility, select
> TCP/IP and click Properties. You will see the default port (usually 1433).
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Alan" wrote:
> > What port does SQL Server 2000 is using for connection ?
> > What I want to do is I want to connect my application from my home
machine
> > to my office server, so I need to open the port in my office server.
> > Do I need to have VPN in order to connect over the internet ?
> >
> >
> >|||Alan wrote:
> What port does SQL Server 2000 is using for connection ?
> What I want to do is I want to connect my application from my home machine
> to my office server, so I need to open the port in my office server.
> Do I need to have VPN in order to connect over the internet ?
>
By default SQL server is using port 1433 so you'll have to have that
open. I'd strongly recommend that you use a VPN connection. Otherwise
you'll open your server to everyone and I doubt that's what you want...:-).
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator|||It is in the SQL Server Program group on the server machine.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Alan" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%235HFdHRkGHA.836@.TK2MSFTNGP02.phx.gbl...
> Sorry, I can't find the Server Network Utility.
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:C2A4874D-96D8-4ABD-BAFD-C0B657C7F437@.microsoft.com...
>> Alan,
>> On the Microsoft SQL Server group select Server Network Utility, select
>> TCP/IP and click Properties. You will see the default port (usually 1433).
>> Ben Nevarez, MCDBA, OCP
>> Database Administrator
>>
>> "Alan" wrote:
>> > What port does SQL Server 2000 is using for connection ?
>> > What I want to do is I want to connect my application from my home
> machine
>> > to my office server, so I need to open the port in my office server.
>> > Do I need to have VPN in order to connect over the internet ?
>> >
>> >
>> >
>|||Steen Persson (DK) wrote:
> Alan wrote:
>> What port does SQL Server 2000 is using for connection ?
>> What I want to do is I want to connect my application from my home
>> machine
>> to my office server, so I need to open the port in my office server.
>> Do I need to have VPN in order to connect over the internet ?
>>
> By default SQL server is using port 1433 so you'll have to have that
> open. I'd strongly recommend that you use a VPN connection. Otherwise
> you'll open your server to everyone and I doubt that's what you want...:-).
>
Hopefully the server is behind an existing firewall. If VPN isn't an
option, use the firewall rules to open port 1433, but only allow
connections from the IP address of your home machine. Either way, some
basic network security needs to be observed here.|||I used netstat -a to list
but what should I looking at ?
Local Address or Foreign Address ?
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:OTgxdVUkGHA.976@.TK2MSFTNGP02.phx.gbl...
> Steen Persson (DK) wrote:
>> Alan wrote:
>> What port does SQL Server 2000 is using for connection ?
>> What I want to do is I want to connect my application from my home
>> machine
>> to my office server, so I need to open the port in my office server.
>> Do I need to have VPN in order to connect over the internet ?
>>
>> By default SQL server is using port 1433 so you'll have to have that
>> open. I'd strongly recommend that you use a VPN connection. Otherwise
>> you'll open your server to everyone and I doubt that's what you
>> want...:-).
>>
> Hopefully the server is behind an existing firewall. If VPN isn't an
> option, use the firewall rules to open port 1433, but only allow
> connections from the IP address of your home machine. Either way, some
> basic network security needs to be observed here.|||Alan T wrote:
> I used netstat -a to list
> but what should I looking at ?
> Local Address or Foreign Address ?
>
"Local" would imply the local machine, so assuming you're running
NETSTAT on the SQL server machine, i.e. the "local" machine, you would
want the Local Address.
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com