Results 1 to 12 of 12
  1. #1
    Join Date
    Nov 2006
    Posts
    13

    Unanswered: can't 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 prob

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Right-click on the application and set the option to run in XP mode. Vista sucks.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jan 2005
    Posts
    28
    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/SQLSer...nnections.aspx for more detail

    Eralper
    http://www.kodyaz.com

  4. #4
    Join Date
    Nov 2006
    Posts
    13
    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

  5. #5
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    is there a firewall in vista that you need to configure?

  6. #6
    Join Date
    Nov 2006
    Posts
    13
    No , I have disabled firewall

  7. #7
    Join Date
    Jun 2004
    Location
    Far away from heaven
    Posts
    194
    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.
    Cheers!





    !Direction is More Important than Speed!

    http://talatnauman.blogspot.com/

  8. #8
    Join Date
    Nov 2006
    Posts
    13
    I checked each 3 connection protocol (Shared Memory , TCP/IP , namedpipes), but nothing, the same error


  9. #9
    Join Date
    Jun 2004
    Location
    Far away from heaven
    Posts
    194
    make sure the sql browser service is running on the remote sql server.
    Cheers!





    !Direction is More Important than Speed!

    http://talatnauman.blogspot.com/

  10. #10
    Join Date
    Nov 2006
    Posts
    13
    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

  11. #11
    Join Date
    Nov 2006
    Posts
    13
    somebody help me plz

  12. #12
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    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.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •