Having troubles running SQL Server Manager on your shiny new Windows 2008 installation? Make sure you right click and do a “Run as administrator” on it. Took me awhile to figure this one out. Otherwise you’ll just get the error “Login failed for user domainuser. (Microsoft SQL Server, Error: 18456)” even if you’re a member of the local administrators on the SQL box.
Yet another instance of where UAC sucks.