2 Replies Latest reply on Jan 20, 2014 4:38 AM by Graham A

    Downgrading version of SQL

      Share:|

      Due to licensing costs we are having to downgrade (uninstall & re-install) all of our SQL Server 2008 R2 Enterprise installations to SQL 2008/2012 Standard Edition. (sigh)

       

      I have read the various knowledge base articles on moving database servers or the trackit installation data or both etc but none of them seem to apply, I have tried on a test server to backup the trackit database and restore, checking all the configs passwords etc - even following the Microsoft Knowledgebase article on backing up SQL users and passwords and restoring but without any positive results.

       

      I just want to uninstall enterprise edtion and install standard SQL on the same server keeping everything the same, has anyone done this or got any advice?

       

      Many thanks.

        • 1. Re: Downgrading version of SQL

          Hi Graham,

           

          This should be a pretty painless operation. Firstly, obviously make a backup of your current Track-It! Database.

          Then uninstall/reinstall your SQL install.

          Create a new database in your new install and restore. Now make a note of your SQL Security users here :

          Capture.JPG.jpg

          Now, go to :\Program Files\BMC Software\Track-It!\Track-It! Services\ConfigurationData and edit the TrackIt.Core.DataAccess.xml file and ensure your SQL users here match what you checked in SQL, if they don't then change the .xml file to match your SQL database.

           

          Now go to :\Program Files\BMC Software\Track-It!\Track-It! Server  and edit the Trackit.cfg file
          Make sure the ODBC section matches your new database, the SERVER= (make sure the name is correct) also the TRACKIT_USER matches your SQL database user.

           

          Once this is done, run the following SQL Script against your new database, changing the database name and users to match yours :

           

          Use master
          Go

          EXEC sp_addlogin 'TRACKIT80', 'TI_DB_P@ssw0rd', 'TRACKIT_DATA' -- Change database name if different
          EXEC sp_addlogin 'TrackitApp', 'TI_DB_P@ssw0rd', 'TRACKIT_DATA' -- Change database name if different
          EXEC sp_addlogin 'TrackitRpt', 'TI_DB_P@ssw0rd', 'TRACKIT_DATA' -- Change database name if different
          EXEC sp_addlogin 'TrackitSecurity', 'TI_DB_P@ssw0rd', 'TRACKIT_DATA' -- Change database name if different
          go

          USE TRACKIT_DATA-- Change database name if different
          GO

          EXEC sp_change_users_login 'Auto_Fix', 'TRACKIT80'
          EXEC sp_change_users_login 'Auto_Fix', 'TrackitApp'
          EXEC sp_change_users_login 'Auto_Fix', 'TrackitSecurity'
          EXEC sp_change_users_login 'Auto_Fix', 'TrackitRpt'
          go

          EXEC sp_change_users_login 'Update_One', 'TRACKIT80', 'TRACKIT80'
          EXEC sp_change_users_login 'Update_One', 'TrackitApp', 'TrackitApp'
          EXEC sp_change_users_login 'Update_One', 'TrackitRpt', 'TrackitRpt'
          EXEC sp_change_users_login 'Update_One', 'TrackitSecurity', 'TrackitSecurity'
          go


          You should be good to go now.

           

          Hope this helps

           

          Paul

          1 of 1 people found this helpful
          • 2. Re: Downgrading version of SQL

            Thank you very much, worked like a treat once I had remembered to switch SQL auth to both Windows and SQL!

             

            Cheers.