Post reply

another "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection." post :)

  • August 22, 2011 at 5:51 am

    #1371354

    Have you tried switching to use "using this security context" and specify the domain and group?

    Tom

  • August 22, 2011 at 6:25 am

    #1371366

    wouldn't that then restrict the use of the link to people in that group? at the moment we have a service account using it too which works fine.

  • August 22, 2011 at 5:47 pm

    #1371747

    Sarah Orange (8/22/2011)

    wouldn't that then restrict the use of the link to people in that group? at the moment we have a service account using it too which works fine.

    Yes, it would. So you would have to add a separate linkedserverlogin for that service account, specifying that it uses its own credentials. This would be a pain if you have a lot of such accounts.

    I seem to remember an option to specity the security for "all other accounts" (ie what to do with accounts for which you haven't specified what credentials to use at the remote server, but I can't find any documentation for it in BoL, and I don't have a 2005 installation that I can play with to see if it shows up in SSMS. If that option does exist it would make things simpler.

    Tom

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

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