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

Getting an error while installing BC image locally

(0) Share

Report

Posted on by SamGupta

Hello Everyone,

I am getting an error while installing the BC instance locally. First, I was trying to install using the image that I downloaded from the following location.

https://www.microsoft.com/en-us/download/details.aspx?id=102128

First, I tried to download using the default options, but it didn't work as it failed in connecting with the database. So I followed the advice offered on the following thread and installed without database option.

https://community.dynamics.com/business/f/dynamics-365-business-central-forum/373017/not-able-to-install-demo

After installing successfully, I restored the database using the sample db provided with the DVD. With this approach, I could start the service in the admin without any errors.

But then when I loaded the app, I am getting the following error:

First I got that [dbo].[$ndo$srvproperty] was missing but when I created that as suggested on some of the threads, now I am getting the following:
System table [master].[dbo].[$ndo$srvproperty] is missing or database Demo Database NAV (17-0) is not a Business Central application database.

I have a new login and using SQL server auth on that. I have assigned the DB Creator privilege on that.

Any suggestions on what else may I be missing?

Is 2020 wave 1 version stable enough? Some people suggested that it could be because of this version. Shall I uninstall this one and go back to the previous one?

I have the same question (0)

All responses (8)

Answers (0)

Bilal Haider 414 on at

Like (0)

Report

Hi,

These errors come when you restore DB manually. Best way is to install with the default installer. Try to install BC again and post the errors screen shots that you get while installing.

Otherwise if you still want to proceed with this way then please post screen shots of all errors.

Was this reply helpful? Yes No
Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Check this link

community.dynamics.com/.../web-client-business-central-2020

Was this reply helpful? Yes No
SamGupta 15 on at

Like (0)

Report

[quote user="SamGupta"]
Hello Everyone,

I am getting an error while installing the BC instance locally. First, I was trying to install using the image that I downloaded from the following location.

https://www.microsoft.com/en-us/download/details.aspx?id=102128

First, I tried to download using the default options, but it didn't work as it failed in connecting with the database. So I followed the advice offered on the following thread and installed without database option.

https://community.dynamics.com/business/f/dynamics-365-business-central-forum/373017/not-able-to-install-demo

After installing successfully, I restored the database using the sample db provided with the DVD. With this approach, I could start the service in the admin without any errors.

But then when I loaded the app, I am getting the following error:

First I got that [dbo].[$ndo$srvproperty] was missing but when I created that as suggested on some of the threads, now I am getting the following:
System table [master].[dbo].[$ndo$srvproperty] is missing or database Demo Database NAV (17-0) is not a Business Central application database.

I have a new login and using SQL server auth on that. I have assigned the DB Creator privilege on that.

Any suggestions on what else may I be missing?

Is 2020 wave 1 version stable enough? Some people suggested that it could be because of this version. Shall I uninstall this one and go back to the previous one?
[/quote]

Yes, I agree that it is because of that manual restoring the database from the DVD. But the problem that we are running into is that we have another installation of the SQL server, which has many other databases inside that. Also, they require different versions of SQL servers. So, to avoid this, restoring seemed like a safer option, as all products could reside in the same database. Do you see any issues with multiple SQL server agents running and hosting their own instances? I can try that but I want to see if anyone might have any other suggestions with the manual restore option before we go back to reinstalling again. Also, our assumption is that the dev version does not require any additional license, etc. Could you please confirm that?

Was this reply helpful? Yes No
SamGupta 15 on at

Like (0)

Report

Hi Suresh,

This is the link I had included with my question. But it didn't help. I can't follow the license step in the PowerShell in the final comment on that thread. My assumption is that since this is a locally hosted dev environment, we don't require additional licenses. Could you please confirm?

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 414 on at

Like (0)

Report

Hi, The link provided should help you. Load CRONUS license provided with the DVD.

Regarding additional license if you have developer license you can use it for both development and all operations. Otherwise if you are building this environment just for demo purpose then you can use CRONUS license.

As you are writing about SQL server I do not fully understand it but sharing may be helpful for you that at the time of installing BC you have the option to do the installation with a new SQL Server Instance or you can use previously installed SQL Server Instance for the creation of DB.

See image

Was this reply helpful? Yes No
SamGupta 15 on at

Like (0)

Report

Hi Bilal,

This is very helpful. I will try and confirm if this works.

I do have a follow-up question though re: lic. The environment is really for demo and development. Not even sure if a locally hosted dev environment is required, or we can hook up VS Code directly with our Sandbox and develop from there without stepping on anyone's toes as we do have a large team. So if we install the DVD as is like you suggested above, am I still required to install the license? By the way, I can't find the license file in the DVD folder. Any hints or links on where I might find?

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 414 on at

Like (0)

Report

Note: With On Premises BC environment you cannot do development without a developer license. Cronus license can only be used for demo.

If your sandbox is an online business central then all you need is VS code and connect it with your online sandbox.

For Cronus License follow this path inside your DVD folder: Dynamics.365.BC.47292.DK.DVD\ServiceTier\program files\Microsoft Dynamics NAV\140\Service

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

I would recommend you to use docker for local development and git for managing multiple developers.

Was this reply helpful? Yes No