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](http://stackoverflow.com/questions/1719399/sql-server-2008-cant-login-with-newly-created-user) — bob esponja, Feb 17 '17 at 08:37

score 152 · Answer 1 · edited Aug 11 '17 at 12:59

152

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 '17 at 12:59

Vijay Nirmal

4,076
4
21
52

answered Jul 24 '12 at 09:18

NG.

5,439
2
17
30

26

+1 for restarting the services. the only bit was missing before it worked... you saved from suicide... ! – iAteABug_And_iLiked_it Nov 09 '13 at 10:08
What's "Object Explorer"? – Maxim Feb 01 '18 at 22:48
@Maxim in the Management Studio - it's the left column (pane) – blackandorangecat Mar 16 '18 at 22:20
2

That's the right answer, you need to restart the service (not the job) – Houssem Badri Nov 12 '18 at 08:15
1

Yep, just closing and re-opening SSMS does NOT fix the issue. This should be accepted answer IMO as well – ganders Jun 26 '19 at 17:57
1

Thanks. Looks like I'm not the only one who almost gave up and took a bullet before going stackoverflow. – Ya. May 07 '20 at 23:40

stb · Accepted Answer · 2018-12-29T17:57:37.600

142

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 '18 at 17:57

answered Jul 24 '12 at 07:36

stb

3,145
2
15
24

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... – ksg Jul 24 '12 at 07:42
You pointed to actual error that is Mixed mode needs to be on and that saved my hours... Thank you... – Jenish Rabadiya Mar 02 '18 at 09:48
Here is a step by step guide: https://help.blacknight.com/hc/en-us/articles/212511129-Set-MS-SQL-to-mixed-mode-Authentication-on-Windows-Cloud-VM – Pouya BCD Nov 13 '18 at 14:37
5

This requires the service to be restarted after committing the changes. – Chris Cruz Jun 20 '19 at 17:44
Yep, go into the services app and restart the sql server service – Nick Turner Sep 07 '21 at 14:52

score 29 · Answer 3 · answered Sep 11 '14 at 10:54

29

Right click Server for properties...

enter image description here properties

answered Sep 11 '14 at 10:54

Halis Yılboğa

772
9
12

Cannot login after creating the user in SQL Server

3 Answers3

Linked