[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1488
  • Last Modified:

How to determine if vcenter is using local or external SQL Database?

Not sure how to verify this since I did not install vcenter.  I want to upgrade from 4.0 to 4.1 and noticed the guides reference backing up the DB.  How can I confirm which DB was selected during the install and where it resides?  
0
dkraut
Asked:
dkraut
3 Solutions
 
Justin CAWS Solutions ArchitectCommented:
Go to Start-Admin Tools-Data Sources (ODBC).  You will see the SQL Native Client entry for VMware VirtualCenter.  Look at the properties of that connector, the bottom entry on the first page will list the server and SQL instance that vCenter is currently using.

Hope that helps!
0
 
thakurdineshCommented:
Look at the property of the ODBC connectore from the start admin.. there will be an entry for currently using instance for vCenter
0
 
vmwarun - ArunCommented:
On the vCenter server, click Start -> Programs -> Administrative Tools -> Data Sources (ODBC)

Under System DSN, if a connection has been configured, then the vCenter DB is in a remote SQL.

If not, if you find SQL Management Studio or any SQL Program files under Start Menu, then the vCenter DB is local.
0
 
dkrautAuthor Commented:
Thanks Guys, I was looking at the ODBC and there was no user/system DSN listed, but I read a conflicting article referencing the ODBC drivers, which I do have so I wanted to confirm.  I have SQL Server 2005 listed under start > programs so I'll presume the person that set it up used the local SQL express option.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now