Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Log in to management studio

Posted on 2011-02-19
Medium Priority
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?
Question by:mike99c
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
LVL 13

Expert Comment

by:George K.
ID: 34933814
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.
LVL 13

Expert Comment

by:George K.
ID: 34933838
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.
LVL 13

Expert Comment

by:George K.
ID: 34933858
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

LVL 15

Expert Comment

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

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

Author Comment

ID: 34937696
Thanks for the repsonses, looking at it now

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

Author Comment

ID: 34937707
georgekl, how do I create login for the group (new group) in SQL Server
LVL 15

Accepted Solution

Aaron Shilo earned 2000 total points
ID: 34937719
read this (relevant to sql server 2005/2008)


Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

597 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