BeyondERP.Newsletter
Menu

Setup step on the Database information page · System administration

Check the database connection

Use the page to confirm which database and server the environment uses.

Used by
Information technology manager
Business process
Administer system features
Menu item
SysSqlStatus
Main table
SqlParameters
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isAn inquiry page that shows details of the database connection, grouped into General, System variables and ODBC sections.
What you do hereUse this page to see the database and server the application is logged on to and the name of the log file.
ExampleFor example, after a database refresh the BEAT administrator opens the page to confirm the application is logged on to the refreshed database before releasing the environment to testers.
Database information page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processAdminister system features
Menu pathSystem administration › Inquiries › Database › Database information
Used next byBatch jobs Microsoft Learn
Related pagesSQL index fragmentation details Microsoft Learn
In this process Export field descriptions for training · Read and clean up the database log
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Check the database connection

Use the page to confirm which database and server the environment uses.

How to use it

  1. Go to System administration > Inquiries > Database > Database information.
  2. In the General section, read the Logon database, Logon server and Log file name.
  3. Expand the System variables section to read its details.
  4. Expand the ODBC section to read its details.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it means
Logon databaseThe database the application is connected to.Checked in Dynamics 365
Logon serverThe database server.Checked in Dynamics 365
Log file nameThe name of the database log file.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
The page shows a different database name than expectedYou may be in another environment; check the environment URL before acting. Checked in Dynamics 365

Test checklist

  1. Open the page after an environment copy.
  2. Check Logon database and Logon server match the environment you expect.

Source: Checked in Dynamics 365

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Check the database connectionCheck Logon database and Logon server after every environment copy, before testers sign inIt confirms the copy landed in the environment you think it did.Who confirms an environment copy?Reading SqlParameters values as settings you can change; the page is read only.Test: The copy is connected

Feature management and licence

Licence or add-inOn this system the page opens for Information technology manager. No Feature management feature needs to be turned on for this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyShared: one database serves the whole environment. Checked in Dynamics 365
Can it be undoneReversible: Read only.
If you change it laterThe page only reads connection details; nothing on it changes the database. Checked in Dynamics 365
Technical architect

6Technical

Menu itemSysSqlStatus Checked in Dynamics 365
FormSysSqlStatus Checked in Dynamics 365
TableSqlParametersShown as “Database parameters” in Record infoChecked in Dynamics 365
Who can open itPrivilegesView database information SysSqlStatusViewDutiesMaintain system settings SysServerSettingsMaintain
1 security roleInformation technology manager SysServerITManager
Checked in Dynamics 365
Roles to set it up and use itTo use itInformation technology manager SysServerITManagerGive people one of these roles. On this system, 1 role can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=SysSqlStatus
Data migrationLoad order: Database information has no data entity in Data management, so it can't be loaded from a file or a configuration template. It shows connection details of each environment; nothing to move.Checked in Dynamics 365
Everyone

8Sources

To cite this step: SA-INQ-530, Check the database connection. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SA-INQ-530