Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!

Author Topic: Enable SQL "SA" user.  (Read 2456 times)

0 Members and 1 Guest are viewing this topic.

Chetan Singh

  • Full Member
  • ***
  • Posts: 123
  • Karma: +2/-0
  • Bienvenido a las Tecnolog√≠as de la Admin-Ahead.
    • Admin-Ahead Server Technologies.
Enable SQL "SA" user.
« 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,
Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!