not configured for DATA ACCESS

• hhp

  Right there with Babe

  Points: 756

  More actions

  February 10, 2003 at 8:22 am

  #64104

  I need to connect to a remote SQL server.

  1) I used sp_addlinkedserver

  USE master

  GO

  EXEC sp_addlinkedserver

  '[MyServer]',

  N'SQL Server'

  GO

  Server Added

  2)

  select * from MyServer.PUBS.DBO.AUTHORS

  Error:

  Server 'MyServer' is not configured for DATA ACCESS.

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  February 10, 2003 at 9:34 am

  #448546

  From EM, Go to security --> Linked Servers and right click the linked server --> property --> Server Option Tab --> Enable server access option.