[THIN] Re: Strange occurrence

I believe 28000 is the error code which basically means access is denied.

Chris

________________________________
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of 
Tom Sorenson
Sent: January 26, 2009 11: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<mailto: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> 
[mailto:thin-bounce@xxxxxxxxxxxxx<mailto:thin-bounce@xxxxxxxxxxxxx>] On Behalf 
Of Tom Sorenson
Sent: Monday, January 26, 2009 9:14 AM
To: thin@xxxxxxxxxxxxx<mailto: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<mailto: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> 
[mailto:thin-bounce@xxxxxxxxxxxxx<mailto:thin-bounce@xxxxxxxxxxxxx>] On Behalf 
Of Tom Sorenson
Sent: Monday, January 26, 2009 8:37 AM
To: thin@xxxxxxxxxxxxx<mailto: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




______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________

Other related posts: