Is the SSMS connect drop down list full of old server names? Delete the mru.dat file for SQL Server 2005 or 2008 to clear it and start fresh.
SQL SERVER – Fix : Error: 4064 – Cannot open user default database. Login failed. Login failed for user
Error 4064, cannot open user default database, shows up when a login’s default database was dropped. Connect to master first, then change the default.
Encrypting Connections to SQL Server
Encrypting connections to SQL Server requires a trusted certificate, careful Force Encryption rollout, and tests with real drivers.
SQL SERVER – Fix : Error : Login failed for user ‘UserName’. The user is not associated with a trusted SQL Server connection
Login failed, not associated with a trusted SQL Server connection? I hit it between SQL Server 2008 and 2005 and fixed it with a matching Windows user.
SQL SERVER – Stored Procedure WITH ENCRYPTION and Execution Plan
Here is what I found about WITH ENCRYPTION and execution plan: an encrypted SP hides its actual execution plan too. Two sample SPs show it.
SQL SERVER – DECLARE Multiple Variables in One Statement
Yes, you can DECLARE multiple variables in one statement in SQL Server. Compare both methods side by side: one statement per variable, or all in one line.
Tracking Job Failures Across Servers
Tracking job failures across servers takes a daily msdb report, a central instance list, and notifications that reach someone who can act.