Development Environment on Azure SQL

After my session on NAV TechDays about deployment of NAV 2016 on Azure SQL Server, I got a lot of questions about using Development Environment in this situation.

Using Development Environment can be done absolutely normal. If you want to use DE from your local computer, first you have to add your IP address to Azure SQL firewall (SQL Databases > Servers > choose server > Configure). You can do it to allow connection between your computer and Azure SQL server.

DE01

After that, open Development Environment and type your full Azure SQL server name to Server Name (xxxxx.database.windows.net), choose Database Server Authentication, your username and password and on the end normally choose your database.

DE02

You can work with design, but if you want to open table for example, you have to make some additional configurations. Before it, you have to make connection between your local NAV Windows Client and Azure VM. You need to use certificate and encryption key. After you configure them, everything will be OK.

If you want to use Development Environment directly on Azure VM, you just need to open DE and login to Azure SQL server (I already described), nothing else. In this situation you can work what you want.

DE00

You can see it on previous picture. Database is opened from Azure SQL and you can do everything as you used to.

Advertisements

How to Install NAV 2016 Phone Client as Test Environment

We have new NAV 2016 more than two weeks. One of the really exciting news is using of Universal Apps. We finally can use NAV on phone.

But one of conditions of using of Phone Client is installing of security certificate. This is the same story as we already have in NAV 2015 for using of Tablet Client. If we have signed certificate, there is no problem. But if we have not it…

Can we use self-signed certificate on phone? Yes, we can. I will show how to do it on Windows Phone.

Of course, first we need to download Dynamics NAV Universal App for Windows Phone from Store. Type Dynamics NAV in Store Search and download this app. You can easy find it as app made by Microsoft Corporation with new logo.

Than we have to have installed NAV 2016. In my example, I’ve installed NAV 2016 on Azure. You can do it easy if you have Azure subscription. Or you can do it on your own servers and install self-signed certificate on your server. If you deploy NAV 2016 on Azure using PowerShell scripts, you will have already created certificate. I’ll install this certificate on my own computer in Internet Explorer.

Run your Internet Explorer as Administrator and type your NAV 2016 Web Client URL. Choose “Continue to this website (not recommended).” and click on “Certificate error” > “View Certificates” > “Install Certificate”.

PhoneClient1

Choose Local Machine and “Place all certificates in the following store” > Browse > “Trusted Root Certification Authorities” > OK > Next > Finish > OK > OK.

Open MMC on your computer and add Certificates as snap-in using Add/Remove Snap-in command. Open “Certificates – Current User” > “Trusted Root Certification Authorities” > Certificates and find your already installed certificate. Right-click on certificate and chose Open. Go to Details tab and click “Copy to file” > Next > Next and choose your certificate name. Save this certificate XXXXX.cer on your computer and send it to your e-mail (e-mail using on your phone).

When you get this e-mail on your phone, click on your certificate in attachment and install it. Then run your Dynamics NAV Universal App and type your service URL https://YourComputerName/WebServerInstance and your username and password.

PhoneClient2

If you finished everything I said, you will open your NAV instance on your phone as you can see on picture.