> For the complete documentation index, see [llms.txt](https://docs.rmhpos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.rmhpos.com/installation/install-central-manager-multi-store/installation-cm-connect-to-central-db.md).

# Connect to SQL Server and the Central database and force install tables

{% hint style="success" %}
You can run Force Install Tables as an executable in **Command Prompt** or **PowerShell**. This allows you to update or repair the Central database without opening Central Administrator or Central Manager. Refer to [**Run Force Install Tables as an executable**](/installation/other-procedures/force-install-tables-executable.md) for more information.
{% endhint %}

1. Open **Central Administrator**. The shortcut should be available on your desktop.
2. Click **Connect**.

<div align="left"><img src="/files/tkQjoCB1OjxmI3OXPz9G" alt=""></div>

3. In the **Server** field, select the host name of the computer where you installed SQL server and the name of the SQL Server instance.

<div align="left"><img src="/files/qrKsKOxSr859x0vh83hn" alt=""></div>

4. Under **Connection information**, select **Use SQL Server Authentication**.
5. Enter the **User name** and **Password** for the system account.
6. From **Database**, select the Central database.
7. Click **Connect**. You will notice that the functions in the Database menu are now accessible.

<div align="left"><img src="/files/HF2E9iVaaPTnchOYOEiH" alt=""></div>

8. In the **Database** menu, click **Force Install Tables**.

{% hint style="info" %}
Starting with release 3.11.14, the Force Install Tables function no longer creates the SYNCGUID column in the RMH or third-party app tables. The Prepare Database function will create the SYNCGUID column in the RMH table, but it will no longer create it in third party app tables.
{% endhint %}

9. Click **Yes** to continue.

<div align="left"><img src="/files/A8y39jvPgIbN4ay4smtO" alt=""></div>

10. Wait while **Central Administrator** executes the SQL scripts to create RMH custom tables in the Central database. This may take a few minutes.
11. Click **OK** to close the confirmation dialog.

<div align="left"><img src="/files/jAKAVJnZ6DzZtjHBuJzU" alt=""></div>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.rmhpos.com/installation/install-central-manager-multi-store/installation-cm-connect-to-central-db.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.