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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Creating a HQ database...
Small and medium business | Business Central, N...
Suggested answer

Creating a HQ database for client w/existing stores

(0) ShareShare
ReportReport
Posted on by cness 69

I'm trying to create a HQ database for a client w/3 stores.  I'm following the directions, but I believe those were meant for the SQL Express that came w/RMS.

Steps I've taken w/bad results:

1) Created a temp db in SQL

2) Connected to temp db in HQ Admin

3) Ran the create db using the sample rmshqdb.bck naming it HQ

4) Imported existing store into HQ db

Very little copied over.  No cashiers.  HQ Manager will start, but I can't log into it.

Any assistance will greatly be appreciated.

I have the same question (0)
  • Suggested answer
    eliud mugo Profile Picture
    eliud mugo 1,444 on at
    RE: Creating a HQ database for client w/existing stores

    Store cashiers wont import to HQ as users as they are part of decentralized data.

    To login to sample HQ DB you need to use the default user credentials..

    Try administrator as user and password as password.

    You can also DM me on eliud,mugo@inventbusinesssolutions.com  for support.

  • cness Profile Picture
    cness 69 on at
    RE: Creating a HQ database for client w/existing stores

    Thanks.  I was trying to use 1/password and totally missed the administrator piece.  :)

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

Responsible AI policies

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

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sumit Singh Profile Picture

Sumit Singh 2,106

#2
YUN ZHU Profile Picture

YUN ZHU 1,752 Super User 2025 Season 2

#3
OussamaSabbouh Profile Picture

OussamaSabbouh 1,670

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans