Linked Servers in a sentence or two: Linked servers in SQL Server are connection definitions from one data source to another (or same instance) so that queries can be written joining tables spanning the multiple data sources. Although Linked Servers can be made to other data sources besides SQL Server (as we saw on how … Continue reading SQL Server: Curse Of Linked Server Security And The Fix – Pass-through Authentication
You try to login to SQL Server and you get a really nasty message: The key data in the error message At first glance, it appears to be utterly useless. The only useful message seems to be “Login failed for user 'myuser'.” but what we really need to know is “why?”. That information is somewhat … Continue reading SQL Server – Login failed for user ‘[username]’ – How to troubleshoot?