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?
These links are more for my own reference than anything else to resolve the error: "Cannot generate SSPI context" It is a pesky error message that is related to security setup. All the things you need to check are in the MS article below. How to troubleshoot the "Cannot generate SSPI context" error message In … Continue reading SQL Server – Resolve – Cannot generate SSPI context
Your users get the below error when connecting to SQL Server that has been running fine all along.Reason:What could be the reason? Quite simple. Check to see if the service is running and start it if it is not!StackOverflow always has the answers for all the other kinds of configuration issues that might cause this … Continue reading Quick Tip: No connection could be made because the target machine actively refused it