[THIN] Re: Strange occurrence
- From: Tom Sorenson <tsorenson99@xxxxxxxxx>
- To: thin@xxxxxxxxxxxxx
- Date: Mon, 26 Jan 2009 11:04:04 -0600
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:
