Tuesday, February 14, 2012

cant connect to remote db server using SQL 2005 in Vista

Hello
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

what can I do to solve this probRight-click on the application and set the option to run in XP mode. Vista sucks.|||Hi,
SQL 2005 is default closed for remote connections.
On the local server, you should configure SQL Server instance and let the remote connections.
You can try the article http://www.kodyaz.com/content/SQLServerdoesnotallowremoteconnections.aspx for more detail

Eralper
http://www.kodyaz.com|||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|||is there a firewall in vista that you need to configure?|||No , I have disabled firewall|||HI.
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 checked each 3 connection protocol (Shared Memory , TCP/IP , namedpipes), but nothing, the same error

:(|||make sure the sql browser service is running on the remote sql server.|||I am sure that everything on the remote sql server is ok , because I easily connect to server with windows xp and sql 2005 the problem is only in windows vista and sql 2005|||somebody help me plz|||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.

No comments:

Post a Comment