Skip to main content

Fail to select a MSSQL server instead of SQlite during setup

Thread needs solution

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

0 Users found this helpful

Hi Tom!

Is the SQL server configured to be available through TCP/IP? By default installation only shared memory is enabled for connecting to your instance. Keep in mind this also have to be done if you happen to have the SQL server on the same machine as the AMS.

You can configure this in SQL server configuration manager > Network protocols > enable TCP/IP then restart the service of the specific SQL instance you want to connect to acronis.

Another tip: If you want to use windows authentication for SQL server make a user for the AMS and add that user as an sql server admin. If you don't the newly created default acronis AMS user will have no rights to create the DB and the installation fails, but you can't add the user until the installation is done. Maybe this loop can be broken somehow, but it's worth it to make a dedicated acronis user anyway.

-- Peter

 

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.

frestogaslorastaswastavewroviwroclolacorashibushurutraciwrubrishabenichikucrijorejenufrilomuwrigaslowrikejawrachosleratiswurelaseriprouobrunoviswosuthitribrepakotritopislivadrauibretisetewrapenuwrapi
Posts: 0
Comments: 2016

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.

 

frestogaslorastaswastavewroviwroclolacorashibushurutraciwrubrishabenichikucrijorejenufrilomuwrigaslowrikejawrachosleratiswurelaseriprouobrunoviswosuthitribrepakotritopislivadrauibretisetewrapenuwrapi
Posts: 0
Comments: 2016

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.

 

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 :)

frestogaslorastaswastavewroviwroclolacorashibushurutraciwrubrishabenichikucrijorejenufrilomuwrigaslowrikejawrachosleratiswurelaseriprouobrunoviswosuthitribrepakotritopislivadrauibretisetewrapenuwrapi
Posts: 0
Comments: 2016

Hello Tom.

You are welcome to share and discuss here any recommendations and solutions that you'll be given.

frestogaslorastaswastavewroviwroclolacorashibushurutraciwrubrishabenichikucrijorejenufrilomuwrigaslowrikejawrachosleratiswurelaseriprouobrunoviswosuthitribrepakotritopislivadrauibretisetewrapenuwrapi
Posts: 0
Comments: 2016

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

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

 

 

 

 

frestogaslorastaswastavewroviwroclolacorashibushurutraciwrubrishabenichikucrijorejenufrilomuwrigaslowrikejawrachosleratiswurelaseriprouobrunoviswosuthitribrepakotritopislivadrauibretisetewrapenuwrapi
Posts: 0
Comments: 2016

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?

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)

 

frestogaslorastaswastavewroviwroclolacorashibushurutraciwrubrishabenichikucrijorejenufrilomuwrigaslowrikejawrachosleratiswurelaseriprouobrunoviswosuthitribrepakotritopislivadrauibretisetewrapenuwrapi
Posts: 0
Comments: 2016

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.

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.

frestogaslorastaswastavewroviwroclolacorashibushurutraciwrubrishabenichikucrijorejenufrilomuwrigaslowrikejawrachosleratiswurelaseriprouobrunoviswosuthitribrepakotritopislivadrauibretisetewrapenuwrapi
Posts: 0
Comments: 2016

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.