DriveWorks Pro Server is a free tool included in the DriveWorks installation package.
It is used to manage Shared Groups created by DriveWorks Administrator and accessed by all DriveWorks Pro modules.
A DriveWorks Pro installation will typically include one or more installations of DriveWorks Administrator, DriveWorks User, DriveWorks Autopilot, and DriveWorks Live, all of which need to use the same DriveWorks data.
In individual cases, DriveWorks Pro will be set up with an Individual Group which is suitable for one user accessing the data at a time.
In shared cases, as above, DriveWorks Pro Server is used in conjunction with Microsoft SQL Server (see note below)to enable multiple users to run Specifications, and administer Projects.
Microsoft SQL Server Editions
This topic refers to Microsoft SQL Server, please refer to the DriveWorks Pro Server Prerequisites for information on which editions of SQL Server are supported.
DriveWorks Pro Server also supports Microsoft Azure SQL Server acting as the Pro Server database host.
DriveWorks Pro Server has two main functions
Instead of connecting DriveWorks Administrator, DriveWorks User, and the other products directly to the Microsoft SQL Server, they are connected to the DriveWorks Pro Server which connects to the Microsoft SQL Server on their behalf.
Pro Server makes it easy for users of the other DriveWorks products to connect to and work with the DriveWorks Groups in the Microsoft SQL Server, while hiding the non-DriveWorks databases from them.
Pro Server also simplifies firewall configuration when a firewall is present between the DriveWorks Pro Server machine and other machines by enabling a System Administrator to set up a firewall exception for the DriveWorks Pro Server service executable.
DriveWorks Pro Server provides a number of capabilities designed to make it easier to work in multi-seat environments:
Previous Versions of DriveWorks
When upgrading your current version of DriveWorks please read the Previous Versions section in the article Installation.
Uninstalling DriveWorks Pro Server
When uninstalling DriveWorks Pro Server please read the Uninstalling section in the article Installation.
Before installing DriveWorks Pro Server please read the Deployment Scenarios in the article How To: Deploy DriveWorks Pro.
With DriveWorks Pro Server you connect to a database server that hosts the DriveWorks Shared Group or Groups.
The database server is a SQL Server edition database. Please see DriveWorks Pro Server Prerequisites for the supported editions of SQL Server.
Once DriveWorks Pro Server is connected to the SQL Server, Shared Groups are created on the server from DriveWorks Administrator. Individual Groups can be upscaled to a Shared Group using the Group Upscale tool.
The user has the correct SQL permissions. More information about this and how to test it can be found in SQL Server.
Firewall settings on the Pro Server machine should be adjusted to allow clients to connect.
To adjust Firewall settings on the machine that hosts the DriveWorks Pro Server.
To establish if the firewall is preventing access we recommend disabling the firewall on the sharing server machine temporarily and try re-connecting from the DriveWorks application that is trying to access the Pro Server. If this is then successful re-enable the firewall and check the following settings: