I need to connect to SQL Server 2000 across the Internet. SQL Server is
behind a NAT router. What port(s) do I need to forward to be able to
connect with Enterprise Manager and ADO?
Bill Todd
Bill Todd wrote:
> I need to connect to SQL Server 2000 across the Internet. SQL Server
> is behind a NAT router. What port(s) do I need to forward to be able
> to connect with Enterprise Manager and ADO?
Try forwarding 1033.
David Gugick
Imceda Software
www.imceda.com
|||Bill Todd wrote:
> I need to connect to SQL Server 2000 across the Internet. SQL Server is
> behind a NAT router. What port(s) do I need to forward to be able to
> connect with Enterprise Manager and ADO?
>
I've personally found 1433 to be the port that's needed. This is,
however, configurable from within Enterprise Manager.
Right-click on your server, select the "General" tab, click on "Network
Configuration", and select TCP/IP from among the named protocols on the
right. Click "Properties" and this should tell you what port SQL Server
is using.
Josh
Showing posts with label toconnect. Show all posts
Showing posts with label toconnect. Show all posts
Monday, 19 March 2012
Connect through NAT router
I need to connect to SQL Server 2000 across the Internet. SQL Server is
behind a NAT router. What port(s) do I need to forward to be able to
connect with Enterprise Manager and ADO?
Bill Todd
Bill Todd wrote:
> I need to connect to SQL Server 2000 across the Internet. SQL Server
> is behind a NAT router. What port(s) do I need to forward to be able
> to connect with Enterprise Manager and ADO?
Try forwarding 1033.
David Gugick
Imceda Software
www.imceda.com
|||Bill Todd wrote:
> I need to connect to SQL Server 2000 across the Internet. SQL Server is
> behind a NAT router. What port(s) do I need to forward to be able to
> connect with Enterprise Manager and ADO?
>
I've personally found 1433 to be the port that's needed. This is,
however, configurable from within Enterprise Manager.
Right-click on your server, select the "General" tab, click on "Network
Configuration", and select TCP/IP from among the named protocols on the
right. Click "Properties" and this should tell you what port SQL Server
is using.
Josh
behind a NAT router. What port(s) do I need to forward to be able to
connect with Enterprise Manager and ADO?
Bill Todd
Bill Todd wrote:
> I need to connect to SQL Server 2000 across the Internet. SQL Server
> is behind a NAT router. What port(s) do I need to forward to be able
> to connect with Enterprise Manager and ADO?
Try forwarding 1033.
David Gugick
Imceda Software
www.imceda.com
|||Bill Todd wrote:
> I need to connect to SQL Server 2000 across the Internet. SQL Server is
> behind a NAT router. What port(s) do I need to forward to be able to
> connect with Enterprise Manager and ADO?
>
I've personally found 1433 to be the port that's needed. This is,
however, configurable from within Enterprise Manager.
Right-click on your server, select the "General" tab, click on "Network
Configuration", and select TCP/IP from among the named protocols on the
right. Click "Properties" and this should tell you what port SQL Server
is using.
Josh
Connect through NAT router
I need to connect to SQL Server 2000 across the Internet. SQL Server is
behind a NAT router. What port(s) do I need to forward to be able to
connect with Enterprise Manager and ADO?
Bill ToddBill Todd wrote:
> I need to connect to SQL Server 2000 across the Internet. SQL Server
> is behind a NAT router. What port(s) do I need to forward to be able
> to connect with Enterprise Manager and ADO?
Try forwarding 1033.
David Gugick
Imceda Software
www.imceda.com|||Bill Todd wrote:
> I need to connect to SQL Server 2000 across the Internet. SQL Server is
> behind a NAT router. What port(s) do I need to forward to be able to
> connect with Enterprise Manager and ADO?
>
I've personally found 1433 to be the port that's needed. This is,
however, configurable from within Enterprise Manager.
Right-click on your server, select the "General" tab, click on "Network
Configuration", and select TCP/IP from among the named protocols on the
right. Click "Properties" and this should tell you what port SQL Server
is using.
Josh
behind a NAT router. What port(s) do I need to forward to be able to
connect with Enterprise Manager and ADO?
Bill ToddBill Todd wrote:
> I need to connect to SQL Server 2000 across the Internet. SQL Server
> is behind a NAT router. What port(s) do I need to forward to be able
> to connect with Enterprise Manager and ADO?
Try forwarding 1033.
David Gugick
Imceda Software
www.imceda.com|||Bill Todd wrote:
> I need to connect to SQL Server 2000 across the Internet. SQL Server is
> behind a NAT router. What port(s) do I need to forward to be able to
> connect with Enterprise Manager and ADO?
>
I've personally found 1433 to be the port that's needed. This is,
however, configurable from within Enterprise Manager.
Right-click on your server, select the "General" tab, click on "Network
Configuration", and select TCP/IP from among the named protocols on the
right. Click "Properties" and this should tell you what port SQL Server
is using.
Josh
Friday, 17 February 2012
configuring sql 6.5
**** Post for FREE via your newsreader at post.mcse.ms ****
Hi,
I can't see SQL 6.5 server installed on other computer. I am trying to
connect to it using SQL 2000, ODBC, ADO and none of this is helping. I
haven't experienced the same problems with SQL2000 installation. I have
installed it and all went ok. I do not change anyu network setting on this
computer and install SQL 6.5 and then i can't see this server. Maybe there
is some quick guide how to set SQL 6.5 as it seems to me that default
configuration do not work.
darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.mcse.ms
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=Darius wrote:
> I can't see SQL 6.5 server installed on other computer. I am trying to
> connect to it using SQL 2000, ODBC, ADO and none of this is helping. I
> haven't experienced the same problems with SQL2000 installation. I
> have installed it and all went ok. I do not change anyu network
> setting on this computer and install SQL 6.5 and then i can't see
> this server. Maybe there is some quick guide how to set SQL 6.5 as it
> seems to me that default configuration do not work.
Tibor already answered the EM question in your previous thread (please do
not create new threads if it is not needed). 7.0 or 2000 EM cannot work
against 6.5 or earlier. You need EM 6.5 for that.
Please post the connection string for ODBC/ADO approach.
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||**** Post for FREE via your newsreader at post.mcse.ms ****
> Tibor already answered the EM question in your previous thread (please do
> not create new threads if it is not needed). 7.0 or 2000 EM cannot work
> against 6.5 or earlier. You need EM 6.5 for that.
I know. I have asked one more question in last thread but I didnt get any
answers, so I created new thred. I've asked what do you mean EM 6.5? do you
mean new SQL 6.5 installation or only enterprise manager 6.5?
darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.mcse.ms
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||Darius wrote:
> I know. I have asked one more question in last thread but I didnt get
> any answers, so I created new thred. I've asked what do you mean EM
> 6.5? do you mean new SQL 6.5 installation or only enterprise manager
> 6.5?
Tibor answered that:
If you want to administer a 6.5 machine from another machine, you only need
to do a client install on that machine.
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||**** Post for FREE via your newsreader at post.mcse.ms ****
Hello,
> If you want to administer a 6.5 machine from another machine, you only
need
> to do a client install on that machine.
I still have some problems and I will be very thankful for any help. I can't
see my SQL 6.5 servers from any computer. I'm stuck I don't know where the
problem is. Intergrated WinNT security setting is ok. Please help.
Darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.mcse.ms
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||On Fri, 5 Mar 2004 08:54:34 +0100, "Darius" wrote:
>I still have some problems and I will be very thankful for any help. I can'
t
>see my SQL 6.5 servers from any computer. I'm stuck I don't know where the
>problem is. Intergrated WinNT security setting is ok. Please help.
G'day Darius,
How can't you see them? Or put another way, with what can't you see
them?
Can you ping the server that SQL 6.5 is on?
Can you connect to that server with SQL Query Analyser?
Can you create an ODBC DSN for this server and test it successfully?
cheers,
Ross.
--
"It's not the right time to be sober,
Now that the idiots have taken over" - NOFX|||In Integrated Security, a 6.5 server can only listen to Named Pipes. And on
MDAC 2.6 and later, a client that work against a pre-2000 server will only
connect using the top most protocol in Client Network Utility, which is IP
by default. On the client, using Client Network Utility: Either move IP to
the top or create an alias for the 6.5 server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Darius" <darius.ram@.takas.lt> wrote in message
news:404823e8@.post.mcse.ms...
> **** Post for FREE via your newsreader at post.mcse.ms ****
> Hello,
>
> need
> I still have some problems and I will be very thankful for any help. I
can't
> see my SQL 6.5 servers from any computer. I'm stuck I don't know where the
> problem is. Intergrated WinNT security setting is ok. Please help.
> Darius
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> *** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.mcse.ms
> Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Hi,
I can't see SQL 6.5 server installed on other computer. I am trying to
connect to it using SQL 2000, ODBC, ADO and none of this is helping. I
haven't experienced the same problems with SQL2000 installation. I have
installed it and all went ok. I do not change anyu network setting on this
computer and install SQL 6.5 and then i can't see this server. Maybe there
is some quick guide how to set SQL 6.5 as it seems to me that default
configuration do not work.
darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.mcse.ms
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=Darius wrote:
> I can't see SQL 6.5 server installed on other computer. I am trying to
> connect to it using SQL 2000, ODBC, ADO and none of this is helping. I
> haven't experienced the same problems with SQL2000 installation. I
> have installed it and all went ok. I do not change anyu network
> setting on this computer and install SQL 6.5 and then i can't see
> this server. Maybe there is some quick guide how to set SQL 6.5 as it
> seems to me that default configuration do not work.
Tibor already answered the EM question in your previous thread (please do
not create new threads if it is not needed). 7.0 or 2000 EM cannot work
against 6.5 or earlier. You need EM 6.5 for that.
Please post the connection string for ODBC/ADO approach.
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||**** Post for FREE via your newsreader at post.mcse.ms ****
> Tibor already answered the EM question in your previous thread (please do
> not create new threads if it is not needed). 7.0 or 2000 EM cannot work
> against 6.5 or earlier. You need EM 6.5 for that.
I know. I have asked one more question in last thread but I didnt get any
answers, so I created new thred. I've asked what do you mean EM 6.5? do you
mean new SQL 6.5 installation or only enterprise manager 6.5?
darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.mcse.ms
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||Darius wrote:
> I know. I have asked one more question in last thread but I didnt get
> any answers, so I created new thred. I've asked what do you mean EM
> 6.5? do you mean new SQL 6.5 installation or only enterprise manager
> 6.5?
Tibor answered that:
If you want to administer a 6.5 machine from another machine, you only need
to do a client install on that machine.
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||**** Post for FREE via your newsreader at post.mcse.ms ****
Hello,
> If you want to administer a 6.5 machine from another machine, you only
need
> to do a client install on that machine.
I still have some problems and I will be very thankful for any help. I can't
see my SQL 6.5 servers from any computer. I'm stuck I don't know where the
problem is. Intergrated WinNT security setting is ok. Please help.
Darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.mcse.ms
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||On Fri, 5 Mar 2004 08:54:34 +0100, "Darius" wrote:
>I still have some problems and I will be very thankful for any help. I can'
t
>see my SQL 6.5 servers from any computer. I'm stuck I don't know where the
>problem is. Intergrated WinNT security setting is ok. Please help.
G'day Darius,
How can't you see them? Or put another way, with what can't you see
them?
Can you ping the server that SQL 6.5 is on?
Can you connect to that server with SQL Query Analyser?
Can you create an ODBC DSN for this server and test it successfully?
cheers,
Ross.
--
"It's not the right time to be sober,
Now that the idiots have taken over" - NOFX|||In Integrated Security, a 6.5 server can only listen to Named Pipes. And on
MDAC 2.6 and later, a client that work against a pre-2000 server will only
connect using the top most protocol in Client Network Utility, which is IP
by default. On the client, using Client Network Utility: Either move IP to
the top or create an alias for the 6.5 server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Darius" <darius.ram@.takas.lt> wrote in message
news:404823e8@.post.mcse.ms...
> **** Post for FREE via your newsreader at post.mcse.ms ****
> Hello,
>
> need
> I still have some problems and I will be very thankful for any help. I
can't
> see my SQL 6.5 servers from any computer. I'm stuck I don't know where the
> problem is. Intergrated WinNT security setting is ok. Please help.
> Darius
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> *** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.mcse.ms
> Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Subscribe to:
Posts (Atom)