[THIN] Re: Strange occurrence
- From: "Joe Shonk" <joe.shonk@xxxxxxxxx>
- To: <thin@xxxxxxxxxxxxx>
- Date: Mon, 26 Jan 2009 09:45:04 -0700
If you look in the registry (somewhere under HLM\software\citrix\IMA\) it
shows which .dsn is being used. Is it possible that it's point to another
file.
Joe
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf
Of Tom Sorenson
Sent: Monday, January 26, 2009 9:34 AM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Strange occurrence
Sorry I should have replaced UID=Citrix with UID=dbuser. Just trying to
have some opsec. I am using the correct UID for dsmaint config. The part
that is perplexing me is the "error while connecting to the database: 28000"
portion of the message. Where is it coming up with this 28000 database?
On Mon, Jan 26, 2009 at 10:25 AM, Joe Shonk <joe.shonk@xxxxxxxxx> wrote:
A few things. One, you can get rid of the WSID if you like. It hasn't been
used since the early days of MFXP.
Second, the UID listed in the file is Citrix but the Error reported show the
user id as dbuser. The you specified in the dsmaint config should also be
the UID.
Joe
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf
Of Tom Sorenson
Sent: Monday, January 26, 2009 9:14 AM
To: thin@xxxxxxxxxxxxx
Subject: [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@xxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf
Of Tom Sorenson
Sent: Monday, January 26, 2009 8:37 AM
To: thin@xxxxxxxxxxxxx
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
Other related posts:
