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
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?
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