Login failed for user Reason: Not Associated with a Trusted SQL Server Connection

Description


Particularly after new database connections are configured, users may encounter this error in PaperVision Enterprise. The error indicates that the instance of SQL Server involved is configured to use Windows Authentication rather than Mixed Mode Authentication, and the current user is failing to authenticate.

Example of error:

Login failed for user '<LoginName>'. Reason: Not associated with a trusted SQL Server connection.

Summary


This error can be resolved by configuring SQL Server to use SQL Server and Windows Authentication Mode (Mixed Mode Authentication). For the purposes of this article, SQL Server 2005 Express Edition is assumed.

To resolve this follow the steps below:

  1. Login to the SQL Server Management Studio.
  2. Right-click the Server node.
  3. Select Properties | Security tab.
  4. Choose SQL Server and Windows Authentication Mode, and then click OK.

References:

http://support.microsoft.com/kb/889615

Filed under PaperVision® Enterprise, R70.1

Last modified May 27, 2010

Submitted May 27, 2010

Related Articles

Share via Email Print