Client software

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.
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_yahoo.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.
>

Client software

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.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_yahoo.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.
>

Client installation of sql server

Hi,
I have both client and server of 2000 version sql server installed on my xp
machine. However, I need to install 2005 sql server client software on the
same machine. After I install this, I cannot see the program. Do I have to
unstall 2000 client software to work on 2005 client software. I would
appreciate any help on this matter.
Thanks in advanceThanks for your help Sailesh. I appreciate it.
"Shailesh Khanal" wrote:
> No, you can use both clients side by side. Check the log file in setup
> bootstarp folder to see if the installation was successful.
> "Jack" wrote:
> > Hi,
> > I have both client and server of 2000 version sql server installed on my xp
> > machine. However, I need to install 2005 sql server client software on the
> > same machine. After I install this, I cannot see the program. Do I have to
> > unstall 2000 client software to work on 2005 client software. I would
> > appreciate any help on this matter.
> > Thanks in advance|||> I have both client and server of 2000 version sql server installed on my xp
> machine. However, I need to install 2005 sql server client software on the
> same machine. After I install this, I cannot see the program.
What "program" is it that you don't see? SQL Server management studio? If so, perhaps you didn't
select to install the workstation components when you installed 2005?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:5A0F5715-35F7-437B-8E5B-3C920DB09FA1@.microsoft.com...
> Hi,
> I have both client and server of 2000 version sql server installed on my xp
> machine. However, I need to install 2005 sql server client software on the
> same machine. After I install this, I cannot see the program. Do I have to
> unstall 2000 client software to work on 2005 client software. I would
> appreciate any help on this matter.
> Thanks in advance|||No, you can use both clients side by side. Check the log file in setup
bootstarp folder to see if the installation was successful.
"Jack" wrote:
> Hi,
> I have both client and server of 2000 version sql server installed on my xp
> machine. However, I need to install 2005 sql server client software on the
> same machine. After I install this, I cannot see the program. Do I have to
> unstall 2000 client software to work on 2005 client software. I would
> appreciate any help on this matter.
> Thanks in advance