Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GATER
Starting Member
2 Posts |
 Posted - 2006-01-26 : 07:43:46
|
| Hi, We have a local network. On the one of the PC I have installed desktop MSSQL on Windows XP, but I can not see this desktop server from another PC. What can I do to see it from another PC? Can somebody help me? Thanks. |
|
|
Stig
Starting Member
1 Post |
Posted - 2006-01-30 : 03:11:46
|
| Hi Gater,If the installation went fine & the server is running the most likely cause is a firewall blocking access.Do you use a firewall such as the built-in XP firewall ? |
 |
|
|
GATER
Starting Member
2 Posts |
Posted - 2006-02-06 : 06:18:21
|
| Hi Stig,Thanks for your advice.Following it I make the built-in XP firewall to OFF, but result is the same. I can't connect to the server from SQL Enterprise Manager. The instalation went fine and the local server is running. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-06 : 08:39:08
|
| Hi GATER, Welcome to SQL Team!Can you PING the other machine?Try connecting to it using its IP address rather than Name (i.e. set up the "remote" server in Enterprise Manager using the IP address)Can you connect to SQL using Enterprise Manager LOCALLY on the machine SQL is installed on?Make sure it is set to allow SQL Server logins (i.e. as well as Windows Authentication) and either try setting the connection from the Remote Machine to use a SQL Connection [e.g. "sa", or set up a login on the Local machine deliberately to allow that to be used from the Remote]Check that the Port Number that SQL Server is installed on is either the default, or the Remote has been configured to "call" using that Port number.On older versions of SQL Server (up to version 7 I think) there was a utility called ODBCPING. Might be worth trying to find that and using that to help with the diagnosis.Kristen |
|
|
|
|
|
|
Problem to use existing MSDE server