Saturday , November 18 2017
Home > vSphere Guides > How to Create Database & DSN for vCenter Server

How to Create Database & DSN for vCenter Server

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

Step 1:
Open SQL Management Studio & connect to your server.
1

Step 2:
Right click on Databases & click new database.
2

Step 3:
Provide the name of your database & click ok to create database. Here you can do additional settings also as per your requirement.

3

How to Create Database user :-

Step 5:
Right click on Security & click new , select Login to create new user.
4

 

Step 6:
Provide the database name. click SQL server authentication & provide password for the user. choose default database to your vcenter database.
5

 

Step 7:
Click on User Mapping. choose your database & provide the db_owner permission. click ok to save.
6


How to Create DSN:-

Step 1:
Click on Server Manager.

1


Step 2:

Click on Tools & choose the ODBC Data Sources (64-bit).
2

 

Step 3:
Choose the System DSN tab & click on Add.
3

 

Step 4:
Choose the correct latest ODBC Driver & click Finish.
4

 

Step 5:
Provide the data source name & description any name you can give. Provide the server Name & click Next to continue.

5

 

Step 6:
Choose SQL Authentication & provide the username & password you have created in SQL Server. click Next to continue.

6

 

Step 7:
Check on change default database & choose your database from drop-down list. leave all the setting to default. click Next to continue.
7

 

Step 8:
Leave all the settings as it is & click Finish to continue.
8

 

Step 9:
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.

9

 

Step 10:
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.

Checkout our Facebook Group for Discussions & More Stuff.
Like & Share our Facebook Page for Latest Updates.

About Mayur Parmar

Hi I am Mayur Parmar. Independent Author & Founder of Mastering VMware. I am working in IT industry for more than 2 Years with knowledge of VMware , Microsoft Server’s, Linux Server’s.

Check Also

patch-ESXi-image-0

How to Patch ESXi Host using VUM Step by Step

In this series of vSphere Update Manager we worked on How to install vSphere Update …

2 comments

  1. Hi,

    I have an existing vCenter with the built-in database of MS SQL Express. The problem now is that it’s already past its limit and vCenter service is no longer running. Which of this solution will work?
    1. Install a Full SQL Server on the vCenter and transfer the database there.
    2. Backup the database of vCenter and restore it on a remote server that has a Full SQL Server installed.

    When I have my database on a remote sql server is ODBC DSN needed?

    • @janus
      First If you have database on remote or local ODBC DSN will required for connectivity of database.

      In the Scenario you have mentioned where you have limitation of MS SQL Express you can google following VMware KB Article :-
      VMware KB 1028601

Leave a Reply

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

18 + 3 =