Connection to SQL Server 2008: error 18452

Question

I have a problem with connection to SQL Server 2008.

My problem is all simple user can't connect to SQL Server 2008 but just the admin in subdomain only who can connected.

I test the connection with these steps:

1. control panel / set up odbc

2. system DNS / I choose SQL Server

3. click on the bottom Add

4. in the Name=test, and the server = I choose SQLSERVER

When I clicked Next bottom I have error 18452.

Connection failed: SQLState: '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server] connection failed.

Answer 1

SQL Server Error: 18452

Login failed for user ". The user is not associated with a trusted SQL Server connection.

You should create new DSN with changed Authentication Mode from Windows Authentication Mode to SQL Server Authentication. Then specify login and pass for connection. This login should be added on SQL too.

Answer 2

I were trying to do the same, saw a lot of videos trying to accomplish the add of the DSN but this was my solution.

I'm running Windows Server 2016:

I ran the ODBC 64bit -> System DSN tab -> Add button

Then I selected SQL Server, since i had SQL Server Management Studio 17.

I putted a Name and the fact that is really important: Write the SQL Server you know you have connection to on the Server field.

Be sure you had configured the Security on Server authentication for SQL Server and Windows Authentication mode and then write the user you know that have access to that Data Base.

Last step: you click next after putting the info of the user that have acces to the SQL Server and the connection will pass.

Hope this help someone.