Post reply

SQL Server 2000 Upgrade from Standard to Enterprise edition

  • November 28, 2005 at 3:43 pm

    #112820

    We have upgraded a SQL Server 2000 Standard Edition (sp4) installation and Analysis Services to Enterprise edition.

    The upgrade was done using the SQL SERVER 2000 Enterprise autorun, with the upgrade options.

    The upgrades completed successfully and the server was restarted after each of the upgrades (sql server and Analysis services)

    However, we have lost all of the linked server settings that were existing prior to the upgrade and do not know what they were.

    Is there a way we can recreate these or find out what there were from backups of system databases taken prior to upgrade?

    We also hit permission errors connecting to the server via the analysis services manager - This was resolved by using the same account used by MSSQLSERVER service to start the MSSQLServerOLAPService.

    Thanks

    Glenn

  • November 28, 2005 at 7:44 pm

    #606292

    The tables sysservers has most of the info you are after and sysxlogins has the rest. Restore your old master database as something like master_old and check out the contents of these tables.

    FYI : I found the table names in sproc sp_addlinkedserver

  • November 29, 2005 at 2:01 pm

    #606542

    Here's a system table map to assist you a bit further ...

    http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

    sysservers and sysremotelogins are the primary tables yopu need to look at. sysxlogins will not help you much unless you scripted out the logins prior to the upgrade with sp_help_revlogin ... link follows ...

    http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • December 7, 2005 at 2:09 pm

    #608266

    Thanks for the responses.

    Cheers

    Glenn

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply