NAV 2013 R2 install, no rights to Master DB

MaW
MaW
edited 2014-03-18 in NAV Three Tier
Hi,

The question is simple, is it possible to install or run NAV 2013 R2 without access to MASTER DB?

The setup story is as follows:
We're trying to install a NAV 2013 R2 in a hosted environment. The hosting company will not allow access to MASTER database. Because the SQL server is shared.
We triedrestore a NAV db with licence data imported into it. But we cannot start neither client or DEV env up.
Here's the error when trying to start DEV environment:
Microsoft Dynamics NAV Development Environment
The following SQL Server error or errors occurred:
262,"42000",[Microsoft][SQL Server Native Client 10.0][SQL Server]CREATE TABLE permission denied in database 'master'.
SQL:
CREATE TABLE [dbo].[$ndo$srvproperty] (license IMAGE NULL)

Thx

Comments

  • ara3n
    ara3n
    there is a property in file->database->Alter. called store license in the database. Checkmark that field and it will ask you for the license and then the Access to master db is not required.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • brunelli
    brunelli
    I fear that the answer to your question is no.

    Based on MS Help, you need sysadmin rights:
    http://msdn.microsoft.com/en-us/library ... 7(v=nav.70).aspx

    The table [dbo].[$ndo$srvproperty] in the master db is mandatory for NAV 2013 R2.

    As a workaround, the table could be created manually by the sysadmin of the hosting provider. In a second step, a licence needs to be stored in this table. If the table does not contain one record with a licence you will get an new error message stating that the licence is missing, even a separate licence is stored in the NAV DB. See here how this could be managed:
    http://navnewb.blogspot.ch/2012/08/how- ... s-nav.html

    Still then, select permission on this table for the user working with the dev environment and the NST is needed:
    http://msdn.microsoft.com/en-us/library ... 0(v=nav.71).aspx
  • MaW
    MaW
    Thank you for your comments.
    We will try to see, it your solution brunelli is suitable for the hoster. Will post an update later...
  • MaW
    MaW
    Hi,

    The hosting company decided not to try the scenarios discussed here. Instead they have offered a dedicated SQL server to the customer.

Categories