Property is locked and not avaliable for login Sa

Hello,

If you are getting the error “Property is locked and not avaliable for login Sa” when you go to the properties of sa user in MS SQL management Studio . You can fix the problem by logging in MS SQL management studio , Right click on Server name , New Query and execute the command .

ALTER LOGIN [sa] WITH PASSWORD=N’newpassword’, DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
ALTER LOGIN [sa] ENABLE

Comments are closed.

(adsbygoogle = window.adsbygoogle || []).push({}); //--> Feedjit Flag Counter