Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

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?
0
mike99c
Asked:
mike99c
  • 3
  • 2
  • 2
1 Solution
 
George K.Commented:
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
 
George K.Commented:
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
 
George K.Commented:
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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
Aaron ShiloChief Database ArchitectCommented:
check if the group administrators is added to the sql server logins.

if not then add it and that should fix the problem.
0
 
mike99cAuthor Commented:
Thanks for the repsonses, looking at it now

ashilo, how do I add the administrator group to the 'sql server logins'?
0
 
mike99cAuthor Commented:
georgekl, how do I create login for the group (new group) in SQL Server
0
 
Aaron ShiloChief Database ArchitectCommented:
read this (relevant to sql server 2005/2008)

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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now