User login problem with SQL Server

Asked By 0 points N/A Posted on -
qa-featured

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

SHARE
Best Answer by Maybt Barton
Answered By 0 points N/A #143551

User login problem with SQL Server

qa-featured

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 http://support.microsoft.com/kb/889615. Another article you might find helpful would be at http://decipherinfosys.wordpress.com/2008/11/14/the-user-is-not-associated-with-a-trusted-sql-server-connection/

Best Answer
Best Answer
Answered By 0 points N/A #143552

User login problem with SQL Server

qa-featured

 

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!

Login/Register to Answer

Related Questions