Problem with connecting to server

• ramakrishnap

  SSC Enthusiast

  Points: 141

  More actions

  July 15, 2004 at 12:20 am

  #88164

  If I try to connect to my sql server using query analyzer 'sa/password' I am getting timeout error, If I use Windows authentication I am able to connect to sqlserver.  And I can't select any database other that Master database.  I can execute only select * from sysdatabases, any other query will run forever and no results displayed. I can't connect to server using EM, it hangs.  Kindly help.

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  July 15, 2004 at 2:08 am

  #514600

  You should start sql from the command line using sqlservr.exe to view the log and check if there is any error during start up.

   

  Where you able to connect before. Any changes into the server?