April 27, 2011 at 3:38 am
I have SS2008R2 in mixed mode auth.I have forgot my sa password.
Only sa has sysadmin.
Before 11 months I have add one windows domain user 'sqladmin' as login and I have given all the server roles except Sysadmin to it.
Bcoz I have read that Security admin has the right to reset the password.Therefore I have never tested it.
I know this is impossible..I have to reinstall it.
Yet any help...
Thanks
April 27, 2011 at 3:56 am
forsqlserver (4/27/2011)
I have SS2008R2 in mixed mode auth.I have forgot my sa password.Only sa has sysadmin.
Before 11 months I have add one windows domain user 'sqladmin' as login and I have given all the server roles except Sysadmin to it.
Bcoz I have read that Security admin has the right to reset the password.Therefore I have never tested it.
I know this is impossible..I have to reinstall it.
Yet any help...
No problem:
Login using your domain sqladmin account:
Then create a new sql login and Grant CONTROL SERVER to it.
The connect as the newly created sql login and reset the sa password.
and grant sysadmin to your windows sqladmin if you are allowed to do so.
after this sequence, drop the created sql login !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 27, 2011 at 3:58 am
Hi,
You don't need to reinstall anything!
If you set the database in Single User Mode, you can change the password.
To set the database in Single User Mode, when not knowing the password, you need to stop the Windows Service, and restart it in Single User Mode. On this page you see instructions on how to do this:
http://msdn.microsoft.com/en-us/library/ms188236.aspx
I think this guide will take you all the way:
http://deepakrangarajan.blogspot.com/2008/01/forgot-sa-password-in-sql-server-2005.html
Good luck!
/Markus
April 27, 2011 at 4:08 am
Dear All,
Thanks.
I have created one sql login name 'saa'.
But Now My all logins[windows/sql] are giving below error and sql server is running slow.
Dear Hunter Please clarifty after open it to single user mode what next is to be done.
TITLE: Connect to Server
------------------------------
Cannot connect to:
------------------------------
ADDITIONAL INFORMATION:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Thanks
April 27, 2011 at 4:13 am
Oh sorry I have not run the commit..
It really works..
May I know the least permission to a login to grant the control server rights to other login.
Thanks
April 27, 2011 at 6:13 am
As you have experienced, control server results in the same permission set as sysadmin.
A very good SSC ref pointing to this issue: http://www.sqlservercentral.com/blogs/brian_kelley/archive/2010/09/02/for-sql-server-2005-2008-consider-securityadmin-sysadmin.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply