Reinstalling vCenter Server with new DSN credentials fails with the error: Past day stats rollupVCDB was created by another user

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:

• Reinstalling vCenter Server 5.1.x and 5.5 with new DSN credentials fails.
• The vminst.log contains entries similar to:
  
  Note: The vminst.log file is located in the Temp directory:
   
  • • For Windows 2008, the vminst.log file is located at: C:\Users\<User Name>\AppData\Local\Temp
    • For Windows 2003, the vminst.log file is located at: C:\Windows\Temp
      
      VMware VirtualCenter-build-947673: SQL Server Agent is not running or query error.
      VMware VirtualCenter-build-947673: Getting Property DB_DSN_SERVER_REMOTE = 1
      VMware VirtualCenter-build-947673: errorMessage is <Database job [Past day stats rollupVCDB] was created by another user. Use the same user to setup your DSN or remove the job. ODBC Error: [Microsoft][SQL Server Native Client 10.0][SQL Server]The specified @job_name ('Past Day stats rollupVCDB') does not exist.<br>
      VMware VirtualCenter-build-947673: Getting Property UILevel = 5
      VMware VirtualCenter-build-947673: Getting Property ProductName = VMware vCenter Server

Environment

VMware vCenter Server 5.5.x
VMware vCenter Server 5.1.x

Cause

The issue can occur if you modify the vCenter Server database. For example:

• The vCenter Server database is moved to a different server.
• You change the login details (such as the ODBC DSN user login) for the database to which the DSN points.

Resolution

To resolve this issue, run a SQL query to delete the Past Day stats rollup VCDB agent job.

Caution: Take a complete backup of the vCenter Server database before making any changes.

To delete the Past Day stats rollup VCDB agent job:

1. Launch SQL Server Management Studio.
2. Run the query:
   
   SELECT [job_id],
   [originating_server_id],
   [name],
   [enabled],
   [description],
   [start_step_id],
   [category_id],
   [owner_sid],
   [notify_level_eventlog],
   [notify_level_email],
   [notify_level_netsend],
   [notify_level_page],
   [notify_email_operator_id],
   [notify_netsend_operator_id],
   [notify_page_operator_id],
   [delete_level],
   [date_created],
   [date_modified],
   [version_number]
   FROM [msdb].[dbo].[sysjobs]
    
3. Delete the JOB ID with the name Past Day stats rollup VCDB using the command:
   
   msdb.dbo.sp_delete_job "JOB ID" ;

Additional Information

vCenter Server installation fails with ODBC and DSN errors

Impact/Risks:
Before making any changes to the vCenter Server database, take a full backup of the database.