Blitz Result: Linked Server

Linked servers make it possible to query between different database servers, almost as the different databases were on the same server. It’s easy to configure a linked server to use the wrong security permissions. Changes in SQL Server 2008 pretty much require high security privileges for good linked server performance.

This part of our SQL Server sp_Blitz script checks sys.servers looking for linked servers.

To Fix the Problem

Check security permissions on your linked servers. It’s very easy to configure a linked server to connect as a highly privileged account. Unfortunately, any user who can query the linked server may get admin-level permissions.

After the change, test query performance and making some administrative level changes through a linked server.

Return to sp_Blitz or