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
No comments:
Post a Comment