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


    • Related Articles

    • Manage Servers Tutorial

      PDF Tutorials  Interactive Tutorial Cropped Screenshots Full Page Screenshots           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 ...

    • Manage Budgets Article

          Tutorial Link Purpose: To provide tools to manage budgets such as budget list, budget creation, delete/purge budget, lock budgets/acct #s, link actual GP data & display setup, display budgetids, forecast setup, create historical avg for spreads. ...

    • Manage Objects Article

          Tutorial Link Purpose:  The client's objects already in GP, are synchronized/added from GP into the Dynamic Budgets manage object screen. Add'l setup procedures are completed including flags, sensitivity levels, object rollups & tag labeling. ...

    • Manage OrgUnits Article

         Tutorial Link Purpose: During Client Configuration, the client's OrgUnits or Depts need to be added to Dynamic Budgets to make them available for budgeting and reporting purposes. They are managed in the Manage OrgUnits tab. ​ Once OrgUnits has ...

    • Manage Global Variables Article

      Global Variables are setup to store statistical (nonfinancial and non-system based financial) data and are accessed through Lookup.  Please see the related article How Can I Use Global Variables?  Print, Export to Excel, Print to PDF, Auto-size ...