As vcloud director 9.5 is the last iteration to support MS SQL we decided to migrate the database to Postgres Here are the instructions to migrate the database Pre-requisites 1) Snapshot all Cells 2) Snapshot MSSQL DB 3) Backup MSSQL DB Procedure: 4) Shutdown all cells service vmware-vcd stop 5) On Read More…
Category: MS SQL
Migrate VMware Update Manager Database
Here are the steps to move a VUM database from an SQL2008 to SQL2014 server. 1) Stop the VUM service 2) Backup the database using SQL Studio Management 2008 Right click the DB (in this case VUMDB) -> Tasks -> Backup > Set the desintation under Back up to -> OK 3) Read More…
Migrate vCloud Director Database from SQL 2008 to 2014
In order to upgrade vCloud Director 8.0.2 -> 8.2.0 a system requirment arose where SQL2008 was not supported. Checking the VMware compatibility matrix, SQL 2014 was on the list so I provisioned a new Windows 2012 server with the view to shutting down the old server. As this was the only DB left on the server Read More…
User Already Exists in the Current Database
Scenario: I was transferring a database (mick) from one SQL2005 server to an SQL2012 server. During the mapping of a user login (mick) I got the following the error: Create failed for User 'mick' User, group, or role 'mick' already exists in the current database Answer: In Studio Management you can use the follwing command : Read More…
List Recovery Model and Compatibility Level for MS SQL DB
Use this query to select the recovery model and compatibility level of a DB on a MS SQL 2005 server. select name, recovery_model_desc, compatibility_level from sys.databases
No Process Is on the Other End of the Pipe
I installed a new Windows 2012 server with SQL 2014. Logging in via Windows authentication was successful but when I tried to login via the sa account I was given the following error: A connection was successfully established with the server, but then an error occurred during the login process No process is on Read More…
Upgrade from SQL 2005 to SQL 2008 R2 Studio Management Fails
I successfully upgraded SQL 2005 Express (32bit) to SQL2008 R2 Express (32bit) for a mini Veeam environment. I then wanted to upgrade Studio Management but got the following error: Rule "SQL Server 2005 Express tools" failed The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools. Read More…
Listing Largest Tables in vCenter Database
Components: vCenter 5.0 / Windows 2008 / SQL Standard Edition 2008 R2 Open SQL Server Management Studio and log in. Click New Query then ensure you have selected the relevant database in the drop down box below. Paste the following code into the right hand side window: select object_name(id) [Table Name],[Table Size] = convert (varchar, dpages Read More…
The storage service is not initialized. Please try again later
Software: VMware vSpehre 5.1 / SQL 2008 R2 After migrating the vCenter database from local SQL 2005 to dedicated 2008 I looked through all the vCenter logs: This appeared in the sms.log [2015-02-20 16:22:29,239 Thread-22 ERROR com.vmware.vim.common.lifecycle.InitializerExecutor] Initialization error; attempt 1202 will begin in 60 seconds… java.util.concurrent.ExecutionException: java.lang.IllegalStateException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The connection to Read More…
Migrating a vCenter Database from Local SQL 2005 to Dedicated SQL 2008
Scenario: I needed to upgrade vSphere from 5.1 to 5.5. Microsoft SQL 2005 is no longer supported so I needed to move the vCenter database from the local machine to dedicated SQL 2008 server before the upgrade. I also had the SSO and Update Manager Database on this local machine. Instructions for moving the SSO DB Read More…
You must be logged in to post a comment.