Unable to authenticate user...

Problem

You receive one of the following messages when attempting to log into your application:

Unable to authenticate user.  Login failed for user '(null)'.  Reason:  Not associated with a trusted SQL Server connection.

Please grant SQL Server login privileges and add the System Administrators role to the user on the '<servername>' instance of SQL Server.

Unable to create record. Unable to connect to database. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server conection.

Description

The problem is caused by the absence of configuration information that prevents your application from connecting to the Microsoft SQL Server database.

Solution

See Configuring Database Authentication for Microsoft SQL Server Applications for more details.

See Also

Part IX:  Troubleshooting Applications