April 1, 2004 at 1:36 am
Hello
I have forget my sa passwd. please tell me how to change or get into Admin. I have no other options like no user with admin rights.
thanks
April 1, 2004 at 4:42 am
If the box was set up as default and you didn't change any security logins then anyone in the NT admin group on that server can get in the SQL instance and perform admin functionality. Windows Auth is always on so unless you dropped BUILTIN/ADMINS they still have access.
April 1, 2004 at 9:48 am
If you can't get this, you can uninstall, reinstall and attach your dbs. You'd lose your pwds and logins, but no data.
April 2, 2004 at 6:44 am
If you have administrative access to the Windows server SQL Server is installed on do this:
SQL Server sa account password lost
Login to the SQL Server computer as the Administrator of that computer. Open Query Analyzer and connect to SQL Server using Windows NT authentication. Run sp_password as show below to reset the sa password:
sp_password @new = 'will_never_forget_again', @loginame = 'sa'
SOURCE: http://vyaskn.tripod.com/administration_faq.htm
If you do not have have administrative access to the Windows server SQL Server is installed on do this then the step above:
See Daniel Petri's MCSEworld article:
"How can I gain access to a Windows 2000/XP/NT computer if I forgot the administrator's password? How can I reset the administrator's password if I forgot it?"
http://www.petri.co.il/forgot_administrator_password.htm
It refers to a powerful Windows NT/XP/2000 password editor written by Petter Nordahl-Hagen and includes links to the resources to build the necessary boot disk to use the offline password editor.
Best regards,
Michael Tilley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply