Server not configured for DATA ACCESS

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

mimorr SSCarpal Tunnel Points: 4850 More actions · Answer 1

For some reason, I find I need to set this when I install a new instance:

I think there is a checkmark in the Linked Server properties, but the setting gets confused.

sp_serveroption @server = 'servername'

,@optname = 'DATA ACCESS'

,@optvalue = 'TRUE'

Michelle

SQLGlenn Ten Centuries Points: 1370 More actions · Answer 2

Ten Centuries

Points: 1370

November 16, 2004 at 3:41 pm

Thanks, Michelle. That did the trick.

sarathi-380886 SSC Enthusiast Points: 103 More actions · Answer 3

Thanks a lot. it worked. u answerd for some one. but it helped me indeed.

Cookies on SQLServerCentral