Linked Server SQL 7 to 6.5 Problem

• Denis Wilkinson

  Mr or Mrs. 500

  Points: 569

  More actions

  January 5, 2004 at 5:33 am

  #83281

  Hi, I have a SQL 6.5 database that I want to query from SQL 7. When I run the query (QA) I get a message "Server: Msg 17, Level 16, State 1, Line 1

  SQL Server does not exist or access denied."

  I have checked the server is in the Linked Server section of the Security tree in EM. Also it is in the master.sysservers table, it's srvstatus is 193.

  The select statement is SELECT * FROM SERVERNAME.DATABASENAME.DBO.TABLENAME.

  Any suggestions to what may be wrong and what I can try?

  rgds

  denis

• jordanac

  Hall of Fame

  Points: 3653

  More actions

  January 5, 2004 at 5:39 am

  #488644

  Hi,

  Try select * from servername..database.dbo.table

   

   

  
  Andy.

• noeld

  SSC Guru

  Points: 96590

  More actions

  January 5, 2004 at 7:06 am

  #488648

  Check the Permissions of the security tab for the account you used in QA

   

  HTH

   

  
  * Noel