NAV Three tier installation (Create TABLE on master database error)

Business Central/NAV Technical Forum
1

HI.

I am doing a three tier installation of NAV 2018.

  • SQL server i Installed SQL database components (without demo database) and I restored my database backup.

  • NAV server I installed NAV server.

  • On client computer i installed NAV client.

vWhen I try to open database FROM NAV server i get error

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

Domain user wich I am using to open database is sysadmin on SQL server and db_owner on both NAV and master database. I also gave those permissions on service account. Error still persist. Then I tried to manually create this table, and upload lic file in it error stil persist. Next step was to give permission on this table for both accounts. Error stil here. Is there anxthing else I can try?

What ever I do, error is aleays the same. [emoticon:ca08b2c27c2f40e993e89508acf29e0b]

2

Hello,

Can you make sure the user you are creating the database with has all the permissions in SQL? Just to make sure, can you try it with sysadmin role?

Also, can you make sure you’re restoring the database in a compatible version of NAV 2018? https://docs.microsoft.com/en-us/dynamics-nav/system-requirements-for-microsoft-dynamics-nav

Best regards,