We have been busy installing new customers to Azure, and I'd like to write a short blog jut to remember what one has to do before publishing.
Good instructions how to publish database to Azure SQL you can find from this link:
However, msdn articles sometimes miss information, and here is the things you have to remember to make it work easier.
That's about it! I will add information to this blog as I encounter it.
Using the import/export keys is really cumbersome, and I have stopped using them until they become somewhat usable level.
Now I just create own SQL user account to every NAV service that connects to Azure SQL, and the problems with the keyfiles and SQL matching keys are over.
For example if you have a NAV service called NAV2017WS, just create a SQL user for example as SRV_NAV2017WS, and give it appropiate user rights to correct database.
This is way easier than keep up with the keyfiles.