[THIN] Re: KB: CTX107977 - Error 26013. Function InitializeTree2 returned failure in CTX_MF_IMA_InitializeTree2 the database username or password may be wrong

  • From: Philip Walley <mythinlist@xxxxxxxxx>
  • To: thin@xxxxxxxxxxxxx
  • Date: Wed, 25 Jan 2006 08:38:07 -0600

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
************************************************

Other related posts: