Last week we finished one of the best NAV conferences this year. NAV Tech Days this year had about 950 NAV passionate attendees from all around the world. Everything in organization was the amazing; Luc did a great job.
This NAV Tech Days was very special for me, because I was the speaker on this conference for the first time. My topic on NAV Tech Days was “Deploying and Managing Dynamics NAV 2016 with Azure SQL Database”. This is something new in Microsoft Dynamics NAV 2016. I know, a lot of partners still not use NAV on Azure, but by my opinion this feature can move all of us forward. Azure SQL can save a money and we finally have a good tool for managing our multitenant environment – Management Service Portal.
I gave a word to people on my session that I’ll publish my presentation and PowerShell scripts on my blog. You can find them here:
In few following scripts, I’ll describe all details about using NAV 2016 on Azure SQL Server and give you some answers on additional questions I already got.
Totovic Dynamics 365 Blog 
Hello!
Thanks for the scripts and the information!!
I’m trying to connect my NAV 2016 to a multitenant database on azure sql
I converted to multitnant my local database, then I upload it to Azure SQL
And finally I use your script to make the connection, it looks that the connection is correct, but when I try to connect to a tenant I get an error:
“Cannot establish the conncection to the SQL Server/Database. This could be due to one of the following reasons:
*The SQL Server is not started
*The database does not exist
*Proper permissions have not been given to the NAV Server Account.
Try again later or contact your system administrator. ”
But if I connect to the Azure SQL Server since the SQL Management Studio I can see that the database exists.
Could you tell me what I’m doing wrong? or what is wrong?
Could you help me please?
LikeLike
Thank you very much for the information. By any chance do you have the video of your speech.
LikeLike
Yes, I have (it is published on Youtube by Mibuso): https://www.youtube.com/watch?v=uv6aicyk_nI
LikeLike
Awesome!
LikeLike