Admin-Ahead Community

Windows => Control Panels => Plesk => Topic started by: Chetan Singh on October 27, 2013, 03:35:36 am

Title: Enable SQL "SA" user.
Post by: Chetan Singh on October 27, 2013, 03:35:36 am
Hi,

You can access the MS SQL Server either in Windows authentication or in SQL Authentication. You can enable SQL "sa" with the help of this article. Please follow these steps to enable the "sa" user.

1. Go to start >> MS SQL Server management studio >> Right click & run as Administrator.

2.Log onto MS SQL Server management studio using Windows Authentication.

3.Right click on the SQL server name (eg:VPS123123) >> Properties.

4.Select the Security tab from left >> Server Authentication >> Select "SQL Server and Windows Authentication Mode" , Click OK.

4. Expand Security pane >> Logins >> Right click on sa user >> Properties.

5. Select the status >> Settings >> Login >> Select "Enable" >> Click Ok.

6.Restart the SQL server services and try to login as the user "sa" .

Thank you,