[THIN] Re: Strange occurrence

I believe you are correct Chris, thanks.  Joe I did check and it has the
correct DSN information.  Just for future reference it is at
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Citrix\IMA in 64bit XenApp.  I think
I've got enough information to point the finger at my DBA's now.  Thanks for
all the help.

On Mon, Jan 26, 2009 at 10:54 AM, <christopher.walter@xxxxxxx> wrote:

>  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> 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
>
>
>
>
>
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email
> ______________________________________________________________________
>

Other related posts: