I have an issue regarding this.
I tried to open the database through Nav Development, but after I typed in the credentials it gave me this:
CREATE TABLE permission denied in database 'master'
SQL:
CREATE TABLE [dbo].[$ndo$srvproperty] (license IMAGE NULL)
The service can't start therefor I cannot import a licens as usual through Powershell ISE.
- Thanks
*This post is locked for comments
Assign SysAdmin & dbOwner rights in SQL to the user accessing developer environment & Service Account. Try after restarting the service.
Hi Martin,
You need a sysadmin rights: to work through...
msdn.microsoft.com/.../ms189121.aspx
The Table [dbo].[$ndo$srvproperty] in the master db is mandatory for NAV DB.
You can also create this table manually by the sysadmin of the hosting provider.
After the table is created you need to stored the licence 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.
You should also provide the Windows user with the "sysadmin" right in the database.
If necessary, try restarting the service after that. and Try again.
Hi,
Make sure that the windows login of the user who is trying to access database using developer environment and the account which is used to run navision services should have at least - Dbowner permission in the sql database.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (