SQLServer 2005 and ODBC - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQLServer 2005 and ODBC

Author

Topic

dbaman
Starting Member

46 Posts

Posted - 2007-01-04 : 11:02:19

Do I need any update pack for getting ODBC COnnection to work with SQLServer 2005.When I try to setup ODBC Connection with SQLServer 2005 I get following error message:

Miscrosoft SQL Server Login
Connection Failed
SQLState:'28000'
SQL Server Error : 18456
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user 'sa'

I know for sure nothing wrong with the password as I could connect to the server with Enterprise Manager using same UserID(sa)/password combination.

This is the ODBC Driver Version I have now: 2000.86.1830.00

Please suggest.

Thanks

R

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-01-04 : 11:21:11

Could be a few different things, take a look through the hits in this search
http://www.google.com/search?hl=en&lr=&q=SQL+Server+Error+18456+odbc+2005+site%3Amicrosoft.com

dbaman
Starting Member

46 Posts

Posted - 2007-01-04 : 11:23:31

I am also reading the same threads and so far nothing is working for me.

R

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources