Discussion Locked

Can't connect to SQL Server via ODBC

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have created a user on a Win2K SBS system using active directory. I have added this user to SQL Server as well and given him access permission to a database. However, when this user is logged in to a Windows 2000 pro workstation and tries to use an application that uses a drop down list based on an ODBC connection to this database he is presented with an SQL Server log in dialog. (ODBC DSN uses Windows authentication.) His ID and password are rejected and he must log in with some other ID. (Pretty annoying when using a drop down!) Other ID's that are set up like his do not experience this problem. Can anyone say what the correct SQL Server permission setup must be? I swear this should not be happening. The error is "SQL Server Error: 18456 Login failed for ". Any clues appreciated. More detail upon request.

2 replies

by jackie.pettigrew

Have you checked the sql client configuration net library is set correctly. most people use tcp/ip

find this from start,programs,sql server,configuration,net library

This discussion is closed to new replies.