Error Messages (L)

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

Login incorrect / Not associated with a trusted SQL Server connection

This error is typically received in the context of a Microsoft SQL Server Lite driver connection attempt.

"Login incorrect" indicates a general authentication failure. Verify that the username and password you used to connect are appropriate to the database name you provided in your DSN configuration.

The latter error indicates that Windows NT domain authentication was attempted and is not valid for the given database.

Currently, to enable domain authentication, you must take the following steps:

UNIX/LINUX users

1. Edit the "freetds.conf" file located in the "bin" driver subdirectory. Ensure the following line appears there:

try domain login = yes

Save the file.

2. When connecting, use the following user name convention:

[domain]\[login]

Here, [domain] is the name of your Windows domain, and [login] is your login name. Please note that this change will prevent normal SQL Server "server" logins from working.

Note: As of June 13, 2003, an imminent patch to the Release 5.0 driver for Unix/Linux will provide the user with the ability to use the [domain]\[login] username convention without having to edit the freetds.conf to use domain authentication globally.

Mac/Windows users

Currently domain authentication is not supported on these platforms. You will have to use SQL Server server-based authentication.

Evidence

ODBC Trace
ODBC Client Trace