Sunday, June 5, 2011

Linked Server errors Microsoft SQL Server, Error:7411)

Server 'ServerName' is not configured for DATA ACCESS (Microsoft SQL Server, Error: 7411)

This occurs if any of the following are not configured, even if you are trying to security.
Not be Made,be made without using a security context, login;s security context and using security context.
Data access, RPC, RPC Out, Use Remote collation has to be configured in-order to set up linked server without having 7411 error.







5 comments:

  1. is not working even i have it set the value to true. im still getting the error in my linked server connection

    ReplyDelete
  2. Thanks for posting!

    ReplyDelete
  3. Thank you, it helped me.

    ReplyDelete
  4. thank you for the posting! It is help!

    ReplyDelete