The first statement removes the old server instance (replace W2K3-VC with your old server name), the second statement adds the new server instance (replace VIRTUALCENTER with your new server name).
Sp_addserver 'VIRTUALCENTER\SQLEXP_VIM', local This is done by installing the "SQL Server Management Studio Express" and then executing the following TSQL statements:
VMWARE VIRTUALCENTER SERVER EVENT ID 1000 UPDATE
If you rename a SQL server, you need to internally update the system tables using a set of stored procedures in order to make everything consist again. For my small, nonproduction environment, I use SQL Server 2005 Express edition that comes with the VirtualCenter installation. Renaming SQL servers is a bad idea in general (so it appears).The problem was in fact twofold, the solution rather simple: This has been discussed before on the VMWare forums ( here and here), but I post it here because I did not immediatelly find a step-by-step walkthrough. Somehow, this didn't come as a surprise ). However, after the hostname change, the VMWare VirtualCenter service would no longer start with an Event ID 1000 in the eventlog. This also seemed like a perfect opportunity to rename the server's hostname from to. After running my VirtualCenter server on a standalone host for quite some time, I decided to join it into the domain that I am running on my ESX box (in order to let it participate in the automated WSUS patching mechanism).
0 kommentar(er)
