VMware vCenter Setup 4 of 6

Create the vCenter Server DB “VCDB”


  1. VMVC_20150510_05_002

  2. VMVC_20150510_05_003

  3. VMVC_20150510_05_004
    use [master] go CREATE DATABASE [VCDB] ON PRIMARY (NAME = N’vcdb’, FILENAME = N’C:\VCDB.mdf’, SIZE = 10MB, 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 CREATE LOGIN [vpxuser] WITH PASSWORD=N’vpxuser!0′, DEFAULT_DATABASE=VCDB, DEFAULT_LANGUAGE=us_english, CHECK_POLICY=OFF go CREATE USER [vpxuser] for LOGIN [vpxuser] go use MSDB go CREATE USER [vpxuser] for LOGIN [vpxuser] go

  4. VMVC_20150510_05_005

  5. VMVC_20150510_05_006

  6. VMVC_20150510_05_007

  7. VMVC_20150510_05_008

  8. VMVC_20150510_05_009

  9. VMVC_20150510_05_010

  10. VMVC_20150510_05_011

  11. VMVC_20150510_05_012

  12. VMVC_20150510_05_013

  13. VMVC_20150510_05_014

  14. VMVC_20150510_05_015

  15. VMVC_20150510_05_016

Grant the “VCDB” DB ownership to the domain user “testdomain\app-vcenter”


  1. VMVC_20150510_05_017

  2. VMVC_20150510_05_018

  3. VMVC_20150510_05_019

  4. VMVC_20150510_05_020

  5. VMVC_20150510_05_021

Configure the SQL Server Browser to start up automatically by domain user “testdomain\app-mssql”.


  1. VMVC_20150510_06_000

  2. VMVC_20150510_06_001

  3. VMVC_20150510_06_002

  4. VMVC_20150510_06_004

  5. VMVC_20150510_06_003

  6. VMVC_20150510_06_005

  7. VMVC_20150510_06_007

Configure the SQL server network configuration to access DB by TCP/IP.


  1. VMVC_20150510_07_000

  2. VMVC_20150510_07_002

  3. VMVC_20150510_07_001

  4. VMVC_20150510_07_003

  5. VMVC_20150510_07_004

  6. VMVC_20150510_07_005

  7. VMVC_20150510_07_006

  8. VMVC_20150510_07_007

  9. VMVC_20150510_07_008

Appendix: Configure the Windows Firewall to allow MSSQL inbound connection


  1. VMVC_20150510_08_000

  2. VMVC_20150510_08_001

  3. VMVC_20150510_08_002

  4. VMVC_20150510_08_003

  5. VMVC_20150510_08_004

  6. VMVC_20150510_08_005

  7. VMVC_20150510_08_006

Tags: ,

Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>