February 01, 2011Got a login on your SQL server and the same user in a database but they are not connected? Even though the names are the sames the unique IDs are not. Here's a snippet from my college Fredrik that's very useful connecting the user name between server login and database user. Replace 'user' with 'your user name':
EXEC sp_change_users_login 'Auto_Fix', 'user'
And a small celebration! This is the 100th post :)