Connect To Linked Server Via Sql Server Pyodbc Connection?

I can currently connect to my SQL Server and query any database I want to directly. The problem is when I want to query a linked server. I cannot directly reference the linked serv

Solution 1:

As Sean mentioned, a linked server is just a reference to another server that's stored within the local server.

You do not need to manage 100+ user credentials though. If you have the users using Windows auth, and you have Kerberos working between the servers, the linked server can just impersonate you when it connects to the other server via the linked server definition.

Then you can use either 4 part names to refer to objects on the other server, or use OPENQUERY when you want more control over what gets executed where.

Finally, if they're both SQL Servers and both use the same collation, make sure you set the linked server option to say they are collation compatible. That can make a major difference to your linked server performance. I regularly see systems where that isn't set and it should be.