RvdNieuwendijk
Leadership
Leadership

Database connection error: Unknown DSN type SQL Server Native Client 11.0

While configuring VMware vCenter Orchestrator to use the vCenter Server database, the configuration of the database gives the error:

Cannot connect to jdbc:vdb:VCDB. Connection error was: Unknown DSN type for VCDB: type = SQL Server Native Client 11.0, driver = C:\Windows\system32\sqlncli11.dll

The SQL Server Native Client 11.0 driver is used in the System DSN ODBC connection to the vCenter Server database. vCenter Server runs fine and has no problems connecting to the database. The selected database type in vCO is: vDB. The DSN of the vCenter Server database is: VCDB.

Does anybody know how to solve this problem?

Blog: https://rvdnieuwendijk.com/ | Twitter: @rvdnieuwendijk | Author of: https://www.packtpub.com/virtualization-and-cloud/learning-powercli-second-edition
2 Replies
vNEX
Expert
Expert

Hi Robert,

just a thought if you vCenter server was installed via custom method vCO wasn't pre-installed same applies for vCO database schema and its tables...

So if you install vCO separately you must create new separate database or a new schema and also prepare tables then in configuration for Database type select "SQL server" or Oracle, PostgreSQL ...

Have you already create schema and tables for vCO?

_________________________________________________________________________________________ If you found this or any other answer helpful, please consider to award points. (use Correct or Helpful buttons) Regards, P.
Lxypi
Contributor
Contributor

I ran into this issue.  All of my vCenter installs are done individually, component by component, so that I have more control of the paths and certificates.

I resolved this by uninstalling Orchestrator from Control Panel, and then just running the installer again.  It's located on the vCenter ISO, under the path \vCenter-Server\vCO

When you run the Orchestrator installer on its own, it seems to configure itself correctly.

0 Kudos