SQL Server Performance

upgrade SQL Server 2000 cluster to SQL Server 2005

Discussion in 'SQL Server 2005 Clustering' started by Hossam, Jul 9, 2009.

  1. Hossam New Member

    Hi all ,

    I'm tasked to upgrading my cluster server from SQL 2000 to SQL Server 2005 , and while upgrading in the Authentication Mode window I choose Mixed Mode and type user name and password but every time get the following error

    TITLE: Microsoft SQL Server Setup
    ------------------------------
    UpgradeAdvisor returned -1 .
    Error message:
    For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=29552
    ------------------------------
    BUTTONS:
    OK
    ------------------------------
    I change the Sa Password to strong password but nothing change using windows authentaction and nothing change just see the error again

    Cluster environment type is Active/Passive
    2 Nodes Windows Server 2003 X64+ SP2
    I have 2 Instances
    SQL Server 2000 x86
    SQL Server 2005 x64

    My target upgrade SQL 2000 instance to SQL Server 2005 x86

  2. ghemant Moderator

    [quote user="Hossam"]I have 2 Instances
    SQL Server 2000 x86
    SQL Server 2005 x64
    [/quote]
    Are you trying to upgrade on the servers which are not identical!!!! Did you try setting up it with the Windows Authentication Mode and once you are able to upgrade it to 2005 you can switch authentication mode to Mixed(though I've not did this), and this should work for you.
    Anyway, refer this links http://social.msdn.microsoft.com/Fo...e/thread/3e64fa17-c1db-4f7f-a37f-a06cb511ba47 , http://www.sqlservercentral.com/articles/Administration/2987/
    You should also run the Upgrade advisor for path blocking if any http://blogs.msdn.com/jpapiez/archive/2005/09/28/474930.aspx and http://blogs.technet.com/andrew/archive/2008/03/26/sql-server-upgrade-advisor.aspx
  3. Hossam New Member

    Thanks and appreciate your replay Could you please describe more about "trying to upgrade on the servers which are not identical!!!???"Yes i tried setting up it with windows authentication but actually I got the same error. What is the path locking you talking about, please clarify. Regards, thanks in advance
  4. ghemant Moderator

    The servers you've mentioned are x86 and x64 and hence are not identical. What I mean by path blocking is when we run the upgrade advisor it will report us if there is anything which won't allow you to upgrade your servers.

Share This Page