Log in to management studio
Posted on 2011-02-19
If I log into windows as 'administrator' and then start sql server management studio using windows authentication (the username is administrator with the password blanked) then I can connect ok, update databases etc.
I've created a new login user and added it to the administrator group, but when I start sql server management studio using windows authentication (username is the new login user with the password blanked) I get a login error
"Login failed for user instance\xyzuser (Error : 18456)
Do I need to add the new user to certain groups to allow login?