Post reply

Server not configured for DATA ACCESS

  • November 16, 2004 at 12:48 pm

    #59730

    When I try to create a view, I get the error in the subject line. Worked fine on the old server, but not the new server. Any ideas?

  • November 16, 2004 at 3:32 pm

    #530374

    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

  • November 16, 2004 at 3:41 pm

    #530377

    Thanks, Michelle. That did the trick.

  • November 7, 2006 at 8:50 pm

    #670454

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

     

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

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