Linked Server (Msg 7411)

• esebasti

  SSC Eights!

  Points: 854

  More actions

  February 21, 2003 at 1:05 pm

  #63259

  Hi, I have a linked server configured on my report server to my prd server. When I run a query on the report server to the prd server it works fine, but when I run one from the prd server I get the following msg:

  Server: Msg 7411, Level 16, State 1, Line 1

  Server 'RPTDBPRD' is not configured for DATA ACCESS.

  Both are SQL Server 7.0, I tryed the openquery() function but same result. any ideas?

  Thanks

  E...

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  February 21, 2003 at 2:00 pm

  #449500

  You must execute:

  exec master.dbo.sp_serveroption 'RPTDBPRD', 'DATA ACCESS', True

  and should work fine