You are currently browsing articles tagged vcenter.

  1. VMVC_20150510_10_000

  2. VMVC_20150510_10_001

  3. VMVC_20150510_10_002

  4. VMVC_20150510_10_003

  5. VMVC_20150510_10_004

  6. VMVC_20150510_10_005

  7. VMVC_20150510_10_006

  8. VMVC_20150510_10_007

  9. VMVC_20150510_10_009

  10. VMVC_20150510_10_008

  11. VMVC_20150510_10_010

  12. VMVC_20150510_10_011

  13. VMVC_20150510_10_012

  14. VMVC_20150510_10_013

  15. VMVC_20150510_10_014

  16. VMVC_20150510_10_015

  17. VMVC_20150510_10_016

  18. VMVC_20150510_10_017

Tags: ,

  1. VMVC_20150510_09_000

  2. VMVC_20150510_09_001

  3. VMVC_20150510_09_002

  4. VMVC_20150510_09_003

  5. VMVC_20150510_09_004

  6. VMVC_20150510_09_005

  7. VMVC_20150510_09_006

  8. VMVC_20150510_09_007

  9. VMVC_20150510_09_008

Tags: ,

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: ,

Install the Microsoft SQL Server

I installed the Microsoft SQL Server (MSSQL) and VMware vCenter Server(vCenter) to the same virtual machine.
In this article, describe the way to install the MSSQL and MSSQL Management tool, and to change the service account for running MSSQL service.

  1. Start up the MSSQL installer, and select the 1st option: “New SQL Server stand-alone installation or add features to an existing installation”.

  2. VMVC_20150510_03_001

  3. VMVC_20150510_03_002

  4. VMVC_20150510_03_003

  5. VMVC_20150510_03_004

  6. VMVC_20150510_03_005

  7. VMVC_20150510_03_006

  8. VMVC_20150510_03_007

  9. VMVC_20150510_03_008

  10. VMVC_20150510_03_009

  11. VMVC_20150510_03_010

  12. VMVC_20150510_03_011

  13. VMVC_20150510_03_012

  14. VMVC_20150510_03_013

  15. VMVC_20150510_03_014

  16. VMVC_20150510_03_015

  17. VMVC_20150510_03_016

  18. VMVC_20150510_03_017

  19. VMVC_20150510_03_018

  20. VMVC_20150510_03_019

  1. VMVC_20150510_04_000

  2. VMVC_20150510_04_001

  3. VMVC_20150510_04_002

  4. VMVC_20150510_04_003

  5. VMVC_20150510_04_004

  6. VMVC_20150510_04_005

  7. VMVC_20150510_04_006

  8. VMVC_20150510_04_007

  9. VMVC_20150510_04_008

  1. VMVC_20150510_05_000

  2. VMVC_20150510_05_001

Tags: ,

This article describes the steps to prepare for installing MSSQL and vCenter Server.

Join the server to the Active Directory Domain

  1. Set the preferred DNS server IP address with the Active Directory DNS server’s IP address.
    In this example, the AD DNS server’s IP address is “”.
  2. To open the [System Properties] dialog, open the [Control Panel] window, and select the [System and Security]-[System]-[Change settings] link.
  3. After opening the [System Properties] dialog, push [Change …] button at [Computer Name] tab.
  4. After opening [Computer Name/ Domain Changes] dialog, select [Domain] radio button and input the AD domain name into the text box.
  5. After selecting [OK] button on the dialog, [Windows Security] dialog will be opened.
    Input the domain administrator username and password, and select the [OK] button.
  6. If authentication is succeed, following “welcome” message dialog will be opened.
    Push the [OK] button for closing the dialog.
  7. Push the [Close] button for closing the [System Properties] dialog.
  8. After closing the dialog, following message dialog will be opened.
    Push the [OK] button.
  9. Following dialog will be opened.
    Push the [Restart Now] button on the dialog if you want to apply changes immediately.

Add the domain service account to local administrator group

  1. Start [Computer Management] tool, and select the [Administrators] group object at [System Tools]-[Local Users and Groups]-[Groups]. After that, open the right-click menu, and select the [Add to Group…] menu item. (Or double-click the [Administrators] group object.)
  2. After opening [Administrators Properties] dialog, push [Add…] button.
  3. After opening [Select Users, Computers, Service Accounts, or Groups] dialog, input “testdomain\app-mssql” domain username into [Enter the object names to select] text box, and push [OK] button.
  4. Check that the domain account is added in [Members] pane.
  5. Add “testdomain\app-vcenter” domain account in the same manner.
    After that, push [OK] button for closing the dialog.

Permit the domain service account as local service accounts

  1. Open [Run] dialog, and input “gpedit.msc” into [Open:] text box.
    After that, push [OK] button for starting Local Group Policy Editor.
  2. After opening [Local Group Policy Editor] Window, select [Log on as a service] policy at [Computer Configuration]-[Windows Settings]-[Security Settings]-[Local Policies]-[User Rights Assignment].
    After that, open the right-click menu, and select the [Properties] menu item. (Or double-click the [Log on as as service] policy.)
    VMW_20150426_04_006< /li>
  3. After opening [Log on as a service Properties] dialog, push [Add User or Group…] button.
  4. After opening [Select Users, Computers, Service Accounts, or Groups] dialog, input “testdomain\app-vcenter” domain username into [Enter the object names to select] text box, and push [OK] button.
  5. Check that the domain account is added in the pane.
  6. Add the “testdomain\app-mssql” domain account in the same manner.
    After that, push [OK] button for closing the dialog.

Check free disk spaces before installation of MSSQL and VMware vCenter

  1. Check drive layouts and free spaces
    • Drive C / for Operating System
    • Drive E / for Application Programs (e.g. MS-SQL, VMware vCenter Server, …)
    • Drive F / for Application Data (e.g. MS-SQL Database & Transaction Logs)

Tags: ,

I’ve setup two service accounts in the Active Directory as follow:
  • “testdomain\app-vcenter” for VMware vCenter Server
  • “testdomain\app-mssql” for Microsoft SQL Server
This article describes the way to create domain account and to set up group policy to deny local logon.

Create domain service accounts in AD

  1. Open the [Active Directory Users and Computers] window at AD server, and open the [<domain-name>]-[Users] folder.
    After that, open the right click menu, and select the [New]-[User] menu item.
  2. After opening the [New Object – User] dialog, input “app-vcenter” domain user account name as following, and push the [Next] button.
    • Input first name into [First name name] text box.
    • Input full name into [Full name name] text box.
    • Input user logon name into “User logon name” text box and [User logon name (pre-Windows 2000)] text box.
    note: In order to simplify the user management, the [pre-Windows 2000] user logon name should be made the same as the [post-Windows 2000] user logon name.
  3. Input the following, and push the [Next] button.
    • Input the user password into the [Password] text box.
    • Uncheck the [User must change password at next logon] check box.
    • Check the [User cannot change password] check box.
    • Check the [Password never expires] check box.
  4. Push the [Finish] button. The [New Object – User] dialog will be closed.
  5. Check that the domain user account is created.
    After that, select the domain user account created, open the right-click menu, and select [Properties] menu item. (Or double-click the domain user account).
  6. After opening [app-vcenter Properties] dialog, input the description of the domain user account into [Description] text box.
  7. Furthermore, set up the domain user “app-mssql” in the same manner as above.

Configure the GPO to deny logon via consoles and remote desktops.

  1.  Open [Group Policy Management] windows, and select the [Forest: <forest-name>]-[Domains]-[<domain-name>] in the tree at the left side of window.
    After that, open the right-click menu and select [Create a GPO in this domain, and Link it here…] menu item.
  2. After opening [New GPO] dialog, input the GPO name as a “Application User Account Access Control”.
    After that, push [OK] button.
  3. Check that the GPO is created.
    After that, select the GPO, open the right-click menu, and select [Edit…] menu item.
  4. Select [Deny log on locally] policy at [Policies]-[Windows Settings]-[Security Settings]-[Local Policies]-[User Rights Assignment].
    After that, open the right-click menu, and select [Properties] menu item. (Or Double clock the policy.)
  5. After opening [Deny log on locally Properties] dialog, check [Define these policy settings] check box, and push [Add User or Group] button.
  6. After opening [Add User or Group] dialog,  input “<domain name>\app-vcenter” domain username, and push [OK] button.
  7. Check that the domain user account is added in the pane.
  8. Furthermore, add “<domain name>\app-mssql” domain user account in the same manner, and push [OK] button.
  9. Check that the accounts are listed in [Policy Settings].
  10. Furthermore, add those domain accounts to [Deny log on through Remote Desktop Services] policy in the same manner as above.
  11. Finally, run gpupdate /force at the AD server’s command prompt to update the group policy immediately.
    PS C:\Users\Administrator> gpupdate /force Updating policy… Computer policy update has completed successfully. User policy update has completed successfully. PS C:\Users\Administrator>

Tags: , , ,