Home / server / Questions / 679530
Accepted
Aravinda
Asked: 2015-04-01 02:27:10 +0800 CST

I cant change sa password in mssql 2005 "Could not find stored procedure 'master.dbo.sp_password'. (.Net SqlClient Data Provider"

  • 772

We have an old ms sql 2005 server and for some reason, most of the features in sa account settings are grayed out.. enter image description here

Even I cant change sa password It will though this error "Could not find stored procedure 'master.dbo.sp_password'. (.Net SqlClient Data Provider"

enter image description here

Though I have enabled mixed mode I cant login using sa account.. (only windows authentication works)

enter image description here

Any help where to start troubleshooting steps? googled around a day and yet could not find a clue fixing the issue.. Thanks in advanced for any tip!

PS:only the default instance is having this issue.. other one is fine, login working for sa and not grayed out

sql-server-2005

1 Answers

  1. Best Answer

    It looks like something is wrong with your master database.
    Several of your system stored procedures appear to be missing (judging by the look of the ssms prompt)

    You may want to Restore your master database from backup.

    1. Start the server instance in single-user mode.
    2. RESTORE DATABASE master FROM WITH REPLACE

    Just make sure you backup everything before you do this.
    Clearly something is broken on your environment, so make sure that no matter what happens, your data is safe.

    • 1