web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / BC18 on-premise instal...
Small and medium business | Business Central, N...
Answered

BC18 on-premise installation from scratch: how do you load a basic configuration?

(1) ShareShare
ReportReport
Posted on by SetiroN 5

Hello!

I've performed an on-premise installation of BC18 without the demo database because I wanted to start from scratch, but the webpage isn't loading because there are no profiles, it just endlessly loads. I can se the reason is the missing profile from event viewer.

I now understand that creating the company does create the tables, but doesn't populate them, so they're all empty.

Now... what am I supposed to do? Am I supposed to install the demo database and copy the configuration from there somehow?

Thank you in advance

I have the same question (0)
  • Bilal Haider Profile Picture
    Bilal Haider 414 on at

    Hi,

    There are two things. One is database data and other is database objects. Do you want to copy data or you are missing with all database objects?

  • SetiroN Profile Picture
    SetiroN 5 on at

    Hi Bilal,

    I'm talking about the table contents, which I guess you might call database data.

    I've created the company, which in turn has created all the company tables (which I believe you might call objects), but they are all empty. As a consequence, there are no user profiles and the webpage doesn't load anything, while in the event viewer I see errors referencing no profile data present.

  • SetiroN Profile Picture
    SetiroN 5 on at

    For example, there are no permission sets, so I can't assign permission sets to users with New-NAVServerUserPermissionSet

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 414 on at

    Means you are missing even basic system table objects and you do not have any objects on your database. Can you open SQL Server and expand the business central database and show which tables you have there.

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 414 on at

    By the way why you are complicating it for you? Simply install demo database and if you want to implement from scratch, then delete both CRONUS companies and create a new empty company.

  • SetiroN Profile Picture
    SetiroN 5 on at

    i.imgur.com/khJurLP.png

    i.imgur.com/w2AfoWZ.png

    As to why I didn't install the demo database, from the deployment guide it wasn't specified that it was necessary and it required a specific instance name, I didn't realise it was recommended to do so.

    Can the demo database still be installed afterwards, on a differently named sql instance?

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 414 on at

    Yes, the demo database can be installed on a new SQL Server Instance or even on the same SQL Server Instance. Just give the details in installation parameters before start installation. If the SQL Server Instance exists DB will be created otherwise system will install it and then create DB on it. See image below:

    paara.PNG

  • SetiroN Profile Picture
    SetiroN 5 on at

    I'm trying to reinstall everything but I'm receiving a Source file not found error during setup of BC 2021 wave 2.

    \SQLDemoDatabase\CommonAppData\Microsoft\Microsoft Dynamics NAV\180\Database\Demo Database NAV (18-0).bak

    The file is there though.

    Is there any way to restore the tables manually?

    EDIT: using the repair function it worked instead. Odd. I'll finish the setup and get back to you, thanks again for taking an interest.

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 414 on at

    Put the DVD installation folder on root of a drive because sometimes the length becomes large and system not able to find the files that inside.

  • SetiroN Profile Picture
    SetiroN 5 on at

    For whatever reason the .bak was deleted but I recovered it from the original download.

    I ended up doing what you suggested, reinstalling with the demo database.

    Thanks for your help, although if you do have information on how to manually initialise everything (with rapid start or loading xml configurations), I'd like to learn how.

    Cheers.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,573

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 773 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 760 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans