N/APosted 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.
Login failed for user 'sap'. The user is not associated with a trusted SQL Server connection. (Microsoft
SQL Server, Error: 18452)
I am at a loss now with this peculiar problem. I hope someone here will be able to give me a solution.
User login problem with SQL Server
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!