Post reply

Linked server

  • October 28, 2009 at 1:20 pm

    #385670

    Hi

    i have set up linked server and it works for me but when user try to run that they are getting some error like

    Msg 18456, Level 14, State 1, Line 1

    Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

    and they have data reader rights on other server. and datareader, data writer , ddl_admin on liked server.

    Thanks

    Kaushik Sharma

  • October 28, 2009 at 2:13 pm

    #1072059

    may be this could help

    http://support.microsoft.com/kb/238477

  • October 28, 2009 at 3:43 pm

    #1072133

    above link didnot work for me. but

    select net_transport, auth_scheme from

    sys.dm_exec_connections where session_id=@@spid

    when i run this query for client NTLM and Named pipes

    server NTLM TCP\IP

    linked server Kebroes TCP\Ip.

    is it some problem with this things?

  • October 28, 2009 at 4:04 pm

    #1072141

    What is the security configuration on the linked server? May be the user does not have permissions and you have it with the default option and the account can't be impersonated.

    You need to add the user explicitally or configure delegation.

    Regards.

    JSO

  • November 2, 2009 at 8:56 am

    #1073840

    Hi

    i have configured with made be using with current login security context. i am trying for delegation also

    thanks

    Kaushik Sharma

  • November 2, 2009 at 9:18 am

    #1073860

    I think your SQL server is running as localsystem (the one you are trying to connect FROM). Make sure it is using a windows user account, yuo can change that easily with the SQL Server Configuration Manager..

    CEWII

  • November 2, 2009 at 9:30 am

    #1073871

    Hi

    It is not under local system. it is under domain user a\c

    Thanks

    Kaushik

  • November 2, 2009 at 12:02 pm

    #1073947

    How do you have the linked server security mapped?

    Also, when you are logging into the SQL server are you using a windows account or a SQL server account?

    CEWII

  • November 3, 2009 at 1:44 pm

    #1074494

    using windows authentication

  • November 3, 2009 at 2:44 pm

    #1074538

    Boy you are the opposite of everything I'm thinking..

    Why don't you screen print the security tab on the linked server properties and using your favorite paint type program blur out anything sensitive and post that.

    Your reference to sys.dm_exec_connections only describes your connection to the local server, and it confirms TCP/IP and windows security. What protocol do you think is being used to connect to the other server. On the server machine is TCP/IP enabled as a client protocol, I am NOT talking about the sever protocol since I can already tell you it is..

    CEWII

  • February 23, 2010 at 4:30 pm

    #1123969

    In the properties for the linked server, go to the security tab. Then map the local user, you are connected as, to a 'SQL SERVER login' on the remote server. When I use Windows user then this doesnt work.

    But the local user can be a windows user.

    Make user the SQL Server login on the remote server has sufficient authority to run the query.

    Eg, if you are running select queries. Then make sure that SQL user is mapped to that database and is granted dbdatareader on that database.

    If you would like everyone accessing that linked server to have one SQL user on the remote server then at the bottom of the security tab you can specify one SQL user to be used in the linked servers context.

    Blog
    http://saveadba.blogspot.com/

  • February 23, 2010 at 10:30 pm

    #1124077

    try setting up the linked server with SQL a/c [logon ]and not domain a/c

Viewing 12 posts - 1 through 11 (of 11 total)

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