Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Business Central On pr...
Small and medium business | Business Central, N...
Suggested answer

Business Central On premise installation error

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello Folks,

Thank you to help me on resolving error while installing Dynamics 365 Business Central On Premises. 

screen shot for the error is attached.

Regards,

Ranjith Surendran BC-Install-Err.JPG

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Business Central On premise installation error

    Hello,

    As a workaround, you can run setup.exe again and make sure SQL Server is not part of the setup. Via SQL Server Management Studio that is installed on the SQL Server, restore the backup from product DVD.

    Run Development Client and connect to the database, from there, alter the database and upload the license file. Report back to the forum if you are running the D365BC release without Windows Client / Development Client.

    Thanks.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Business Central On premise installation error

    Hi,

    The following error is there in the log "Windows Installer: Error: Failed to connect to SQL database.  (-2147467259   master)". And as attached the error showing at the completion of installation.

    I have given the administrator permission to my windows login and UAC is disabled. 

    Thanks for your help.

    BCOPIns.JPG

  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 14,178 Super User 2024 Season 2 on at
    RE: Business Central On premise installation error

    Hi Ranhith,

    Check the Event Log for the actual error message. It might be a permission issue for the Service Account.

    The account that is used to run service should be set as Db_owner in the database.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Business Central On premise installation error

    Hi,

    The SQL server is installed itself with the Business Central on prem installation. After that I have given the user permission in SQL server and assigned the database role membership as db_owner too. But still the issue exist, now it showing the error as attached when connecting the web client / NAV client. The services for Business central and SQL are running. And also the business central application server is running.  

    BC-er.JPG

  • ravuri suresh Profile Picture
    ravuri suresh 240 on at
    RE: Business Central On premise installation error

    Hi Ranjith,

    Can you Try to  give user permissions for your user in the SQL Server and install again.

    Thank you,

    Suresh Ravuri

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

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Share Your Event with the Community

Jump start your event engagement! 📢

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,938 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,655 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans