Router-CIM Automation Suite

RCIM_AS_2019_Header


RCIM_AS_2019_Header


Previous topic Next topic  

RCIM_AS_2019_Header


Previous topic Next topic  

Setting up a Shared Database

Setting up a Shared Database allows you to have multiple users working from the same jobs, settings and materials in Router-CIM Automation Suite. This will assist in keeping multiple users producing the same results through Router-CIM Automation Suite.

 

There are two methods for setting up Router-CIM Automation Suite with a shared database:

 

1) Selecting a Master Computer (complete installation of AutoCAD and Router-CIM required) that all computers have access to.

 

2) Setting up the SQL Server on a stand-alone server (AutoCAD and Router-CIM installation on the server is not required). Requires additional support files to be downloaded. Please proceed to the 'Installing on a Stand-Alone Server' section before setting up the shared database.

 

Either process will be setup the same way following these instructions:

 

Note: Setting up a shared database using a master computer assumes that all computers being setup with have access to the master computer at all times when running Router-CIM Automation Suite.

Note: Setting up a shared database using a stand-alone server assumes that all computers being setup with have access to the stand-alone server at all times when running Router-CIM Automation Suite.

Note: These procedures ONLY need to be done on the client computers, when setting up Shared Databases using a Master Computer. The Master Computer will need no changes.

 

On a client computer, select 'Database Maintenance' under the 'File' menu in Router-CIM Automation Suite:

 

File_DropDown

 

Once selected, the Database Manager will open:

 

DB_Maint_Interface

 

With the Database Manager open, select the option on the top of the window for 'SQL Server is on other computer':

 

DB_Maint_SQL_Server_Other

 

You can then proceed to the drop-down option under 'Default Server'. This will show you the SQL Servers that your computer has access to:

 

DB_Maint_SQL_Default_DropDown

 

If you do not see the SQL Server that you are trying to access on the Master Computer, you can manually type in the name of the Master Computer followed by the correct database name:

 

DB_Maint_SQL_Manual

 

Once the SQL Server has been selected via the drop-down option or manually entered, select the 'Verify Server' button on the left side of the Database Manager:

 

DB_Maint_SQL_Verify

 

If the SQL Server was found, you will receive this message:

 

DB_Maint_SQL_Verify_Success

 

If the SQL Server was not found, you will receive this message:

 

DB_Maint_SQL_Verify_Fail

 

Followed by:

 

DB_Maint_SQL_Verify_Fail2

 

At this point, verify your connection name and try again. Once you have selected an available server, see 'Set as Current' section for more information, and connected successfully to it you can close the Database Manager.
Note: Once a Shared Database is setup, you may want to select the option 'Utilize Manager Record Locking (Advanced Database Sharing)' under the 'Advanced Settings' section.