3

I'm using SQL Server 2016 (SP1) Standard Edition.

I have a linked server that uses Windows Authentication and needs to because it connects to a non-SQL Server database. It uses an OLE database provider. I have a third-party application that needs to use this linked server, but its application connects using SQL Server Authentication. Is there a way to allow a SQL Server login to use this linked server?

jarlh
  • 173
  • 4
sqltracy
  • 31
  • 3

1 Answers1

2

Is there a way to allow a SQL Server login to use this linked server [with Windows auth]?

No. A linked server can use Windows auth only by impersonating a Windows Login.

Of course if the OleDb provider has internally implemented NTLM auth and accepts a password, then it would work, but I don't know of any OleDb provider that has done that. Certainly no Microsoft OleDb provider has.

David Browne - Microsoft
  • 49,000
  • 3
  • 53
  • 102