Emergency Question about data store

[timscronin]

We have a metaframe xp install which uses SQL Server for the data store. Having problems when we tried to add server to farm. If I go back to a sqlbackup of the datastore from before we tried to add server, will that set the farm/server info back to before we tried to add, or is that info store some place else?

 

[scanjam]

I had a number off issues when joining our 2003 server to the newly created Citrix Farm. I never bothered about restoring the SQL database though if the server failed in joining.

If you open the CMC does the server you previously tried to join actually appear in the Servers tab?

THe issue in the end for us was we were simply not enabling
Use ANSI quoted Identifiers
Use ANSI Nulls....
and
Perform Translation for Character Data

in the ODBC settings for the database connection... i was never actually aware the Citrix required these, but on our 2003 servers this just didnt work unless the above settings were selected.

Hope this helps in some way?

James

 

[KCDave03]

so the install is not completing because of it's inability to connect to the datastore?

 

[scanjam]

well that all depends on the error message you were getting. I only suggested it because it was such a simple ODBC change, and the servers then connected.

The errors we received were consistently the same.
If you received any of the following:

Error 26005 - Could Not Start IMA Service....
Error 26013 - Function InitializeTree returned failure in CTX_MF_IMA_InitializeTree the database username or password may be wrong

(even though the username and password were NEVER wrong)

You could try the above mentioned ODBC settings??

Hope it helps.
James