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. #####################################################################################