Overview
This article describes how to find the SQL instance name and database name. This information is required to know to complete an upload with the following connectors.
- MS Dynamics Great Plain
- MS Dynamics Navision
- MS Dynamics 365 Business Central (on premise)
- Abila
Connect to SQL Server
Log In to your Server
You will need access to the server where your accounting package and SQL server are installed or hosted. (Ensure that you have the necessary permissions to access the SQL Server.)
Open SQL Server Management Studio
Click on the Windows Start button and search for SQL Server Management Studio
Launch SQL Server Management Studio.
In SQL Server Management Studio, connect to the SQL Server instance where your accounting package is installed. You will need to enter your SQL Server credentials or use Windows authentication, depending on your setup.
Locating the Database Information
In SQL Server Management Studio, you will see the Object Explorer on the left-hand side.
Click the + on the left side to expand the tree under the SQL Server instance to find the folder name Databases.
Look for the database with the name that corresponds to your accounting package instance. The naming convention may vary, for example for Dynamics 365 Business Central it may include "NAV" or "BC" in the database name.
Locating the SQL Server Instance Name
The SQL Server instance name can be found in the top left corner of SQL Server Management Studio, just under the toolbar. It typically follows the format: ServerName\InstanceName.