Manage Servers Article

Manage Servers Article


    Tutorial Link
Purpose: To build a link to the SQL server(s) where the ERP system(s) are located. Dynamic Budgets (DB) can be installed in a single SQL instance or distributed across multiple linked SQL servers.
​



This screen is the first step in configuring the system.

The purpose of the screen is to build a link to the SQL server or servers where the ERP system(s) are located.

Dynamic Budgets can be installed in either a single SQL instance or in a distributed fashion across multiple linked SQL servers. 


In Single server installs, the Dynamic Budgets database is typically co-located on the same SQL server as the production instance of the ERP. 


For Single Server Installs:


Linked Server Alias

Linked Server Database

System Database
ERP

PRIMR

SQLServerName\Instance

DYNAMICS or the Name of the SystemDatabase

DynamicsGP 


For Multi Server (Linked Server) Installs:



Linked Server Alias
Linked Server Database
System Database
ERP
Primary Server
(location of budgeting database)		PRIMR

SQLServerName\Instance

DYNAMICS 

DynamicsGP

Linked Server5 character alias as specified
in Linked Server definition		SQLServerName\Instance
DYNAMICS or the Name of the SystemDatabase
DynamicsGP