mike99c
asked on
Log in to management studio
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)
Any suggestions?
Do I need to add the new user to certain groups to allow login?
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)
Any suggestions?
Do I need to add the new user to certain groups to allow login?
Also check and add your domain credentials as a SQL Server login.
and in case of Vista Windows 7: you should select Run as Administrator when running Management Studio.
and in case of Vista Windows 7: you should select Run as Administrator when running Management Studio.
In case of more admin users needing to connect you can:
1) create a group with the logins
2) then create login for the group in SQL Server
1) create a group with the logins
2) then create login for the group in SQL Server
check if the group administrators is added to the sql server logins.
if not then add it and that should fix the problem.
if not then add it and that should fix the problem.
ASKER
Thanks for the repsonses, looking at it now
ashilo, how do I add the administrator group to the 'sql server logins'?
ashilo, how do I add the administrator group to the 'sql server logins'?
ASKER
georgekl, how do I create login for the group (new group) in SQL Server
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Later you can change to Mixed Mode Authentication. There you must first enable the account created above. Any Windows or SQL account can be configured as system administrator.