Wednesday, March 28, 2012

ODBC Driver .... User cannot login ...

Although I am not working on the systems right now, while setting up replication, all of a sudden both systems began giving this error when I attempted to access the Web Portal login screen.
Any suggestions.yep...some sql servers when set up may have been set up using collations that are case sensitive, which means that usernames & passwords will be case sensitive also.

Also, make sure the ODBC is set up to use TCP sockets ( if 7,2000 ) or named pipes if 6.5 ...just seems to be better that way.

Also make sure that you have at least one database the login has access to & the login has access granted to it.

Post back if probs.

J.

No comments:

Post a Comment