SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 can't login to SQL Server to add new logins
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Maracatu
Starting Member

13 Posts

Posted - 08/30/2009 :  09:23:01  Show Profile  Reply with Quote
Hi,
I installed SQL Server 2008 a few weeks ago logged into Windows 2008 server as an account called "guestadmin". For some ridiculous reason (something to do with our IT support department's politics) they have removed that user from the network and given me a new username/login for the network. I need to add this new user to SQL Server logins but I am now unable to login to SQL server at all through Management Studio with windows authentication (I get 'login failed for user xxx' 18456 error message). Does anyone know how I can get around this problem - ie how can I login in and connect to my SQL Server database?
thanks
mara

YellowBug
Aged Yak Warrior

United Kingdom
616 Posts

Posted - 08/30/2009 :  09:30:26  Show Profile  Reply with Quote
Can anyone else logon with sysadmin rights? And create your new account in SQL Server?
What account does the SQL Service run under? Can your IT support logon to SQL Server with this account, and add your new account?

If no-one can logon with the rights to create a new account, you may need to stop and restart the SQL service to create a new sysadmin.
Is this a production server? Are you able to freely restart the service?
Go to Top of Page

Maracatu
Starting Member

13 Posts

Posted - 08/30/2009 :  09:48:59  Show Profile  Reply with Quote
Thanks. IT support are not available as it's the weekend. It's not yet in production so it would be ok for me to stop and restart the SQL Service - but how would I create a new sysadmin?
Go to Top of Page

YellowBug
Aged Yak Warrior

United Kingdom
616 Posts

Posted - 08/30/2009 :  10:08:15  Show Profile  Reply with Quote
Try this: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=131215

Let us know if it works ok.
Go to Top of Page

Maracatu
Starting Member

13 Posts

Posted - 08/30/2009 :  17:53:59  Show Profile  Reply with Quote
i've tried restarting in single user mode, and restricting the login to sqlcmd but it still won't let me login - giving generic login failed for user message 18456
Go to Top of Page

Maracatu
Starting Member

13 Posts

Posted - 08/30/2009 :  19:15:08  Show Profile  Reply with Quote
ok - sorted it now. instead of logging in with sqlcmd in single user mode, I ran management studio as administrator (right clicking) and it worked - also with database in single user mode. I also had to stop IIS to prevent web application from stealing my single user mode connection
Go to Top of Page

YellowBug
Aged Yak Warrior

United Kingdom
616 Posts

Posted - 08/31/2009 :  06:11:21  Show Profile  Reply with Quote
Sorry - I should have mentioned that you'd need to stop any service/application that connects (e.g. web sites, SQL Agent)
Thanks for letting us know how you got on.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000