Linked Server Authentication

• beath

  SSCrazy

  Points: 2939

  More actions

  August 19, 2004 at 3:14 am

  #83702

  I'm trying to set up a linked server using windows authentication. On the security tab I choose "Be made using this security context" and supply a DOMAIN\USERNAME and password. Whenever I try and run a query I get "Login failed for DOMAIN\USERNAME"

  The linked server works fine if I supply a sql username.

  Both servers are running SQL 7 and the DOMAIN\USERNAME is the startup account with admin rights.

  I need to use a domain account as I'm calling remote stored procedures that work with network files.

  Thanks

• magasvs

  SSCertifiable

  Points: 7660

  More actions

  August 19, 2004 at 4:06 am

  #519723

  To use Windows NT domain accounts (mapped to themselves) with linked servers you have to configure security account delegation. Your server has to be Windows 2000 (or 2003) in domain with Active Directory with Kerberos support enabled. For configuration you will use setspn utility. Configuration is a bit complicated.

  Here is some usefull links:

  http://www.sql-server-performance.com/tb_kerberos_protocol_transition.asp

  http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1061.mspx

  http://support.microsoft.com/default.aspx?scid=kb;en-us;325894