Vcenter Linked mode Installation

Vcenter Linked Mode Installation :-
Make sure Frewall is trun off.
Install the vcenter application with generic account domain admin rights.
Make sure Generic account can login as service and login as batch.
SQL Native Driver installed from Microsoft SQL based on the version.

Creating 64-bit DSN :-
1)Program files -ODBC driver for 64-bit
2)system DSN -> ADD
3)Put the name of vCenter,Descrition and SQL server name
4)Make sure the account you login has access to the Database and MSDB

Creating 32-bit DSN for Update manager which is 32 Bit always:-
1) C:\Windows\SysWOW64\odbccad32.exe
2)system DSN -> ADD
3)Put the name of Updatemanager,Descrition and SQL server name
4)Make sure the account you login has access to the Database and MSDB

Create a new SQL Server database user with database operator (DBO) rights

1  Create a vCenter Server database user with the db_datawriter and db_datareader permissions.
2  Open a query analyzer window with a user having DBO rights on the vCenter Server and MSDB   databases.
3  Locate the dbschema scripts in the vCenter Server installation package /<installation directory>/vpx/dbschema directory.
4  Run the scripts in sequence on the database.
The DBO user must own the objects created by these scripts. Open the scripts one at a time in the Query Analyzer window and press F5 to execute each script in the order shown here.
VCDB_mssql.SQLpurge_stat1_proc_mssql.sqlpurge_stat2_proc_mssql.sqlpurge_stat3_proc_mssql.sqlpurge_usage_stats_proc_mssql.sqlstats_rollup1_proc_mssql.sqlstats_rollup2_proc_mssql.sqlstats_rollup3_proc_mssql.sqlcleanup_events_mssql.sqldelete_stats_proc_mssql.sqlupsert_last_event_proc_mssql.sqlload_usage_stats_proc_mssql.sqlload_stats_proc_mssql.sql5  For all supported editions of Microsoft SQL Server (except Microsoft SQL Server 2005 Express), ensure that the SQL Server Agent service is running by using these additional scripts to set up scheduled jobs on the database.
job_schedule1_mssql.sqljob_schedule2_mssql.sqljob_schedule3_mssql.sqljob_cleanup_events_mssql.sql