During Installation ,Sql Server Database Engine is set to Either Windows
Autthentication Mode or Sql Server and Windows authentication Mode.
This topic Described how to change the Security mode after Installation.
If Windows Aunhtentication Mode is selected during installation, the sa login is
desabled.
If u later change authentication Mode to SQL Server and Windows Authentication
Mode , the sa login remains Disabled
To enabled the sa login,use the ALTER LOGIN statement.
The sa login only can connect to server by using SqlServer Authentication.
To Change Secutity Authentication Mode:
In Sql Server Management Studio Oject Explorer,right click the server,and then
click properties.
On the Security page ,under Server Authentication, Select the new Server
Authentication Mode,
And then Click Ok.
In the Sql Server management Studio DialogBox,click ok to acknowledge the
requirment to restatr sql server.
To Restart SQl Server from SQL Server Management Studio:
In Object Explorer,Right click your server, and then click Restart.
If the SQl Server Agent is running,it must also be restarted.
To Enabled the sa login by using transcat-SQl:
Execute the following statement to enabled sa password and assign a Password.
ALTER LOGIN sa ENABLE;
ALTER LOGIN sa WITH PASSWORD='<Enter StrongPassword Here >';
To enabled sa login by using Management Studio:
In object Explorer,Expand Security, Expand Logins,
Right Click sa, and then Click Properties.
On the General page,you might have to create and confirm a Password for the sa
login.
On the Status page,in the Login Section,Clicked Enabled,and then Click Ok.