VMware vCenter Site Recovery Manager application error. DBManager error: Could not initialize Vdb connection: ODBC error: (08001) - Could not connect to the server

[JoodJ]

2016-08-24T09:41:42.169+02:00 Section for VMware vCenter Site Recovery Manager, pid=18608, version=6.1.0, build=3037005, option=Release

2016-08-24T09:41:42.170+02:00 [12452 info 'Default'] SessionLogger: Switching to 'App' session logging

2016-08-24T09:41:42.170+02:00 [12452 warning 'Default'] Failed to create console writer: The data area passed to a system call is too small.

2016-08-24T09:41:42.173+02:00 [12452 info 'Default'] Initializing the DBManager

2016-08-24T09:41:44.190+02:00 [12452 error 'Vdb'] Connection: Could not connect to database: -1

2016-08-24T09:41:44.190+02:00 [12452 error 'Default'] DBManager error: Could not initialize Vdb connection: ODBC error: (08001) - Could not connect to the server;

--> No connection could be made because the target machine actively refused it.

-->  [127.0.0.1:5678]

2016-08-24T09:41:44.191+02:00 [12452 error 'WindowsService'] Application error:

--> std::exception 'class Vmacore::Exception' "DBManager error: Could not initialize Vdb connection: ODBC error: (08001) - Could not connect to the server;

--> No connection could be made because the target machine actively refused it.

-->  [127.0.0.1:5678]"

-->

--> [backtrace begin] product: VMware vCenter Site Recovery Manager, version: 6.1.0, build: build-3037005, tag: -

--> backtrace[00] vmacore.dll[0x001BD30A]

--> backtrace[01] vmacore.dll[0x0005CA8F]

--> backtrace[02] vmacore.dll[0x0005DB9E]

--> backtrace[03] vmacore.dll[0x00012E6B]

--> backtrace[04] vmware-dr.exe[0x0015C59A]

--> backtrace[05] MSVCR90.dll[0x00074830]

--> backtrace[06] MSVCR90.dll[0x00043B3C]

--> backtrace[07] ntdll.dll[0x00092A63]

--> backtrace[08] vmware-dr.exe[0x000060AF]

--> backtrace[09] vmware-dr.exe[0x00006A5E]

--> backtrace[10] windowsService.dll[0x00002BCE]

--> backtrace[11] windowsService.dll[0x000020DD]

--> backtrace[12] sechost.dll[0x00005ADA]

--> backtrace[13] KERNEL32.DLL[0x000013D2]

--> backtrace[14] ntdll.dll[0x000154E4]

--> [backtrace end]

-->

2016-08-24T09:41:44.205+02:00 [12452 error 'WindowsService'] [serviceWin32,748] VMware vCenter Site Recovery Manager application error. DBManager error: Could not initialize Vdb connection: ODBC error: (08001) - Could not connect to the server;

--> No connection could be made because the target machine actively refused it.

-->  [127.0.0.1:5678]

2016-08-24T09:41:44.206+02:00 [12452 info 'WindowsService'] Service is stopping. Current state: 2

2016-08-24T09:41:44.206+02:00 [19160 info 'Default'] VMware vCenter Site Recovery Manager shutdown requested.

2016-08-24T09:41:44.207+02:00 [12452 info 'WindowsService'] Application stopped and exiting.

2016-08-24T09:41:44.207+02:00 [12452 info 'ThreadPool'] Thread delisted

[DavoudTeimouri]

Check the firewall settings and your database TCP configurations on your DB server by run this:

• On a 32 bit machine, click Start > Programs > Administrative Tools > Data Sources (ODBC).
• On a 64 bit machine, browse to %systemroot%\sysWOW64\ and click odbcad32.exe.

[hussainbte]

DSN error 08001 represents Network connection failure.

you can telnet the DB server on port 1433 to verify network connectivity

https://support.microsoft.com/en-us/kb/195566

[JoodJ]

I have tried the OBDC and I get the error below:

[hussainbte]

It seems that the SRM is trying to connect to DB on port 5678.

The default SQL port is 1433 unless you have changed.

One way to update the DSN is using registry.

Check the below link

Changing the vCenter Server database user ID and password (1006482) | VMware KB