March 2008 - Posts

• CLR Safety Issues After Database Restore to New Server

  While working on finalizing the installation and configuration of SQL 2005 on a test server that I plan to upgrade to SQL 2008 Feb CTP, I ran into a snag. In order to test all the different Upgrade paths that would affect me, I have built a test server Read More... Posted Thursday, March 06, 2008 2:45 PM by Jonathan Kehayias | 1 Comments Filed under: .NET/CLR Integration

• Understanding 'login failed' (Error 18456) errors in SQL Server 2005

  One of my favorite errors that I get paged for is the login failed (error 18456). I have a few users who are guaranteed to ping me at least once or twice a week for a failed login. Generally I can tell that the user is simply trying to login to the wrong Read More... Posted Tuesday, March 04, 2008 10:24 AM by Jonathan Kehayias | 0 Comments Filed under: Error Messages