Installing VMware vSphere 5.5 Series: Part 1: Introduction and ESXi Installation Part 2: Microsoft SQL 2012 Installation Part 3: Creating the vCenter Database & ODBC Setup Part 4: vCenter 5.5 Installation Part 5: Initial Setup (Accessing vCenter, Configure Basic Permissions, Add Host) Now that we have SQL installed its time to setup the vCenter database and ODBC connections. Creating the vCenter Database If you are experienced in SQL you can set the database up manually or use the provided schema SQL script from VMware vCenter installation media. In this install i’ll be using the VMware provided DB schema. This can be obtained in the \\vCenter Installation Media\vCenter-Server\dbschema\DB_and_schema_creation_scripts_MSSQL.txt To make it easier below is a copy/paste of the script. You will have to change the database name, username, password and database location to match your setup. use [master] go CREATE DATABASE [VCDB] ON PRIMARY (NAME = N’vcdb’, FILENAME = N’C:\VCDB.mdf’ , SIZE = 3000KB , FILEGROWTH = 10% ) LOG ON (NAME = N’vcdb_log’, FILENAME = N’C:\VCDB.ldf’ , SIZE = 1000KB , FILEGROWTH = 10%) COLLATE SQL_Latin1_General_CP1_CI_AS go use VCDB go sp_addlogin @loginame=[vpxuser], @passwd=N’vpxuser’, @defdb=’VCDB’, @deflanguage=’us_english’ go ALTER LOGIN [vpxuser] WITH CHECK_POLICY = OFF go CREATE USER [vpxuser] for LOGIN [vpxuser] go CREATE SCHEMA [VMW] go ALTER USER [vpxuser] WITH DEFAULT_SCHEMA =[VMW] go Open SQL Server Management Studio and login using an account that has access: Now click on …
Read more…