Results 1 to 2 of 2

Thread: Linked

  1. #1
    Join Date
    Aug 2009
    Posts
    1

    Linked

    I have some SQL Servers and I would like to use Linkedserver but when I try to use an impersonation it can't login

    Mens. 18456, Nivel 14, Estado 1, LĂ*nea 1
    Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.


    The use who start ALL my SQL Server is the same, a specific account of the Windows Domain (mydomain\SQLUser), this user is member of a group called mydomain\SQL-Admin which has sysadmin role on ALL SQL Server.

    My user is member of same group (SQL-Admin)

    Te security tab:



    Where is the problem? how can fix this problem?

    Thanks!

  2. #2
    Join Date
    Feb 2009
    Posts
    17
    Try linking the SQL instances utlizing the default admininstrator name (sa) and the password you defned for the SQL Admin when you set up each instance.

    Hope this helps,

    Larry D
    MSAE

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •