Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • 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
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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