1

I need to create a Linked Server from Server A that uses a SQL Server Authentication to a Server B that uses a Windows Authentication.

Is the "impersonation" possible?

If "YES" what options, config should I pick?

enter image description here

5
  • After some Google it looks like this is not possible (itectec.com/database/…).
    – msuzuki
    Jan 8 at 0:44
  • Which security context do you want the connection under? Will the user authenticate or the server authenticate? It's very unclear what you are trying to achieve? Jan 9 at 0:19
  • @Charlieface the Linked Server has to go from Server A that has a user registered using SQL Authentication to a user in Server B that uses Windows Authentication. I am trying to impersonate the user that uses Windows Authentication.
    – msuzuki
    Jan 10 at 12:24
  • No this cannot be done. You can only use Windows Auth if the login exists on both servers and you are connecting to Server A using that login Jan 10 at 14:12
  • thx @Charlieface you confirmed my suspicion. Do you want to make that as an answer so I can vote?
    – msuzuki
    Jan 10 at 15:25

1 Answer 1

0

As documented, this is not possible.

If you do not want to do impersonation (using the locally logged-in user on Server A to authenticate to Server B), you must specify a SQL Server Authentication login, you cannot authenticate using Windows Authentication.

The docs for SSMS say:

Remote User
Use the remote user to map user defined in Local login. The Remote User must be a SQL Server Authentication login on the remote server.

And for sp_addlinkedsrvlogin

[ @rmtuser = ] 'rmtuser'
Is the remote login used to connect to rmtsrvname when @useself is FALSE. When the remote server is an instance of SQL Server that does not use Windows Authentication, rmtuser is a SQL Server login.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.