User login problem with SQL Server

Asked By janajacobb 0 points N/A Posted on - 09/03/2012

A user with the name "wap" has been created for logging in to SQL server.

I have assigned the required properties and made the required changes in SQL server’s administration/authorization.

Nevertheless, as I try to connect to the SQL server through the details of this user, an error similar to the one that is shown below appears.

 

Connect to Server

Cannot connect to ADMIN-PCSQLEXPRESS.

Additional information:

Login failed for user 'sap'. The user is not associated with a trusted SQL Server connection. (Microsoft

SQL Server, Error: 18452)

                                                                                                                                                  OK

I am at a loss now with this peculiar problem. I hope someone here will be able to give me a solution.

Please. ASAP

• Status: Open
• Question Views: 777
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Maybt Barton

Go To Solution

Answered By Cagle PC 0 points N/A #143551

User login problem with SQL Server

Hi, the MS SQL server you are encountering is usually related to the authentication settings of your server, this is related to the setting being Windows only authentication. There is an existing Microsoft Kb for this specific issue at https://support.microsoft.com/en-us/help/889615/you-may-receive-a-not-associated-with-a-trusted-sql-server-connection. Another article you might find helpful would be at https://decipherinfosys.wordpress.com/2008/11/14/the-user-is-not-associated-with-a-trusted-sql-server-connection/

About Cagle PC

Questions
0

Answers
8

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 09/03/2012
• Question Category: MS SQL Server

Best Answer

Best Answer

Answered By Maybt Barton 0 points N/A #143552

User login problem with SQL Server

 

Good day!

 

This error occurs when a user attempts to log in with credentials that cannot be verified, to solve this

try these steps : 

 

A. Launch SQL Server Management Studio, to acquire this, locate and click Start, locate All Programs then Click Microsoft SQL SERVER 2008 and then proceed to choose SQL Server Management Studio.

B. Do a right-click on server, then locate and click Properties.

C. Locate and choose Security, below Server authentication, choose SQL Server and Windows Authentication mode button then click OK

D. In the SQL Server Management Studio dialog box, choose OK so that the SQL Server will restart.

 

Hope I have helped you!

 

Take care!

About Maybt Barton

Questions
2

Answers
37

Best Answers
28

• Vote Up 0 Vote Down

• Posted on - 11/30/2012
• Question Category: MS SQL Server