Share via

Linked Server Login Limitation

Ray Milhon 21 Reputation points
2021-07-05T14:26:43.697+00:00

At our company we have several SQL Server Databases. one is at our data center one is local at our site and one is at Corporate HQ. The local SQL Server is where we run most of our reports from and we use that to link to the Data Center and Corporate HQ databases. The issue is that the Corporate uses Windows Authentication and the linked server requires SQL Server Authentication is there anyway around this limitation?

Also in asking this question there's a section below that says Tags. It's a required field but doesn't allow me to put the appropriate tag. There's a list but this issue isn't in the list and I don't have permission to create one. So I picked one at random so this question could be asked.

Developer technologies | Transact-SQL
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

SQL Server | Other

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AmeliaGu-MSFT 14,011 Reputation points Microsoft External Staff
    2021-07-09T06:45:29.69+00:00

    Hi RayMilhon-1409,

    Could you please share us the security tab in the linked server properties?
    If you are using windows authentication in the remote server, you have to select Be made using the login's current security context to connect to the remote server using the same Windows Authentication credentials in the local server. Please refer to this similar thread which might help.

    Best Regards,
    Amelia

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.