Accessing SQL 2005 Express from QA

• Sathish Kumar. Rajaram

  Mr or Mrs. 500

  Points: 581

  More actions

  March 2, 2006 at 3:02 am

  #167229

  Hi all

  I have installed SQL 2005 Express in my test environment. I have installed SQL Server Management Studio to access this server.

  Now I try access this through SQL QA from other machine. But it throws an error "Specified SQL server not found". I have configured the TCP/IP protocol fon port 1433.

  Is it possible to connect to the SQL 2005 Express using SQL QA? Can anyone advice me on this.

   

  S A T ...
  Sathish's Blog

• Charles Otten

  Default port

  Points: 1475

  More actions

  March 2, 2006 at 6:23 am

  #624272

  To my knowledge, Query Analyzer for SQL Server 2000 will not connect to a SQL 2005 database.  I could be wrong, but I'm pretty sure it can't.

  If the phone doesn't ring...It's me.

• Steve-3_5_7_9

  SSChampion

  Points: 10832

  More actions

  March 3, 2006 at 6:40 am

  #624578

  You can connect, you just can't run any queries.  Pretty useless.