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
>.
>
No comments:
Post a Comment