General discussion

Locked

Can't connect to SQL Server via ODBC

By steves815 ·
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 <username>". Any clues appreciated. More detail upon request.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by sgt_shultz In reply to Can't connect to SQL Serv ...

could this be it?
<snipped> from mskb article 301076
PRB: Unable to Connect to SQL Server Through ODBC When Password Contains a Semi-colon
View products that this article applies to.
This article was previously published under Q301076
SYMPTOMS
When you use SQL Server Authentication, a computer running SQL Server allows login passwords to be defined with semi-colons. When you attempt to connect to a SQL Server server through ODBC or OLEDB by using a SQL Server login whose password contains a semi-colon, an error message similar to the following occurs:

Unable to connect to server <servername>:

Server: Msg 18456, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '<username>'.
This error message occurs when you use either the Query Analyzer or the SQL Enterprise Manager.
CAUSE
ODBC interprets the semi-colon as the end of the password, not part of the password itself.
RESOLUTION
Change the password and remove the semi-colon.
STATUS
This behavior is by design.

Collapse -

by sgt_shultz In reply to

there is also issue with user rights when database has been moved. is this your case?

Back to Windows Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums