Cannot login after creating the user in SQL Server

Sql Server

Sql Server Problem Overview

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)

Sql Server Solutions

Solution 1 - Sql Server

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

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

Solution 2 - Sql Server

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

  1. Open properties
  2. Go to "Security"
  3. Select "SQL Server and Windows Authentication mode"

Solution 3 - Sql Server

Right click Server for properties...

enter image description hereproperties

Categories
Recommended Sql Server Solutions

Previous Solution:

Calculate the mean by group

RDataframeR Faq

Next Solution:

what is java:comp/env?

JavaJakarta EeJndi

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionksgView Question on Stackoverflow
Solution 1 - Sql ServerNG.View Answer on Stackoverflow
Solution 2 - Sql ServerstbView Answer on Stackoverflow
Solution 3 - Sql ServerHalis YılboğaView Answer on Stackoverflow