Cannot login after creating the user in SQL Server

Question

My problem is I cannot login into SQL Server after I've created a user. The user creation is successful, since the new user is listed under security/logins.

How to solve this issue ???

Login failed for user 'sims'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

Possible duplicate of SQL Server 2008 can't login with newly created user — bob esponja
– bob esponja, Commented Feb 17, 2017 at 8:37

Vijay Nirmal · Accepted Answer · 2017-08-11 12:59:16Z

206

SQL Server was not configured to allow mixed authentication. Here are steps to fix:

Right-click on SQL Server instance at root of Object Explorer,
click on Properties.
Select Security from the left pane.
Select the SQL Server and Windows Authentication mode radio button, and
click OK.
Open up Services and restart the SQL Service (SQLEXPRESS) Windows service.

edited Aug 11, 2017 at 12:59

Vijay Nirmal

5,9175 gold badges29 silver badges65 bronze badges

answered Jul 24, 2012 at 9:18

NG.

6,1233 gold badges21 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

iAteABug_And_iLiked_it Over a year ago

+1 for restarting the services. the only bit was missing before it worked... you saved from suicide... !

blackandorangecat Over a year ago

@Maxim in the Management Studio - it's the left column (pane)

Houssam Badri Over a year ago

That's the right answer, you need to restart the service (not the job)

ganders Over a year ago

Yep, just closing and re-opening SSMS does NOT fix the issue. This should be accepted answer IMO as well

Ya. Over a year ago

Thanks. Looks like I'm not the only one who almost gave up and took a bullet before going stackoverflow.

|

stb · Accepted Answer · 2018-12-29 17:57:37Z

174

Try setting your authentication mode to mixed mode. Your server does probably not accept logins using sql server accounts.

Open properties
Go to "Security"
Select "SQL Server and Windows Authentication mode"

edited Dec 29, 2018 at 17:57

answered Jul 24, 2012 at 7:36

stb

3,5332 gold badges19 silver badges24 bronze badges

5 Comments

ksg Over a year ago

Thankyou very much for your wonderful answer.It works correctly.I've no more doubt how to give permission to a user to access only particular database...

Jenish Rabadiya Over a year ago

You pointed to actual error that is Mixed mode needs to be on and that saved my hours... Thank you...

Pouya BCD Over a year ago

Here is a step by step guide: help.blacknight.com/hc/en-us/articles/…

Chris Cruz Over a year ago

This requires the service to be restarted after committing the changes.

Nick Turner Over a year ago

Yep, go into the services app and restart the sql server service

Halis Yılboğa · Accepted Answer · 2023-08-09 12:15:20Z

basically : Right click Server for properties...

enter image description here properties

for detailed explanation: If you're encountering the "Login failed for user" error when trying to log in to SQL Server after creating a new user, you can follow these steps to resolve the issue:

Change Authentication Mode:

Right-click on the SQL Server instance and select "Properties." In the Properties window, navigate to the "Security" section. Choose the "SQL Server and Windows Authentication mode" option. Click "OK" to save the changes.

Restart SQL Service:

Open the SQL Server Configuration Manager.
Locate the SQL Server service (e.g., SQLEXPRESS) and restart it.

Additional Troubleshooting Steps:

If the issue persists, make sure the user is associated with the correct database and has appropriate permissions.
Double-check the connection string in your application to ensure it specifies the correct authentication mode and user credentials.

Remember to back up your SQL Server settings before making any changes.

Collectives™ on Stack Overflow

Cannot login after creating the user in SQL Server

3 Answers 3

8 Comments

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

8 Comments

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related