Fail to select a MSSQL server instead of SQlite during setup
Hi folks.
I'm wondering why I can't select a MSSQL Instance (MSSQL Server 2016) in the advanced setting of the setup. I enter the name of the server and the instance, clic on Browse and a few seconds after, a popup says it can't find the instance. In the same time, I launch SQL Management on the same machine and I can connect to the instance.
Why the hell the setup cannot find the instance ?
Thanks !
Tom


- Accedi per poter commentare

Hi Peter, thanx for your answer.
I am used to manage MS SQL servers using best practices (separate partitions for the app, the data and the logs, security group to manage SQL Admins, etc.), I did create a specific user in the AD for AMS SQL administration, it is allowed on the SQL server using Windows Authentication.
Also, I did lock the instance on a static port, not dynamic.
And as I said, when I am on the AMS machine, I can use SQL Managment studio to connect the instance.
So I see no reason to explain that the setup cannot find the instance.
- Accedi per poter commentare

Hello Tom,
welcome to Acronis forums!
Could you please collect and share with us Acronis System Information collected from the server which can't find the instance? I have sent you a Private Message with an FTP link where you can upload the logs.
- Accedi per poter commentare


Hello Tom.
You have collected Acronis System Information from Acronis Virtual Appliance when the problem is at a setup stage (on a physical server) where you are trying to select the instance.
Also, I did lock the instance on a static port, not dynamic.
Please look at this KB article: https://kb.acronis.com/content/63363
Since you are trialing the product, I strongly recommend that you open a case with Acronis Support Team and request a remote session: our support engineers could help you to set up the SQL instance or collect system report from the right server.
- Accedi per poter commentare

Hello Maria
I saw this kb and tried to specify the port, but it didn't work
I am actualy in contact with the support for this and for 2 other major issues.
We'll see...
Thank you, anyway :)
- Accedi per poter commentare

Hello Tom.
You are welcome to share and discuss here any recommendations and solutions that you'll be given.
- Accedi per poter commentare

Hello Tom,
did you get a solution for the problem with the SQL Server connection?
Andreas
- Accedi per poter commentare

Hello Andreas,
welcome to Acronis forums!
Please follow the steps of the Management server installation part of this article and ensure that all requirements are met:
https://www.acronis.com/en-us/support/documentation/AcronisBackup_12.5/index.html#40078.html
- Accedi per poter commentare

Hi Maria,
the requirements are met. I just want to Udate an existing system (which works fine) from Build 11010 to Build 14330.
Perhaps i have to update to an Bulid between 11010 and 14330 in a first step? And after that the update to 14330?
The SQL-Server and the Acronis Management Server are on the same machine. With the Management Studio i have no problem to login into the SQL-Server.
Andreas
- Accedi per poter commentare

Hello Andreas.
There should not be any issue updating to the current build from 11010. The SQL instance should also be directly updated. What is the exact error message you receive? Could you please share an installation log here?
- Accedi per poter commentare

Hello Maria,
Error Message that ist not possible to get an TCP/IP Connection to the database.
I get this message with both users (Managament Server Service Accout and also with the SQL Authentication)
- Accedi per poter commentare

- Accedi per poter commentare

Hello Andreas.
There is a strange thing in the log you've shared: the build you are updating to is 14240 but not the 14330 one that is officially released.
I recommend that you check that all Acronis Backup 12.5 components are of the same build 14330.
- Accedi per poter commentare

Hello Maria,
sorry, my mistake. I choose the wrong installation file. I will try the other one an d will come back with the installation log.
- Accedi per poter commentare

- Accedi per poter commentare

Hello Andreas.
I would recommend that you open a case with Acronis Support Team and request a remote session. Please ask support engineers to check the following:
Error 0x627562: The service update is not possible because the password for the account under which this service runs is not specified.
- account user login and privileges (AMS user by default) for ManagementServer.exe should be checked there.
Error 0x62755c: Failed to connect to 'FRISR042\SQLEXPRESS' via TCP/IP. Enable TCP/IP for Microsoft SQL Server or continue with the SQLite database.
- whether your SQL server is configured to be available through TCP/IP.
- Accedi per poter commentare