Tuesday, November 15, 2011

Upgrading SQL 2000 to SQL 2005 - error

When trying to upgrade SQL 2000 to SQL 2005, the SQL 2005 Upgrade advisor throws following error:

Existing Meta Data Services packages should be moved to SQL Server storage (in the msdb database) or to structured storage files before you upgrade. There are no DTS packages in the system...

Ignored the error and tried upgrade anyway but the process stops with error: "Upgrade Advisor returned -1" after complete upgrade analysis

I don't have any DTS packages.

Found solution:
COPIED THIS DLL ONE LEVEL UP
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\bin\BPAClient.dll

and upgrade worked like a charm. Believe its a bug...

REFERENCE: http://forums.databasejournal.com/showthread.php?t=51585
Posted by at

2 comments:

  1. Reggie TaylorDecember 1, 2011 at 7:38 AM

    2. Problem with "lock pages in memory". Just go to local security policy and grant the SQL server service account this right.

    ReplyDelete
  2. Reggie TaylorDecember 1, 2011 at 7:39 AM

    1. Problem with AWE not enabled.
    Had to use SQLCMD to run following script.

    -- Checking for AWE:
    EXEC sp_configure 'show advanced options', 1
    RECONFIGURE
    GO
    -- A config_value/run_value of 0 means that AWE is not enabled
    EXEC sp_configure 'awe enabled'
    GO

    -- Enabling AWE:
    -- (Make sure to grant 'lock pages in memory' to
    -- SQLService account and restart SQL after this change)
    EXEC sp_configure 'awe enabled', 1
    RECONFIGURE
    GO

    REFERENCE:
    http://www.devproconnections.com/article/database-development/enabling-sql-server-awe-memory

    ReplyDelete

Subscribe to: Post Comments (Atom)