Why am I getting the error "Login failed for user 'user name'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)"

Technote (troubleshooting)


Problem(Abstract)

During a logon process to SQL server the following error may appear: Login failed for user 'user name'.

Resolving the problem

During a logon process to SQL server the following error may appear: "Login failed for user 'username'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)".

This is an indication that the SQL server has been configured to operate in "Windows Authentication Mode (Windows Authentication)" and does not allow the use of SQL accounts.

To resolve this, change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)" to "Mixed Mode (Windows Authentication and SQL Server Authentication)".

See also: Database ODBC Configuration.

Historical Number

1317

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Endpoint Manager

Software version:

Version Independent

Operating system(s):

Platform Independent

Reference #:

1506269

Modified date:

2012-02-13

Translate my page

Machine Translation

Content navigation