[THIN] Re: Strange occurrence

It is using an SQL account.  The mf20.dsn is below with WSID & SERVER changed.

[ODBC]
DRIVER=SQL Server
UID=Citrix
LANGUAGE=us_english
DATABASE=CITRIX_Datastore
WSID=Citrix-Server
APP=Microsoft Data Access Components
SERVER=SQL-Server
Description=Citrix Datastore

Thanks

On Mon, Jan 26, 2009 at 9:59 AM, Joe Shonk <joe.shonk@gmail.com> wrote:

What does your mf20.dns look like?  Are you using an AD account or SQL account?  Is the dbuser account being reset somehow?

 

Joe

 

From: thin-bounce@freelists.org [mailto:thin-bounce@freelists.org] On Behalf Of Tom Sorenson
Sent: Monday, January 26, 2009 8:37 AM
To: thin@freelists.org
Subject: [THIN] Strange occurrence

 

For some as yet explained reason, servers in my Citrix farm appear to lose DSN information connecting to the datastore.  When this happens, I see the below error.

The Citrix Presentation Server failed to connect to the Data Store. ODBC error while connecting to the database: 28000 -> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'dbuser'.

The database is not 28000, it is actually called Citrix.  I found an instance online of another person experiencing the same issue, but no resolution.  To resolve I need to run dsmaint config and point it back to the correct dsn and restart the IMA service.

Any ideas ?

Regards