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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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.
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.
[ @rmtuser = ] 'rmtuser'
Is the remote login used to connect to
FALSE. When the remote server is an instance of SQL Server that does not use Windows Authentication,
rmtuseris a SQL Server login.