EC-CAD Remote Working Information

Working in remote locations with EC-CAD can be easy to achieve. Please talk to your company's EC-CAD administrator or IT administrator to find out the best method to work remotely.

Remote WOrking Instructions For

Trimble EC-CAD

The Trimble EC-CAD for AutoCAD MEP program can be installed on as many systems as you wish. Whether it is an additional work laptop or a home PC, it does not matter. The application will install, but you will need the license and database for it to function. The EC-CAD license keys are “plug & play” meaning that they can be pulled from any PC and plugged into another. The E-CCAD database takes a little more setup depending on your current work configuration. Below are a few scenarios.

EC-CAD with a local SQL Database and local license key.

It is typical that in this situation a user will bring the system, either home, or onto a job site. Once the user is off the work domain they may need to modify the SQL database owner. This is done by using Microsoft SQL Server Manager to enter the properties of the database and change the database owner to “sa”.

This allows the user to connect to SQL database as system admin. Below is more information on modifying your SQL database owner for connection off of your work domain.

EC-CAD with a local SQL Database and Network license keys

Some users may be using a Networked license key plugged in a work server. These network licenses keys allow one or more instances of the product to be used. To access a network license key plugged into your works server, you will need to have your IT people set up a VPN connection to the office network. Once the VPN is set up and configured properly you should be able to pull a license. There are times when the server or network requires additional configuration to allow this to work. If you are the only one using the network key it would be more efficient to simply unplug the key from the server, and use it locally.

EC-CAD with a Networked SQL Database

You may have your SQL server instance and Database hosted on a server. We often install a new instance of SQL server on the local system going off site, and perform a database backup, and restore.

You can create a backup of your networked database using Microsoft Management Studio. You can then “restore” the database to the local instance of SQL server on your home PC/Laptop.

Database Backup and Restore

Below are instructions on how we typically perform a database backup/Restore.

Modifying SQL Database Owner

There are time when you may want to change the database owner to “sa”

  • Open Microsoft SQL Server Management Studio
  • Connect to SQL Instance
  • Expand “:Databases”
  • Right-Click on your database
  • Click Properties
  • Click “Files”
  • Type sa for the owner
  • Click OK and close Management Studio.

SQL Server Database – Creating .bak file

  • Open SQL server management studio
  • Connect to your instance of SQL Server
  • Expand Databases
  • Right-Click on your database
  • Select Tasks
  • Select Back Up
  • In most cases the Source, Backup set, and Destination will be already filled out correctly. If not, you may need to Name the Backup set and Add a Destination for the Backup file to be created to.
    • To add a destination:
      • Click Add
      • Browse to the default location of SQL Backups - Program Files\Microsoft SQL Server\MSSQL10.50.SQLEXpress\MSSQL\Backup
      • Click OK
  • Click OK and the backup process will execute
  • When finished click OK
  • The backup files (.bak files) will be created in the Destination directory. Typically Program Files\Microsoft SQL Server\MSSQL10.50.SQLEXpress\MSSQL\Backup

SQL Server Database – Restoring Backup

Please store your .bak files in the default SQL Backup Directory. When you restore a database it should default to this default directory making it easy for you to locate the backup file. It is import to have full access and admin right to this default directory for you to restore database files.

Here is the default SQL Backup directory:

C:/Program Files/Microsoft SQL Server/MSSQL10_##.SQLExpress/MSSQL/Backup

Follow instruction below on restoring your .bak files.

  • Open SQL server management studio
  • Connect to your instance of SQL Server
  • Right-Click on Databases
  • Select Restore Database
  • From the Restore Database Window
    • Give the database a name
    • Select the from device bullet
    • Select the browse button
      • NOTE: If you cannot select a device location you do not have user permissions to do so. You will need to contact your IT people to get full access to run SQL Management studio and to access the default backup location.
    • Click Add
    • Select you database .bak file
    • Click OK
    • Click OK
    • Check the Database to Restore
    • Click OK
  • This will execute the process of restoring a database. When it is finished you are done.

For further assistance please contact Trimble MEP support