Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / NAV + Azure SQL
Microsoft Dynamics NAV (Archived)

NAV + Azure SQL

(1) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV + Azure SQL

    Hi,

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

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

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: NAV + Azure SQL

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV + Azure SQL

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

  • Suggested answer
    Andrey Baludin Profile Picture
    Andrey Baludin 3,941 on at
    RE: NAV + Azure SQL

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans