Wednesday, September 2, 2015

how to enable sa user name in sql server

Most of the users facing issue with "sa" login. this issue caused because of not selecting mixed  mode authentication while installing the sql server (or) some limitations created dba's as per security policy in  company's and mixed mode is less secure.
below are the symptoms you face while login

Login failed for sa
cannot connect to sa login etc,.,

here am going to show changing authentication mode Sql server.
Follow below steps to enable to sa user in sql server
Login Filed issue:-
if you have access to any other user login(database instance) with that. right click on server instance and go to properties


select security and highlight the bubble Sql Server and windows authentication. this option can enable the sql server sa login

click ok and restart the sql server services. go to start menu type  services.msc and restart the  services


Your sa login account enabled automatically after above steps.
if you want enable manually  type below query  in ssms query editor window

ALTER LOGIN [sa] WITH PASSWORD='AnyStronG@#Passw)e', CHECK_POLICY=OFF
GO
ALTER LOGIN [sa] ENABLE
GO

now you can login with sa user name and  defined password