Recreate Connection Strings
Symptoms
You've updated Acronis Management Server.
After update Acronis Management Server service starts and stops after a while.
Connection to AMS is not possible.
Go to %allusersprofile%\Acronis\AMS\Logs and check a few latest logs for the following errors:
Module: 185
Code: 15
Module: management_server_vs_38774
Line_tag: 0x27FBB047D6CE055B
Message: Failed to initialize component 'CentralizedMachineManager'
Module: 127
Code: 16
Module: management_server_vs_38774
Line_tag: 0xC131F5921FF773F4
Message: Can not open ADO connection 30 times
Module: 127
Code: 0
Module: management_server_vs_38774
Line_tag: 0xC131F5921FF773F0
Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Cause
Acronis Management Server cannot connect to its SQL instance. AMS uses Connection Strings stored in the Registry. Connection Strings might got invalidated during update.
Solution
Acronis Management Server uses default SQL instance (default options selected during installation)
Open Notepad.
Insert this content:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Acronis\AMS\ConnectionStrings]
"acronis_cms_stats"="Provider=sqloledb;Data Source=(local)\\ACRONIS;Initial Catalog=acronis_cms_stats;Integrated Security=SSPI;"
"acronis_reports"="Provider=sqloledb;Data Source=(local)\\ACRONIS;Initial Catalog=acronis_reports;Integrated Security=SSPI;"
"acronis_dml_objects"="Provider=sqloledb;Data Source=(local)\\ACRONIS;Initial Catalog=acronis_dml_objects;Integrated Security=SSPI;"
"acronis_cms_cards"="Provider=sqloledb;Data Source=(local)\\ACRONIS;Initial Catalog=acronis_cms_cards;Integrated Security=SSPI;"
"acronis_cms"="Provider=sqloledb;Data Source=(local)\\ACRONIS;Initial Catalog=acronis_cms;Integrated Security=SSPI;"
"acronis_cms_logs"="Provider=sqloledb;Data Source=(local)\\ACRONIS;Initial Catalog=acronis_cms_logs;Integrated Security=SSPI;"
"acronis_cms_archives"="Provider=sqloledb;Data Source=(local)\\ACRONIS;Initial Catalog=acronis_cms_archives;Integrated Security=SSPI;"
Save the file as strings.reg
Execute it with adminitrator privileges: right-click on the file and select Run as administrator .
Open the Windows Registry (Start -> Run -> regedit.exe).
Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Acronis\AMS\ConnectionStrings
Check whether strings above are present.
If they are not, create them manually.
Acronis Management Server uses custom SQL server (specified manually during installation or later):
The SQL server is on another machine and uses Windows Authentification:
Open Notepad.
Insert this content:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Acronis\AMS\ConnectionStrings]
"acronis_cms_stats"="Provider=sqloledb;Data Source=(local)\\MACHINENAME;Initial Catalog=acronis_cms_stats;Integrated Security=SSPI;"
"acronis_reports"="Provider=sqloledb;Data Source=(local)\\MACHINENAME;Initial Catalog=acronis_reports;Integrated Security=SSPI;"
"acronis_dml_objects"="Provider=sqloledb;Data Source=(local)\\MACHINENAME;Initial Catalog=acronis_dml_objects;Integrated Security=SSPI;"
"acronis_cms_cards"="Provider=sqloledb;Data Source=(local)\\MACHINENAME;Initial Catalog=acronis_cms_cards;Integrated Security=SSPI;"
"acronis_cms"="Provider=sqloledb;Data Source=(local)\\MACHINENAME;Initial Catalog=acronis_cms;Integrated Security=SSPI;"
"acronis_cms_logs"="Provider=sqloledb;Data Source=(local)\\MACHINENAME;Initial Catalog=acronis_cms_logs;Integrated Security=SSPI;"
"acronis_cms_archives"="Provider=sqloledb;Data Source=(local)\\MACHINENAME;Initial Catalog=acronis_cms_archives;Integrated Security=SSPI;"
where MACHINENAME is the name of the machine, where the SQL server resides.
Save the file as strings.reg
Execute it with adminitrator privileges: right-click on the file and select Run as administrator .
Open the Windows Registry (Start -> Run -> regedit.exe).
Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Acronis\AMS\ConnectionStrings
Check whether strings above are present.
If they are not, create them manually.
The SQL server is no another machine is uses SQL Server Authentification:
Open Notepad.
Insert this content:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Acronis\AMS\ConnectionStrings]
"acronis_cms_stats"="Provider=sqloledb;Data Source=MACHINENAME\INSTANCENAME;Initial Catalog=acronis_cms_stats;User Id=USERNAME;Password= PASSWORD;"
"acronis_reports"="Provider=sqloledb;Data Source=MACHINENAME\INSTANCENAME;Initial Catalog=acronis_reports;User Id=USERNAME;Password= PASSWORD;"
"acronis_dml_objects"="Provider=sqloledb;Data Source=MACHINENAME\INSTANCENAME;Initial Catalog=acronis_dml_objects;User Id=USERNAME;Password= PASSWORD;"
"acronis_cms_cards"="Provider=sqloledb;Data Source=MACHINENAME\INSTANCENAME;Initial Catalog=acronis_cms_cards;User Id=USERNAME;Password= PASSWORD;"
"acronis_cms"="Provider=sqloledb;Data Source=MACHINENAME\INSTANCENAME;Initial Catalog=acronis_cms;User Id=USERNAME;Password= PASSWORD;"
"acronis_cms_logs"="Provider=sqloledb;Data Source=MACHINENAME\INSTANCENAME;Initial Catalog=acronis_cms_logs;User Id=USERNAME;Password= PASSWORD;"
"acronis_cms_archives"="Provider=sqloledb;Data Source=MACHINENAME\INSTANCENAME;Initial Catalog=acronis_cms_archives;User Id=USERNAME;Password= PASSWORD"
where MACHINENAME is the name of the machine, where the SQL server resides, INSTANCENAME is the name of the SQL server AMS uses. Provide username and password to connect to the instance.
Save the file as strings.reg
Execute it with adminitrator privileges: right-click on the file and select Run as administrator .
Open the Windows Registry (Start -> Run -> regedit.exe).
Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Acronis\AMS\ConnectionStrings
Check whether the strings above are present.
If they are not, create them manually.
More information
Please contact Acronis Support if you need assistance.