MS SQL Server Connectivity - Client software

Author

Client software

andespoint

2006-02-28, 8:24 pm

I have several developers that want access to my SQL server and I was
wondering instead of giving them Remote desktop access to access Enterprise
manager. I am going to install the SQL client tools locally on their PC.

My SQL server is behind a firewall, does anyone know what port needs to be
opened so I can see my SQL server in my list of available SQL servers.
Because I see all my SQL server on the local network, but not ones on other
networks.

Hope this makes some sense. Thanks for the help.

Sue Hoegemeier

2006-02-28, 8:24 pm

The following article answers questions related to firewall
ports:
INF: TCP Ports Needed for Communication to SQL Server
Through a Firewall
http://support.microsoft.com/?id=287932

However, what servers are listed in whatever tool drop downs
doesn't necessarily mean you have an issue with the firewall
ports. What servers are listed may not be a complete list
due to broadcast issues, network routers/subnet issues,
instances may not respond within the timeout period, etc.
The network architecture, configuration to wherever this SQL
Server box lives would be another factor.
You can always type in an IP address or a server name if a
server doesn't show up in the list.

-Sue

On Mon, 27 Feb 2006 12:38:02 -0500, "andespoint"
< andespoint@nospam_ya
hoo.com> wrote:

>I have several developers that want access to my SQL server and I was
>wondering instead of giving them Remote desktop access to access Enterprise
>manager. I am going to install the SQL client tools locally on their PC.
>
>My SQL server is behind a firewall, does anyone know what port needs to be
>opened so I can see my SQL server in my list of available SQL servers.
>Because I see all my SQL server on the local network, but not ones on other
>networks.
>
>Hope this makes some sense. Thanks for the help.
>

Sponsored Links