|
I tried to move the Virtual Center 2.01 to a new server with SQL Server 2005
After I detached and copied the Database to the new SQL2005 Server I installed the Virtual Center. the setup did not prompt me if I would like to overwritte any existing data. Instead it deleted the existing data and left me with an empty database. So my next step was to remove the empty DB and attache my old DB with all data again. I wasn't able to start the Virtual Center service anymore.
Conclusion: Install the SQL Server 2000 with SP4 or the MSDE
Pre-configure the system and instal all updates
SQL Server 2000 SP4 or the MSDE on new hardware.
Shutdown VirtualCenter server service in the current machine it is running on.
Backup the current SQL Server database and restore onto the new SQL Server 2000 SP4 install or
Detach and copy the DB files to the new Server.
Transfer the existing Virtual Center user to the new SQL Server: see how to
If the SQL Useraccount is not mapped to the Account in the Database you need to run: EXEC sp_change_users_login 'Update_One', 'VC_User', 'VC_User'
Setup the ODBC connection, use the same settings as in the old installation
Install the License Server and then Virtual Center Server in the new physical machine and point it to the database install on the same machine housing the restored or attqached database (ODBC).
You should get prompted to overwrite or keep the existing data (if this dialog doesn't show there is somthing wrong).
Once the install completes reboot the machine.
Configure the License Server and add your active licenses
Start the Virtual Center client.
Configure to use the new License Server: Menue Administration-Virtual Management Server Configuration-License Server
Your host might all be unavailable. Right click on them, disconnect and connact again. You are propted for the usernam, password and there is a dialog that this host is managed by another Server. Just continue with ok and the host should be available again.
You should now be able to see the same settings and configuration details.
Requirements for Running VirtualCenter with MS SQL 2005 KB6565318
|