I have 4 citrix servers (ESX 3.0.1 35804) that were cloned from a single source. These servers performed flawlessly for months until I upgraded our accounting application Microsoft's Great Plains. The Great Plains SQL 2000 server now rejects the Citrix server GP client login request (This login failed. Attempt to log in again or contact your system administrator). The only password that works on the citrix server is the unencrypted sa password. All users passwords work on the SQL server and their local workstation installation. I tried reinstalling the application and recreating the ODBC connection with a new name.
SQL Log error
/*
/* Date: 06/18/2007 Time: 13:59:02
SQLSTATE:(28000) Native Err:(18456) stmt(0):*/
\[Microsoft]\[ODBC SQL Server Driver]\[SQL Server]Login failed for user 'Joseph'.*/
/*
/* Date: 06/18/2007 Time: 13:59:02
SQLSTATE:(00000) Native Err:(18456) stmt(0):*/
*/
/*
/* Date: 06/18/2007 Time: 13:59:02
SQLSTATE:(00000) Native Err:(18456) status(24):*/
SWSTATUS DUMP*/
I read a MS thread that the version of GP we upgraded to uses stronger encryption (9.0 from 7.5). Is it possible that the process of cloning created a problem with encrypting and decrypting SQL passwords?
I hope this all makes sense. Any help or insight would be greatly appreciated.
