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.
| Author |
Topic |
|
barnabeck
Posting Yak Master
236 Posts |
 Posted - 2013-12-17 : 04:32:49
|
| I am trying to set up a ODBC connection for a SQL user that can actually access directly through Management Studio. When using the same credentials building the ODBC connection it throws error 18356.SQLState: 28000, Login failed for user...desperately, Martin |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-17 : 07:34:57
|
| did you test connection for DSN? was it succesful?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
barnabeck
Posting Yak Master
236 Posts |
Posted - 2013-12-18 : 04:13:29
|
| The problem was really stupid and feel embarrassed... I misread and consequently mistyped the password that had been given to me. The font I received the password in doesn't make any difference between capital 'I' and a minuscule L (l) and I interpreted without doubting as capital 'I'. Then I look it up somewhere else where the font doesn't differ between 1 (one) and minuscule L (l) and I thought it was one (again without doubts)... copy paste -off course- worked all the time. I turned mad until I took a small break and started to think... :) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-18 : 06:31:49
|
| coolglad that you got it sorted.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Error 18456 on ODBC creation