NAV 2013 R2 install, no rights to Master DB

MaW

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

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.

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

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

Hi,

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