When you open SQL Server Management Studio and try to connect to an SQL Server 2005 instance in Windows Vista, you get the following error: “Login failed for user “admin” (where admin is your administrator username).

The solution is to run SQL Server Management Studio (SSMS) as Administrator.