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
Hope this helps.
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.
Still the same error. Below is my event log
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
Hi Tech Lucky, I have done that but I still get the same issue
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 :
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156