The Multifunctioning DBA:

Troubleshooting

1

January 13, 2012  5:35 PM

Strange Issue with MSSQL error 18456



Posted by: Colin Smith
18456, connectivity, SQL Server, Troubleshooting

I know that this is everyone's favorite error message that SQL Server spits out. I love it because it has so many states that can give you an idea about what the root cause of the issue is. The downside is that some of the states really do not give you any good information and are just generic. So...

July 27, 2011  8:00 AM

SQL Nexus



Posted by: Colin Smith
Tools, Troubleshooting

I use SQL Nexus all the time to identify bottlenecks of my SQL Servers and I absolutely love the tool. I ran into a small issue though where I could not always load the *.trc files. It would start and fail very quickly and move on to importing the other...


November 4, 2010  3:17 PM

Strange Error with user account connections



Posted by: Colin Smith
Login Errors, SQL Server, Troubleshooting, Windows Authentication

So this morning I was asked to help out with an issue that a user was seeing. The user has an application that uses a local account on the server to run the application and that application uses that account using windows auth to connect to a sql server on another host. So when I got the call I...


June 25, 2010  7:00 PM

SSPI errors with SQL Server 2005



Posted by: Colin Smith
SPN, SSPI, Troubleshooting

I recently had an issue with a site that was getting some users connected to a few new SQL Server 2005 instances just fine, via ODBC connections, while other users were getting SSPI errors. SSPI usually is indicative of a problem with SPN's and Kerberous Authentication. What was even more strange...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: