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

Product: PaperVision® Enterprise

Last modified: September 21, 2022

Submitted: May 27, 2010

Version: R70.1

Article ID: PE000110

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

Find what you need

Filed under:

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 ''. 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