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
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 :
Hi Tech Lucky, I have done that but I still get the same issue
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
Still the same error. Below is my event log
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.
Hope this helps.
Share
Report
All responses (
Answers (