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 ...
    • What to do after Upgrading GP and/or Migrating to a new SQL Server Article

      What to do after Upgrading GP and/or Migrating to a new SQL Server  Adjusting Dynamic Budgets after a GP upgrade is typically just a 5 minute task, see the steps below. If you migrated GP to a new SQL server, please send us the name/instance of the ...
    • 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 ...