Sidebar

How can I change SQL Server authentication mode?

0 votes
840 views
asked Feb 8, 2018 by rich-c-2789 (17,490 points)
edited Feb 8, 2018 by rich-c-2789

I can not log in with the new 'qie' user like explained in this question: How to resolve: Login failed for user 'qie'. (Microsoft SQL Server, Error: 18456) I get this error:

 

I checked the logs as explained in the referenced question and found this:

Reason: An attempt to login using SQL authentication failed. The server is configured for Windows authentication only.

and

State: 58

How can I change SQL Server authentication mode?

1 Answer

0 votes

To change the authentication mode follow these steps:

1. Connect to SQL via SQL Server Management Studio.

2. Right click on the server name on object explorer

3. Select Properties 

4. Select Security 

5. Change Server authentication to "SQL server and Windows authentication mode"

6. Click OK

7. Restart the SQL Server instance

To restart the server instance:

Click yes on the user access control dialog (if one pops up, not pictured) and the Microsoft SQL Server Management Studio confirmation dialogs.

See also:

How to resolve: Login failed for user 'qie'. (Microsoft SQL Server, Error: 18456)

How do you set up a database connection using windows authentication?

answered Feb 8, 2018 by rich-c-2789 (17,490 points)
edited Feb 8, 2018 by rich-c-2789
...