Unanswered: can't connect to remote db server using SQL 2005 in Vista
I use SQL 2005 - SQL Server Management Studio to connect to my hosting SQL Server to manage my database , its about 1 month which I have installed Vista and SQL 2005 its working fine in local , but today I just wanted to connect to my remote server and I got this error :
Cannot connect to <My server IP Address>
I thought its a server problem , but its not. I tested it by connecting using same SQL 2005 on a windows xp system , the problem is only in vista,
by the way its SQL 2005 SP2
NO, you didn't get that,
The remote server which I am connecting to , is a SQL Server 2000 , and its working fine , I can easily connect to this server using SQL 2000 and 2005 through windows xp , the problem is that I can't connect to this server using SQL 2005 through windows Vista,
and I get "Cannot connect to <My server IP Address>"
I think this means its can't even connect to the server to check account details
Make sure you can access the remote server over the network!
Check the networkprotocol you are using to connect to the remote sql.
Under the connection properties of management studio==> Network protocol; choose b/w namedpipes and tcp/ip (try switching between them).
Most likely the protocol being used is namedpipes which doesn't allow connection if the client machine is not within the domain remote server is running on or if namedpipes protocol is disabled on remote server.
I wish we could, but this sounds like the sort of problem that we would have to be looking over your shoulder to spot. It would seem to be a problem with your operating systems, and not the database server, and thus may be outside the scope of our expertise.
Contact Microsquash, and when you do please tell them that blindman says Vista sucks.
If it's not practically useful, then it's practically useless.