In the second post of vCenter installation on Windows Server 2012 R2 with Microsoft SQL Server 2014 I will cover vCenter Databases creation and ODBC connectivity.
I used ISO VMware-VIMSetup-all-5.5.0-2183112-20140901-update02.iso which translates to following version of vCenter Server 5.5 Update 2b, released 09 OCT 2014 with build number 2183111.
Microsoft SQL Server 2014 configuration
- Open SQL Server 2014 Management Studio and authenticate with username and password.
- In SQL Server 2014 Management Studio and navigate to Security \ Logins and click New Login.
- In previous post we created application user called ap-mssql and ap-vcenter. I used ap-mssql user to start all SQL Server 2014 services and ap-vcenter will be used to start all VMware services. I will use ap-mssql user to connect between vCenter and SQL server.
- In General section I provided username
- In Server Roles section we select only public.
vCenter Server 5.5 database creation
We will create vCenter database manually. We will use following options:
- Collation – SQL Server Collation Model: SQL_Latin1_General_CP1_CI_AS.
- Recovery model – Full
- Compatibility type – SQL Server 2014
- Click on Databases and select New Database.
- Enter your database name. I used a simple name vCenterDB and owner of DB is previously created user ap-mssql.
- In Options I changed collation to SQL_Latin1_General_CP1_CI_AS, recovery mode to Simple and SQL compatibility model to SQL Server 2014.
- Click OK.
- Last step is to change application user ap-mssql Default Database. Navigate to Logins and select your user. In General select Default Database to your vCenter Database.
- Now we are ready to install vCenter.
vCenter Database backup
In earlier post I wrote that I will follow SQL Server Best Practices and I would like to configure Transaction Log backup in advance. Before we can execute Transaction Log backup we have to start full backup.
After full backup is completed we can prepare Transaction Log backup.
- Click on vCenter Database, select Tasks and Back up.
- In General select backup type as Transaction Log. If you configured disks and SQL server as I did in earlier post, then backup destination will be pre-selected.
- In Media I selected Append to the existing backup set, Verify backup when finished and Back up the tail of the log, and leave the database in the restoring state.
- In Backup Options I selected expiration date of backup and compression level.
- Click ok.
More detailed description is available on Microsoft MSDN article http://msdn.microsoft.com/en-us/library/ms189606.aspx.
MSSQL ODBC configuration
Last step before we will install vCenter Server Database is ODBC configuration.
- Go to Control Panel and then to Administrative Tools and we select ODBC Data Sources (64-bit).
- Click System DSN, select Add and click SQL Server Native Client 11.0.
- Provide name for the ODBC connection and select your SQL Server.
- Select Change the default database to: and select your database.
- Click next and finish. At the end click Test Data Source. If you configured everything correctly then you should see same result as I have.
After preparing ODBC connectivity we can proceed with vCenter Server installation. This will be covered in third post.
My experience and skills has been proven by leading vendor certifications like VMware Certified Advanced Professional 5 – Data Center Administration, VMware Certified Advanced Professional 5 – Data Center Design, VMware Certified Professional 6 - Data Center Virtualization, VMware Certified Professional 6 - Network Virtualization, Microsoft MCITP Server Administrator, ITIL V3, VMware vExpert 2014, 2015, 2016 and 2017 Award.
My blog wojcieh.net - was voted #50 in TopvBlog 2016 contest!
Latest posts by Wojciech Marusiak (see all)
- How to add NFS export to VMware ESXi 6.5 - 12 April, 2017
- Migration of Windows vCenter Server 6.x to vCenter Server 6.5 Appliance - 10 March, 2017
- Altaro VM Backup 7.0 released with new great features - 7 March, 2017