Solved

Log in to management studio

Posted on 2011-02-19
7
187 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:mike99c
  • 3
  • 2
  • 2
7 Comments
 
LVL 13

Expert Comment

by:George K.
Comment Utility
Choosing Windows Authentication from setup, will create an sa account  that can be uesed from SQL Server. Initially  it is not enabled.
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.
0
 
LVL 13

Expert Comment

by:George K.
Comment Utility
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.
0
 
LVL 13

Expert Comment

by:George K.
Comment Utility
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
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 15

Expert Comment

by:Aaron Shilo
Comment Utility
check if the group administrators is added to the sql server logins.

if not then add it and that should fix the problem.
0
 

Author Comment

by:mike99c
Comment Utility
Thanks for the repsonses, looking at it now

ashilo, how do I add the administrator group to the 'sql server logins'?
0
 

Author Comment

by:mike99c
Comment Utility
georgekl, how do I create login for the group (new group) in SQL Server
0
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 500 total points
Comment Utility
read this (relevant to sql server 2005/2008)

http://msdn.microsoft.com/en-us/library/ms173768(v=SQL.100).aspx
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Suggested Solutions

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now