MS SQL

Migrate VMware Update Manager Database

July 14, 2017 Jordansphere MS SQL

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) […]

More

Migrate vCloud Director Database from SQL 2008 to 2014

June 8, 2017 Jordansphere MS SQL

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 […]

More

migrate vdoud director database, sql 2008, sql2014,

User Already Exists in the Current Database

May 19, 2017 Jordansphere MS SQL

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 :   […]

More

DB migratiion, MS SQL 200, MS SQL 2012, User Already Exists in the Current Database,

List Recovery Model and Compatibility Level for MS SQL DB

May 9, 2017 Jordansphere MS SQL

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

More

No Process Is on the Other End of the Pipe

March 29, 2017 Jordansphere MS SQL

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 […]

More

Upgrade from SQL 2005 to SQL 2008 R2 Studio Management Fails

January 25, 2017 Jordansphere MS SQL

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.   […]

More

Listing Largest Tables in vCenter Database

May 21, 2015 Jordansphere MS SQL

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 […]

More

The storage service is not initialized. Please try again later

February 23, 2015 Jordansphere MS SQL

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 […]

More

Migrating a vCenter Database from Local SQL 2005 to Dedicated SQL 2008

February 19, 2015 Jordansphere MS SQL

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 […]

More

migrating moving sql vcenter db database,

User, group or role ‘RSA_user’ already exists in the current database

February 19, 2015 Jordansphere MS SQL

Scenario: I backed up the vCenter SSO database and copied & restored it from an SQL2005 to an SQL2008 server. This worked fine but when I tried to add the user mapping I got the following:   Create failed for User 'RSA_user'. (Microsoft.SqlServer.smo) This occurred because the user I was trying to add already existed in […]

More

group or role 'RSA_user' already exists in the current database, User,

« Previous Posts

Powered by WordPress. Designed by elogi.