NAV + Azure SQL

(1) Share

Report

Posted on by Community Member

Hi All,

I have some doubts about using Azure SQL with NAV. I have no problem with configuing it for demo purposes but I would like to get your opinions about using this scenario for production one. Did you find a way to create the second account (instead of Azure SQL admin) who can connect the database from Developer environment ? I tried various options with different roles both on nav and master database but always with the same result: list of databases in Developer environement for this user is empty. SQL admin can access without any problem.

In addition have anyone ever made any performance comparison between SQL on IaaS and SQL Azure ?

thanks in advance,

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Andrey Baludin 3,941 on at

Like (0)

Report
Hi!

1. On master database run next script:

create login mytest with password = 'Pass123456' create user mytest from login mytest;

2. On target database run next script:

create user mytest from login mytest; exec sp_addrolemember 'db_owner', 'mytest';

after that you can connect to Azure SQL from Development Environment with user mytest and password Pass123456.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am also interested in the performance comparison. I need to improve performance on a worldwide installation (one database, many companies).

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

For the user creation, Andrey has given the solution.

Regarding performances with NAV, in my experience Azure SQL with standard NAV works good for a small amount of users (<=15). For more than this, Sql Server on an Azure VM performs better, but consider also these tips:

demiliani.com/.../microsoft-dynamics-nav-on-azure-sql-server-on-azure-vm-best-practices

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

Sorry for the delay. Unfortunately, it doesn't work :|

I wanted to paste screenshot here but there is no option to do that.

Was this reply helpful? Yes No