SymptomsWhen I use Parallels Management Console (PMC) to view logs at the container, I get the following error at Local server, Logs, Events and alerts:
Pager error: database error "[Microsoft][ODBC Driver Manager] Connection not open"
CauseThe port 1433 which is required to be opened to retrieve statistics from MSSQL database is closed inside Service Container.
ResolutionCheck if the port 1433 is opened inside Service Container:
vzctl exec 1 netsh firewall show portopening
If the 1433 port does not appear in the list, it is necessary to open it with the help of the following command:
vzctl exec 1 netsh firewall set portopening protocol=TCP port=1433 name="for PMC, to retrive statistics from MSSQL database"
Refer to the following article to find the full list of ports that are required to be opened on Parallels Virtuozzo COntainers hardware node and Service Container: