I established a VPN tunnel to my network at work to test merge replication.
While I am able to connect via VPN to my network and ping the server in
which the SQL server resides, I am not able to establish a connection to the
Sql Server to register in my Enterprise Manager. The error I get is "Sql
Server does not exist or Connection OPen [Connect()]. I am running Win2k
Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The server
is a win 2k Server with the same updates as my station. Sql Server in both
sides is 2000. The connection method is through DSL. Only two of close to
50 vpn subscribers in my network are experiencing this problem. The
firewall is a Watchguard 2500 firebox, router is a cisco router and the
switch is an HP switch. Some of the other subscribers are also DSL. My
gateway at home is a 2Gateway wireless portal.
Thanks for any help any of you may provide.Run the following command to make sure you can connect to the server through
the sql port, which is 1433 by default:
telnet servername_or_ip 1433
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:%23%23Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> I established a VPN tunnel to my network at work to test merge
replication.
> While I am able to connect via VPN to my network and ping the server in
> which the SQL server resides, I am not able to establish a connection to
the
> Sql Server to register in my Enterprise Manager. The error I get is "Sql
> Server does not exist or Connection OPen [Connect()]. I am running Win2k
> Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The
server
> is a win 2k Server with the same updates as my station. Sql Server in
both
> sides is 2000. The connection method is through DSL. Only two of close
to
> 50 vpn subscribers in my network are experiencing this problem. The
> firewall is a Watchguard 2500 firebox, router is a cisco router and the
> switch is an HP switch. Some of the other subscribers are also DSL. My
> gateway at home is a 2Gateway wireless portal.
> Thanks for any help any of you may provide.
>|||Hi,
Can you create a Alias server using "CLient network utility with the
protocol as TCP/IP , IPaddress and Port number.
After that try connecting to SQL server using the Alias name you just
created.
Thanks
Hari
MCDBA
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:##Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> I established a VPN tunnel to my network at work to test merge
replication.
> While I am able to connect via VPN to my network and ping the server in
> which the SQL server resides, I am not able to establish a connection to
the
> Sql Server to register in my Enterprise Manager. The error I get is "Sql
> Server does not exist or Connection OPen [Connect()]. I am running Win2k
> Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The
server
> is a win 2k Server with the same updates as my station. Sql Server in
both
> sides is 2000. The connection method is through DSL. Only two of close
to
> 50 vpn subscribers in my network are experiencing this problem. The
> firewall is a Watchguard 2500 firebox, router is a cisco router and the
> switch is an HP switch. Some of the other subscribers are also DSL. My
> gateway at home is a 2Gateway wireless portal.
> Thanks for any help any of you may provide.
>
Showing posts with label vpn. Show all posts
Showing posts with label vpn. Show all posts
Friday, February 24, 2012
Cannot connect to SQL Server through VPN
I established a VPN tunnel to my network at work to test merge replication.
While I am able to connect via VPN to my network and ping the server in
which the SQL server resides, I am not able to establish a connection to the
Sql Server to register in my Enterprise Manager. The error I get is "Sql
Server does not exist or Connection OPen [Connect()]. I am running Win2
k
Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The server
is a win 2k Server with the same updates as my station. Sql Server in both
sides is 2000. The connection method is through DSL. Only two of close to
50 vpn subscribers in my network are experiencing this problem. The
firewall is a Watchguard 2500 firebox, router is a cisco router and the
switch is an HP switch. Some of the other subscribers are also DSL. My
gateway at home is a 2Gateway wireless portal.
Thanks for any help any of you may provide.Run the following command to make sure you can connect to the server through
the sql port, which is 1433 by default:
telnet servername_or_ip 1433
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:%23%23Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> I established a VPN tunnel to my network at work to test merge
replication.
> While I am able to connect via VPN to my network and ping the server in
> which the SQL server resides, I am not able to establish a connection to
the
> Sql Server to register in my Enterprise Manager. The error I get is "Sql
> Server does not exist or Connection OPen [Connect()]. I am running Wi
n2k
> Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The
server
> is a win 2k Server with the same updates as my station. Sql Server in
both
> sides is 2000. The connection method is through DSL. Only two of close
to
> 50 vpn subscribers in my network are experiencing this problem. The
> firewall is a Watchguard 2500 firebox, router is a cisco router and the
> switch is an HP switch. Some of the other subscribers are also DSL. My
> gateway at home is a 2Gateway wireless portal.
> Thanks for any help any of you may provide.
>|||Hi,
Can you create a Alias server using "CLient network utility with the
protocol as TCP/IP , IPaddress and Port number.
After that try connecting to SQL server using the Alias name you just
created.
Thanks
Hari
MCDBA
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:##Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> I established a VPN tunnel to my network at work to test merge
replication.
> While I am able to connect via VPN to my network and ping the server in
> which the SQL server resides, I am not able to establish a connection to
the
> Sql Server to register in my Enterprise Manager. The error I get is "Sql
> Server does not exist or Connection OPen [Connect()]. I am running Wi
n2k
> Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The
server
> is a win 2k Server with the same updates as my station. Sql Server in
both
> sides is 2000. The connection method is through DSL. Only two of close
to
> 50 vpn subscribers in my network are experiencing this problem. The
> firewall is a Watchguard 2500 firebox, router is a cisco router and the
> switch is an HP switch. Some of the other subscribers are also DSL. My
> gateway at home is a 2Gateway wireless portal.
> Thanks for any help any of you may provide.
>|||Hari:
Thanks for replying but was one of the first things I've tried...
Any other Idea's?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23qqDBDyAEHA.3248@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Can you create a Alias server using "CLient network utility with the
> protocol as TCP/IP , IPaddress and Port number.
> After that try connecting to SQL server using the Alias name you just
> created.
> Thanks
> Hari
> MCDBA
>
> "Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
> news:##Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> replication.
> the
"Sql
Win2k
> server
> both
> to
>|||What port is your SQL server listening on? Check the router at home to
verify you can access that port.
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:OAtI5tUBEHA.576@.TK2MSFTNGP11.phx.gbl...
> Hari:
> Thanks for replying but was one of the first things I've tried...
> Any other Idea's?
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23qqDBDyAEHA.3248@.TK2MSFTNGP11.phx.gbl...
in
to
> "Sql
> Win2k
close
the
My
>|||My suggestion would be to make network traces on both the client and the
server. This will tell you if the traffic is ever reaching the server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
While I am able to connect via VPN to my network and ping the server in
which the SQL server resides, I am not able to establish a connection to the
Sql Server to register in my Enterprise Manager. The error I get is "Sql
Server does not exist or Connection OPen [Connect()]. I am running Win2
k
Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The server
is a win 2k Server with the same updates as my station. Sql Server in both
sides is 2000. The connection method is through DSL. Only two of close to
50 vpn subscribers in my network are experiencing this problem. The
firewall is a Watchguard 2500 firebox, router is a cisco router and the
switch is an HP switch. Some of the other subscribers are also DSL. My
gateway at home is a 2Gateway wireless portal.
Thanks for any help any of you may provide.Run the following command to make sure you can connect to the server through
the sql port, which is 1433 by default:
telnet servername_or_ip 1433
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:%23%23Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> I established a VPN tunnel to my network at work to test merge
replication.
> While I am able to connect via VPN to my network and ping the server in
> which the SQL server resides, I am not able to establish a connection to
the
> Sql Server to register in my Enterprise Manager. The error I get is "Sql
> Server does not exist or Connection OPen [Connect()]. I am running Wi
n2k
> Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The
server
> is a win 2k Server with the same updates as my station. Sql Server in
both
> sides is 2000. The connection method is through DSL. Only two of close
to
> 50 vpn subscribers in my network are experiencing this problem. The
> firewall is a Watchguard 2500 firebox, router is a cisco router and the
> switch is an HP switch. Some of the other subscribers are also DSL. My
> gateway at home is a 2Gateway wireless portal.
> Thanks for any help any of you may provide.
>|||Hi,
Can you create a Alias server using "CLient network utility with the
protocol as TCP/IP , IPaddress and Port number.
After that try connecting to SQL server using the Alias name you just
created.
Thanks
Hari
MCDBA
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:##Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> I established a VPN tunnel to my network at work to test merge
replication.
> While I am able to connect via VPN to my network and ping the server in
> which the SQL server resides, I am not able to establish a connection to
the
> Sql Server to register in my Enterprise Manager. The error I get is "Sql
> Server does not exist or Connection OPen [Connect()]. I am running Wi
n2k
> Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The
server
> is a win 2k Server with the same updates as my station. Sql Server in
both
> sides is 2000. The connection method is through DSL. Only two of close
to
> 50 vpn subscribers in my network are experiencing this problem. The
> firewall is a Watchguard 2500 firebox, router is a cisco router and the
> switch is an HP switch. Some of the other subscribers are also DSL. My
> gateway at home is a 2Gateway wireless portal.
> Thanks for any help any of you may provide.
>|||Hari:
Thanks for replying but was one of the first things I've tried...
Any other Idea's?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23qqDBDyAEHA.3248@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Can you create a Alias server using "CLient network utility with the
> protocol as TCP/IP , IPaddress and Port number.
> After that try connecting to SQL server using the Alias name you just
> created.
> Thanks
> Hari
> MCDBA
>
> "Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
> news:##Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> replication.
> the
"Sql
Win2k
> server
> both
> to
>|||What port is your SQL server listening on? Check the router at home to
verify you can access that port.
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:OAtI5tUBEHA.576@.TK2MSFTNGP11.phx.gbl...
> Hari:
> Thanks for replying but was one of the first things I've tried...
> Any other Idea's?
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23qqDBDyAEHA.3248@.TK2MSFTNGP11.phx.gbl...
in
to
> "Sql
> Win2k
close
the
My
>|||My suggestion would be to make network traces on both the client and the
server. This will tell you if the traffic is ever reaching the server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Cannot connect to SQL Server through VPN
I established a VPN tunnel to my network at work to test merge replication.
While I am able to connect via VPN to my network and ping the server in
which the SQL server resides, I am not able to establish a connection to the
Sql Server to register in my Enterprise Manager. The error I get is "Sql
Server does not exist or Connection OPen [Connect()]. I am running Win2
k
Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The server
is a win 2k Server with the same updates as my station. Sql Server in both
sides is 2000. The connection method is through DSL. Only two of close to
50 vpn subscribers in my network are experiencing this problem. The
firewall is a Watchguard 2500 firebox, router is a cisco router and the
switch is an HP switch. Some of the other subscribers are also DSL. My
gateway at home is a 2Gateway wireless portal.
Thanks for any help any of you may provide.Run the following command to make sure you can connect to the server through
the sql port, which is 1433 by default:
telnet servername_or_ip 1433
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:%23%23Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> I established a VPN tunnel to my network at work to test merge
replication.
> While I am able to connect via VPN to my network and ping the server in
> which the SQL server resides, I am not able to establish a connection to
the
> Sql Server to register in my Enterprise Manager. The error I get is "Sql
> Server does not exist or Connection OPen [Connect()]. I am running Wi
n2k
> Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The
server
> is a win 2k Server with the same updates as my station. Sql Server in
both
> sides is 2000. The connection method is through DSL. Only two of close
to
> 50 vpn subscribers in my network are experiencing this problem. The
> firewall is a Watchguard 2500 firebox, router is a cisco router and the
> switch is an HP switch. Some of the other subscribers are also DSL. My
> gateway at home is a 2Gateway wireless portal.
> Thanks for any help any of you may provide.
>|||Hi,
Can you create a Alias server using "CLient network utility with the
protocol as TCP/IP , IPaddress and Port number.
After that try connecting to SQL server using the Alias name you just
created.
Thanks
Hari
MCDBA
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:##Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> I established a VPN tunnel to my network at work to test merge
replication.
> While I am able to connect via VPN to my network and ping the server in
> which the SQL server resides, I am not able to establish a connection to
the
> Sql Server to register in my Enterprise Manager. The error I get is "Sql
> Server does not exist or Connection OPen [Connect()]. I am running Wi
n2k
> Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The
server
> is a win 2k Server with the same updates as my station. Sql Server in
both
> sides is 2000. The connection method is through DSL. Only two of close
to
> 50 vpn subscribers in my network are experiencing this problem. The
> firewall is a Watchguard 2500 firebox, router is a cisco router and the
> switch is an HP switch. Some of the other subscribers are also DSL. My
> gateway at home is a 2Gateway wireless portal.
> Thanks for any help any of you may provide.
>|||Hari:
Thanks for replying but was one of the first things I've tried...
Any other Idea's?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23qqDBDyAEHA.3248@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Can you create a Alias server using "CLient network utility with the
> protocol as TCP/IP , IPaddress and Port number.
> After that try connecting to SQL server using the Alias name you just
> created.
> Thanks
> Hari
> MCDBA
>
> "Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
> news:##Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> replication.
> the
"Sql
Win2k
> server
> both
> to
>|||What port is your SQL server listening on? Check the router at home to
verify you can access that port.
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:OAtI5tUBEHA.576@.TK2MSFTNGP11.phx.gbl...
> Hari:
> Thanks for replying but was one of the first things I've tried...
> Any other Idea's?
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23qqDBDyAEHA.3248@.TK2MSFTNGP11.phx.gbl...
in
to
> "Sql
> Win2k
close
the
My
>
While I am able to connect via VPN to my network and ping the server in
which the SQL server resides, I am not able to establish a connection to the
Sql Server to register in my Enterprise Manager. The error I get is "Sql
Server does not exist or Connection OPen [Connect()]. I am running Win2
k
Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The server
is a win 2k Server with the same updates as my station. Sql Server in both
sides is 2000. The connection method is through DSL. Only two of close to
50 vpn subscribers in my network are experiencing this problem. The
firewall is a Watchguard 2500 firebox, router is a cisco router and the
switch is an HP switch. Some of the other subscribers are also DSL. My
gateway at home is a 2Gateway wireless portal.
Thanks for any help any of you may provide.Run the following command to make sure you can connect to the server through
the sql port, which is 1433 by default:
telnet servername_or_ip 1433
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:%23%23Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> I established a VPN tunnel to my network at work to test merge
replication.
> While I am able to connect via VPN to my network and ping the server in
> which the SQL server resides, I am not able to establish a connection to
the
> Sql Server to register in my Enterprise Manager. The error I get is "Sql
> Server does not exist or Connection OPen [Connect()]. I am running Wi
n2k
> Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The
server
> is a win 2k Server with the same updates as my station. Sql Server in
both
> sides is 2000. The connection method is through DSL. Only two of close
to
> 50 vpn subscribers in my network are experiencing this problem. The
> firewall is a Watchguard 2500 firebox, router is a cisco router and the
> switch is an HP switch. Some of the other subscribers are also DSL. My
> gateway at home is a 2Gateway wireless portal.
> Thanks for any help any of you may provide.
>|||Hi,
Can you create a Alias server using "CLient network utility with the
protocol as TCP/IP , IPaddress and Port number.
After that try connecting to SQL server using the Alias name you just
created.
Thanks
Hari
MCDBA
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:##Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> I established a VPN tunnel to my network at work to test merge
replication.
> While I am able to connect via VPN to my network and ping the server in
> which the SQL server resides, I am not able to establish a connection to
the
> Sql Server to register in my Enterprise Manager. The error I get is "Sql
> Server does not exist or Connection OPen [Connect()]. I am running Wi
n2k
> Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The
server
> is a win 2k Server with the same updates as my station. Sql Server in
both
> sides is 2000. The connection method is through DSL. Only two of close
to
> 50 vpn subscribers in my network are experiencing this problem. The
> firewall is a Watchguard 2500 firebox, router is a cisco router and the
> switch is an HP switch. Some of the other subscribers are also DSL. My
> gateway at home is a 2Gateway wireless portal.
> Thanks for any help any of you may provide.
>|||Hari:
Thanks for replying but was one of the first things I've tried...
Any other Idea's?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23qqDBDyAEHA.3248@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Can you create a Alias server using "CLient network utility with the
> protocol as TCP/IP , IPaddress and Port number.
> After that try connecting to SQL server using the Alias name you just
> created.
> Thanks
> Hari
> MCDBA
>
> "Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
> news:##Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> replication.
> the
"Sql
Win2k
> server
> both
> to
>|||What port is your SQL server listening on? Check the router at home to
verify you can access that port.
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:OAtI5tUBEHA.576@.TK2MSFTNGP11.phx.gbl...
> Hari:
> Thanks for replying but was one of the first things I've tried...
> Any other Idea's?
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23qqDBDyAEHA.3248@.TK2MSFTNGP11.phx.gbl...
in
to
> "Sql
> Win2k
close
the
My
>
Friday, February 10, 2012
cannot connect to a named instance via TCP/IP
Are you connecting to your office through VPN or is your
firewall just configured to allow you to access port 1433?
If it is the latter, you must configure your firewall to
allow you access on the port that the named instance is
listening on (each instance has its own port and only the
default instance will be listening on 1433). You can
find the port the named instance is using by looking at
the TCP/IP properties for the instance in the server
network utility.
Hope this helps.
Tim
office.
sql server, say SQL_instance1.
named instance from my home workstation. Therefore, I
have already set a portmapping (1433) on my company
firewall and use the IP address, say 61.88.17.3, to
connect the sql server at my home.
the EM and the error message is "SQL server not found or
access denied". I am sure the login name and password is
correct and the firewall setting is correct also (Since I
can use telnet to connect the server, the command is :
telnet 61.88.17.3 1433).
remote sql server in my workstation EM.
I use 1433 for my named instance and the I have configured the firewall to a
llow 1433.
I even try to configure the firewall to allow all TCP/IP, but I still cannot
connect to my SQL server.
-- Tim Richardson wrote: --
Are you connecting to your office through VPN or is your
firewall just configured to allow you to access port 1433?
If it is the latter, you must configure your firewall to
allow you access on the port that the named instance is
listening on (each instance has its own port and only the
default instance will be listening on 1433). You can
find the port the named instance is using by looking at
the TCP/IP properties for the instance in the server
network utility.
Hope this helps.
Tim
sql server, say SQL_instance1.
named instance from my home workstation. Therefore, I
have already set a portmapping (1433) on my company
firewall and use the IP address, say 61.88.17.3, to
connect the sql server at my home.
the EM and the error message is "SQL server not found or
access denied". I am sure the login name and password is
correct and the firewall setting is correct also (Since I
can use telnet to connect the server, the command is :
telnet 61.88.17.3 1433).
firewall just configured to allow you to access port 1433?
If it is the latter, you must configure your firewall to
allow you access on the port that the named instance is
listening on (each instance has its own port and only the
default instance will be listening on 1433). You can
find the port the named instance is using by looking at
the TCP/IP properties for the instance in the server
network utility.
Hope this helps.
Tim
quote:
>--Original Message--
>Hi all,
>I have a SQL server running on a WIN2k server at my
office.
quote:
>I have an application running on a named instance of the
sql server, say SQL_instance1.
quote:
>Due to some reason, I have to connect to the SQL server
named instance from my home workstation. Therefore, I
have already set a portmapping (1433) on my company
firewall and use the IP address, say 61.88.17.3, to
connect the sql server at my home.
quote:
>However, I find that I cannot register the sql server at
the EM and the error message is "SQL server not found or
access denied". I am sure the login name and password is
correct and the firewall setting is correct also (Since I
can use telnet to connect the server, the command is :
telnet 61.88.17.3 1433).
quote:
>Anyone know how to solve this problem '
>I use the following connection string to register the
remote sql server in my workstation EM.
quote:thx for your reply.
>61.88.17.3\SQL_instance1
>Thank in advance
>Regards,
>ong
>.
>
I use 1433 for my named instance and the I have configured the firewall to a
llow 1433.
I even try to configure the firewall to allow all TCP/IP, but I still cannot
connect to my SQL server.
-- Tim Richardson wrote: --
Are you connecting to your office through VPN or is your
firewall just configured to allow you to access port 1433?
If it is the latter, you must configure your firewall to
allow you access on the port that the named instance is
listening on (each instance has its own port and only the
default instance will be listening on 1433). You can
find the port the named instance is using by looking at
the TCP/IP properties for the instance in the server
network utility.
Hope this helps.
Tim
quote:
>--Original Message--
>Hi all,
office.[QUOTE]
>I have an application running on a named instance of the
sql server, say SQL_instance1.
quote:
>Due to some reason, I have to connect to the SQL server
named instance from my home workstation. Therefore, I
have already set a portmapping (1433) on my company
firewall and use the IP address, say 61.88.17.3, to
connect the sql server at my home.
quote:
>However, I find that I cannot register the sql server at
the EM and the error message is "SQL server not found or
access denied". I am sure the login name and password is
correct and the firewall setting is correct also (Since I
can use telnet to connect the server, the command is :
telnet 61.88.17.3 1433).
quote:
>Anyone know how to solve this problem '
remote sql server in my workstation EM.[QUOTE]
>61.88.17.3\SQL_instance1
>ong
>.
>
Subscribe to:
Posts (Atom)