Home > SQL Server > SQL Server Authentication enabling using Microsoft SQL Server Management Studio

SQL Server Authentication enabling using Microsoft SQL Server Management Studio


Hi all,

try this scenario to Enable SQL Server Authentication using MS SQL Server Management Studio

1. First, Login to the SQL Server Management Studio using Windows Authentication. Right-click on the database instance, and go to Properties.

SQL2

2. Then on Properties page, click on Security and select SQL Server and Windows Authentication mode, and click on OK to close the Server Properties page.

SQL3

3. Now you will get dialog box saying that you should restart your SQL Server to take the changes take effect. Is is not done yet, you have to done one more thing to enable the “sa” login.

4. Now expand Security folder and go to Logins. You can see the “sa” account is disabled when you install SQL Server using Windows Authentication mode.

SQL4

5. Then right-click on the “sa” account and go to Login Properties. There you can set a password for the “sa” account.

SQL5

SQL5.1

6. Click on the Status page. There you can see the “sa” account is disabled by default. Click on the Enabled button to enable it. Then click on Ok to close the “sa” Login Properties.

SQL6

Now “sa” account is enabled and you can login to the SQL instance using the “sa” account after restarting the SQL Server.

Note: SQL Server service needs to be restarted to make this change effective.

Advertisements
Categories: SQL Server
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: