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.
