We have an old ms sql 2005 server and for some reason, most of the features in sa account settings are grayed out..
Even I cant change sa password It will though this error "Could not find stored procedure 'master.dbo.sp_password'. (.Net SqlClient Data Provider"
Though I have enabled mixed mode I cant login using sa account.. (only windows authentication works)
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