cannot connect to a named instance via TCP/IP

Hi all,
I have a SQL server running on a WIN2k server at my office
I have an application running on a named instance of the sql server, say SQL_instance1
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
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)
Anyone know how to solve this problem '
I use the following connection string to register the remote sql server in my workstation EM
61.88.17.3\SQL_instance
Thank in advanc
Regards
ongAre 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
>--Original Message--
>Hi all,
>I have a SQL server running on a WIN2k server at my
office.
>I have an application running on a named instance of the
sql server, say SQL_instance1.
>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.
>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).
>Anyone know how to solve this problem '
>I use the following connection string to register the
remote sql server in my workstation EM.
>61.88.17.3\SQL_instance1
>Thank in advance
>Regards,
>ong
>.
>|||thx for your reply.
I use 1433 for my named instance and the I have configured the firewall to allow 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
>--Original Message--
>Hi all,
>>I have a SQL server running on a WIN2k server at my
office.
>I have an application running on a named instance of the
sql server, say SQL_instance1.
>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.
>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).
>Anyone know how to solve this problem '
>>I use the following connection string to register the
remote sql server in my workstation EM.
>61.88.17.3\SQL_instance1
>>Thank in advance
>>Regards,
>ong
>.
>