SQL sa passwd help
I just got a server to migrate and I need to have the sa password. The problem is that the current owners of the server have no clue what it is. I do however have administrative access to the box. Does anyone know of ways to either get the sa password, reset it, or assign permisssions to an existing user? In the end I need a user to have sysadmin priveliges.
As JMattias indicated, if you are a local admin and the BUILTIN\Administrators login within SQL Server still exists, you can change the password
You can use the sp_password rocedure to change the password
You can use the sp_password rocedure to change the password
ASKER
the administrator username has been disabled in sql. Any other ideas?
Have you tried logging into windows as domain administrator, then connecting to SQL under windows authentication yet?
ASKER
Yes and it won't let me in.
If the builtin\administrator group is gone and you have not user who can log in as a sysadmin then you will have to reinstall. There is no way to change the sa password unless someone can log in as a sysadmin in SQL Server.
ASKER
I find that a little hard to belive but fine. Thanks for all your help.
>>I find that a little hard to belive but fine.<<
Think of it this way: what a great lesson to learn.
>>Thanks for all your help.<<
Please close the question.
Think of it this way: what a great lesson to learn.
>>Thanks for all your help.<<
Please close the question.
Hey dont reinstall!!!!!!!
You need to find the windows user who installed the sql server instance. Then you need to use the user's login to log into the sql server using windows authentication and then reset the sa password.
Try this.
Regards,
Rehan
You need to find the windows user who installed the sql server instance. Then you need to use the user's login to log into the sql server using windows authentication and then reset the sa password.
Try this.
Regards,
Rehan
>> Yes and it won't let me in.
Can you connect as any other user? Just to verify it isn't a connection problem.
The installing windows user is not going to let you in either if it isn't granted as a sysadm login.
Can you connect as any other user? Just to verify it isn't a connection problem.
The installing windows user is not going to let you in either if it isn't granted as a sysadm login.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>you will have to re-intall SQL Server and then attach your databases.<<
And then recreate all the logins.
And then recreate all the logins.
ASKER
Thanks for all the ideas. I just at the moment don't have time for this. The problem is that some of your clients use Lytec(EMR) and it changes the sa passwd. And unfortuanelty to do anything usefull in sql you have to be in the sysadmin role group.
>>The problem is that some of your clients use Lytec(EMR) and it changes the sa passwd. And unfortuanelty to do anything usefull in sql you have to be in the sysadmin role group. <<
Than you have bigger problems ...
Than you have bigger problems ...
If you are the local administrator I gues that you are SA by default, then you can either change the SA password or create a new user with sysadmin priveliges.
Regards
/Mattias