Microsoft SQL Server 2019

[Nina_Makkonen]

As Sinch has successfully tested Microsoft SQL Server 2019 with Sinch Contact Pro release FP18, SQL Server 2019 is now supported. Documentation will be updated accordingly later.

[thomashoegl]

Hi,

great news. Thanks.

One of our customers is planning to have the SQL installation in a Azure SQL Database Managed Instance, and a seperate SQL installation for Reporting Server in a VM.

As far as we saw it seems to have all that Sinch Contact Pro needs, because Reporting Server would be on a separate SQL instance at all.

Does anyone have experience with installation of Sinch Contact Pro in Azure SQL Managed Instance?

Or is it supported at all?

Thanks.

BR Thomas

[Jukka]

Hi Thomas, 
Sinch has no experience of Azure, we are running our cloud in AWS and no experience of managed SQL instances yet. We are planning to investigate AWS managed SQL instance, but likely that won't help here. 

If I remember right one partner did a Azure setup several years ago, but no idea what is the status nowadays. 

BR,
Jukka

[thomashoegl]

Hi Jukka,

thanks for your answer.

We have a good feeling about this installation and I think we give it a try, but we are afraid of an answer from Sinch Support like "sorry, we can't help because Azure SQL Managed Instance is not supported" when we create a ticket which is about something different than a database problem. 😄 If it's an issue with DB installation itself, then I fully understand that we don't get any or much support.

BR, Thomas

[Jukka]

Happy to help. I also think that it should be fine, but never know without testing. So, let me know the results. I cannot promise full support, but of course we try to help as much as we can and avoid answering that "combination is not supported". And typically with databases it's about either about installation problems or performance. If it's installation, then it already indicates that this won't work and with performance there is typically easy ways to improve. 

BR,
Jukka

[thomashoegl]

Hi Jukka,

that's really reassuring to hear.

Sure...we will give feedback if it worked.

Thanks.

BR, Thomas

[glennabel]

Hi Thomas,

We have had a configuration of Contact Pro on Azure for many years now. It is currently on 2019 OS / 2019 SQL with FP18. We did originally use SQL managed for the main databases but switched to our own installation on Azure with the bring your own license because it was cheaper and we wanted more control of it. I've found that even when the SQL installation scripts have a failure, you can look at the script code and figure out why it happened and correct it or make a workaround. 

Sincerely,

Glenn

[JohnUK]

Great news, does this also include SQL 2019 Always-On version?

[thomashoegl]

Hi Glenn,

thanks for your answer.

We now installed Sinch Contact Pro on an Azure SQL Managed Instance with SQL authentication. There were a lot of changes to do in installation script in regards to SQL authentication, but for Azure SQL Managed Instance we had to comment only the line with Simple recovery model at Monitoring Database.

Our first tests didn't show any problem, but during our advanced tests we realized that we are not able to save some settings in System Configurator. We always get a MSDTC error message in Agent Server logfiles and therefore saving was aborted.

How did you handle these errors?

Thanks.

BR, Thomas