0

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

Aravinda
  • 1,081
  • 5
  • 12
  • 30

1 Answers1

1

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.

Reaces
  • 5,547
  • 4
  • 36
  • 46
  • So i have to search for full backup of server ? i have two instance, only the default instance is having this issue.. other one is fine, login working for sa and not grayed out.. – Aravinda Mar 31 '15 at 12:47
  • 1
    @Aravinda You could always migrate your databases to the working instance. – Reaces Mar 31 '15 at 12:58
  • that option sounds great.. I will try working on that.. – Aravinda Mar 31 '15 at 13:00