June 30, 2010 at 4:37 am
Hi Experts,
How can i login to a server having only windows authentication and its domain have changed??
I tried new domain administrator but no use..
Please help
June 30, 2010 at 5:56 am
Read the following article, it explains how/why.
http://msdn.microsoft.com/en-us/library/ms188236.aspx
Ensure your account is a local admin.
Start SQL Server in single user mode ( -m option in startup parameters)
Login and make changes. (switch to mixed mode, add new domain accounts to necessary roles, etc.)
June 30, 2010 at 7:00 am
Thanks for the reply calvo ,
But am not able to access the sqlcmd ..I am able to start sql server in single user mode ...its showing failed for user domain\administrator..
June 30, 2010 at 8:12 am
http://msdn.microsoft.com/en-us/library/ms345416.aspx
This shows how to start SQL Server in single user mode through adding startup options in the service. This is done through the Configuration Manager tool.
Make sure you are logged on the server itself when you do this. Also, make sure you are part of the local administrator group on the server.
June 30, 2010 at 10:34 pm
Thanks alot calvo..
I tried that but when i connect to sqlcmd its showing server in single user mode cannot connect..
What to do?? Can u please answer?
I tried net start mssqlserver /c /m /t3608 and it worked..
Can u pleae let me know why the first option didnt work??
I stopped any services related to sqlserver
July 4, 2010 at 11:02 am
Ratheesh
have you removed the Builtin\Admins from the SQL Server instance?
If not login to the server as the local admin account and gain accessto the SQL Server instance.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply