Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
PRB: Unable to Connect to SQL Server Through ODBC When Password Contains a Semi-colon
Article ID: 301076 - View products that this article applies to.
This article was previously published under Q301076
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:
This error message occurs when you use either the Query Analyzer or the SQL Enterprise Manager.
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>'.
ODBC interprets the semi-colon as the end of the password, not part of the password itself.