Happy to report that I've gotten around the issue. Not 100% sure of the cause though...? Here's what I did: - Created a database on a different SQL server, running SQL 2000 sp3a (rather than SQL 2000 sp4) - Used the default instance on this new server (rather than a non-default instance name - XXX\INST03CITRIX [where XXX = server name]) This not only resolved the 26013 error, but eliminated the two "glitches" I'd reported during the install. Now, to apply hotfixes and WI4... James Uhrich -----Original Message----- From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Philip Walley Sent: Wednesday, January 25, 2006 6:38 AM To: thin@xxxxxxxxxxxxx Subject: [THIN] Re: KB: CTX107977 - Error 26013. Function InitializeTree2 returned failure in CTX_MF_IMA_InitializeTree2 the database username or password may be wrong James, had that happen with 3 or 4 of my servers (out of 20) as I was upgrading. I wondered if I would hear about it later. As you have come to find out, the only work around when you get this message is to have it create a local access db and finish the install. Once that is done and rebooted, you can run a chfarm and it will join the farm but your IMA will not start. Take a copy of the mf20.dsn from a currently working server and put it in place on the one that you are building. Make sure to edit it so that the server name is correct in the dsn. You can use notepad for that task (in case you didn't know). Once that is done, reboot and it should come up all fine and dandy. I have not had stability issues with the servers that experienced this issue. I've been up for 2 months now and everything is cool. Good luck pw Uhrich, James wrote: > Hi Rick, > Sorry - let me clarify... > When I say remote, I mean a SQL server which is actually in a > secondary data center a few hundred feet from the rest of the farm. > I'm pretty sure it's not a connectivity issue to the datastore. > Thanks, > James > > -----Original Message----- > *From:* thin-bounce@xxxxxxxxxxxxx > [mailto:thin-bounce@xxxxxxxxxxxxx]*On Behalf Of *Rick Mack > *Sent:* Monday, January 23, 2006 10:52 PM > *To:* thin@xxxxxxxxxxxxx > *Subject:* RE: [THIN] Re: KB: CTX107977 - Error 26013. Function > InitializeTree2 returned failure in CTX_MF_IMA_InitializeTree2 the > database username or password may be wrong > > Hi James, > If you're getting timeouts creating the datastore, that doesn't > bode well for the long term reliabilty of your remote datastore > connection. > I guess the best short term solution is to use MSDE installed > locally (preferably not on one of your farm servers) to create the > farm. You've then got the option of copying the database to > somewhere else or even replicating the datastore if > connectivity/bandwidth to the remote SQL system is an ongoing issue. > I wouldn't waste any more time trying to do anything with the > remote SQL server. Once your SQL connectivity is sorted out > (MSDE?) things should work for you. > regards, > Rick > Ulrich Mack > Volante Systems > ------------------------------------------------------------------------ > *From:* thin-bounce@xxxxxxxxxxxxx on behalf of Uhrich, James > *Sent:* Tue 24/01/2006 16:31 > *To:* thin@xxxxxxxxxxxxx > *Subject:* [THIN] Re: KB: CTX107977 - Error 26013. Function > InitializeTree2 returned failure in CTX_MF_IMA_InitializeTree2 the > database username or password may be wrong > > Hi all, > > I'm building a new farm and can't seem to get around this 26013 error. > > My database is on a remote Win2K3 server running sql 2000 sp4. > > My PS 4 server is Win2K3sp1. The error comes up during the PS 4 > install. Get thru the DSN config - tests OK. Then 26013 error > comes up. > > Have tried everything in article re: creating new database, > confirming settings, etc...still no go. > > Is the only solution to create an access db, then convert at some > later point? > > Also, is anyone else experiencing some "bugs" during the PS4 > install? Two consistent issues keep coming up: > 1) During DSN config, after I've selected the sql server to > connect to, the only options are "cancel" or "Help". "Next" and > "Finish" are greyed out. I have to go in and select it a second > time to continue > 2) After DSN config is complete, data store credentials are > requested. When credentials are entered, "please enter a valid > windows user account" is displayed. If I go "back", and go thru > the DSN config again, then re-enter the same credentials, it > continues. > > Thanks for any help, > > James Uhrich > > > -----Original Message----- > From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx]On > Behalf Of Philip Walley > Sent: Tuesday, December 06, 2005 7:31 AM > To: thin@xxxxxxxxxxxxx > Subject: [THIN] Re: KB: CTX107977 - Error 26013. Function > InitializeTree2 returned failure in CTX_MF_IMA_InitializeTree2 the > database username or password may be wrong > > > wow, an article finally. I've come across this several time. The only > way that I have been able to get around it and actually join my > farm is > to have it create a local access db during the install. after > reboot, do > a chfarm which will join but the IMA service will not start. I grab a > copy of the mf20.dsn from a working server, change the server name in > the dsn to the non working server name and place it on the server > who's > IMA service will not start. then the IMA starts and things are slick. > > Jim Kenzig http://Kenzig.com wrote: > > > CTX107977 - Error 26013. Function InitializeTree2 returned > failure in > > CTX_MF_IMA_InitializeTree2 the database username or password may > be wrong > > This document was published at: > > http://support.citrix.com/article/CTX107977 > > Document ID: *CTX107977*, Created on: Nov 16, 2005, Updated: Dec > 5, 2005 > > Products: Citrix MetaFrame Presentation Server 3.0 for Microsoft > > Windows 2003, Citrix MetaFrame Presentation Server 3.0 for Microsoft > > Windows 2000, Citrix Presentation Server 4.0 for Microsoft Windows > > 2000, Citrix Presentation Server 4.0 for Microsoft Windows 2003, > > Citrix MetaFrame XP 1.0 for Microsoft Windows 2000, Citrix MetaFrame > > XP 1.0 for Microsoft Windows 2003 > > *Symptoms* > > When installing Citrix Presentation Server to use SQL as a data > store > > the user may receive the error message: > > "Error 26013. Function InitializeTree2 returned failure in > > CTX_MF_IMA_InitializeTree2 the database username or password may be > > wrong." > > This occurs even though the user has created a DSN, and the ODBC > tests > > completed successfully. > > Installation is then terminated and Presentation Server is not > installed. > > *Cause* > > While creating the DSN, the user may have cleared the following > check > > boxes: > > > > - Use ANSI quoted identifiers, and > > - Use ANSI nulls, paddings and warnings > > These options are normally selected by default. > > > > *Resolution* > > Create a new, blank database and during installation ensure that > these > > two options are enabled in the Microsoft SQL Server DSN > Configuration. > > Installation should now complete successfully. > > *Note:* If the installation is started with the same database as was > > used in a previously unsuccessful installation it may return the > same > > error as before. This is because the database may have been > partially > > created in the previous installation attempt and contains the > > incorrect information which causes the error. > > *Scenario 2* > > The same error message is received, however this time you are trying > > to use an Access Database for the data store. > > *Resolution 2* > > Refer to CTX108267 - IMA Service Fails with Specific Error: > 2147483649 > > <http://support.citrix.com/article/entry.jspa?entryID=8548>. > > > ************************************************ > For Archives, RSS, to Unsubscribe, Subscribe or > set Digest or Vacation mode use the below link: > //www.freelists.org/list/thin > ************************************************ > ************************************************ > For Archives, RSS, to Unsubscribe, Subscribe or > set Digest or Vacation mode use the below link: > //www.freelists.org/list/thin > ************************************************ > > ######################################################################## ############# > > This e-mail, including all attachments, may be confidential or > privileged. Confidentiality or privilege is not waived or lost > because this e-mail has been sent to you in error. If you are not > the intended recipient any use, disclosure or copying of this > e-mail is prohibited. If you have received it in error please > notify the sender immediately by reply e-mail and destroy all > copies of this e-mail and any attachments. All liability for > direct and indirect loss arising from this e-mail and any > attachments is hereby disclaimed to the extent permitted by law. > > ######################################################################## ############# > ************************************************ For Archives, RSS, to Unsubscribe, Subscribe or set Digest or Vacation mode use the below link: //www.freelists.org/list/thin ************************************************ ************************************************ For Archives, RSS, to Unsubscribe, Subscribe or set Digest or Vacation mode use the below link: //www.freelists.org/list/thin ************************************************