vCenter Server uses Database for its inventory & other information storage. you can use either Oracle or MS SQL Database or you can use the built-in Database.
You can install the SQL Server on same server or on different server but it is better to keep database on different server.
In this guide i will be using the SQL Enterprise server 2014 & i will show you how to create the database, database user & ODBC DSN for vcenter server database.
How to Create Database for vCenter Server:-
Open SQL Management Studio & connect to your server.
Right click on Databases & click new database.
Provide the name of your database & click ok to create database. Here you can do additional settings also as per your requirement.
How to Create Database user :-
Right click on Security & click new , select Login to create new user.
Provide the database name. click SQL server authentication & provide password for the user. choose default database to your vcenter database.
Click on User Mapping. choose your database & provide the db_owner permission. click ok to save.
How to Create DSN:-
Click on Server Manager.
Click on Tools & choose the ODBC Data Sources (64-bit).
Choose the System DSN tab & click on Add.
Choose the correct latest ODBC Driver & click Finish.
Provide the data source name & description any name you can give. Provide the server Name & click Next to continue.
Choose SQL Authentication & provide the username & password you have created in SQL Server. click Next to continue.
Check on change default database & choose your database from drop-down list. leave all the setting to default. click Next to continue.
Leave all the settings as it is & click Finish to continue.
Here one windows will open click Test Data Source to test your database connectivity if it successful you will get message “TESTS COMPLETED SUCCESSFULLY” or if you get any error check SQL Services & ports of SQL.
Click ok to close the windows & you have successfully created the ODBC DSN Driver to use in vCenter Server.
Checkout our post on How to install vCenter Server 6 Step by Step ?
That’s it for Today Friends. I Hope you liked reading this post & If you find anything more to be added or removed feel free to write it in our comments. If you find it useful You are Feel free to share this on social media to help others & spread knowledge.
If you have any query on any thing you are free to write it in our comments section & we will make sure to provide you the better solution as soon as possible.