Can I use a linked server that uses Windows Authentication when I'm logged in with SQL Authentication?

3 votes

1 answer

154 views

sql-server linked-server authentication oledb windows-authentication

                          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?

Asked by sqltracy (31 rep)

Jan 6, 2025, 07:25 PM
Last activity: Jan 9, 2025, 11:58 AM

Can I use a linked server that uses Windows Authentication when I'm logged in with SQL Authentication?

Related Questions