Small and medium business | Business Central, N...

Cannot start NAVServerInstance with new NAVApplicationDatabase

(0) Share

Report

Posted on by TirusGichu

I have created a new NAV database using New-NAVApplicationDatabase cmdlet and it was successful. I have then create a new NAVServerInstance using New-NAVServerInstance cmdlet and linked it to the database I created earlier. However when I try to start the server it fails to reach status 'Running'. I am guesing it could be a permission issue but I have not clue where to start looking.

Kindly help

All responses (6)

Answers (0)

Sort by

Suggested answer

Tech-Lucky 1,288 Moderator on at

Like (0)

Report
Copy link

Link copied!

Go to the SQL Server Management Studio Connect with the Database Server Instance and Goto the Security>> Logins >> NT AUTHORITY\NETWORK SERVICE Right Click on this and select Properties >>User Mapping >>Select the New Data Base as shown in the image :
TirusGichu 40 on at

Like (0)

Report
Copy link

Link copied!

Hi Tech Lucky, I have done that but I still get the same issue
Suggested answer

Tech-Lucky 1,288 Moderator on at

Like (0)

Report
Copy link

Link copied!

did you try to give the User as DB Creator and admin permissions as well from the Security>>users option in the Database? like below :

if this also does not help you then you must view the event logs it will show you the exact issue.

Please mark my answer Varified if it helps you
TirusGichu 40 on at

Like (0)

Report
Copy link

Link copied!

Still the same error. Below is my event log
Suggested answer

Tech-Lucky 1,288 Moderator on at

Like (0)

Report
Copy link

Link copied!

as per the event log, now you need to check whether the NAV Server Account is added in the Database Login with the above admin permissions.

and please verify that in the Instance you have passed the correct SQL Instance Name and Database Name, these are the only things related to the permission error, and try restarting your SQL Server instance.
Suggested answer

Saurav.Dhyani 14,481 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hope this helps.