Configuring an ExactFlat Database
- Promotes standard data within an engineering work group.
- Training new users is simplified, standard data appears when needed.
- Data backups can be managed using SQL or other database format.
- Data can be integrated with outside systems. For example, cost data updates can be automated and fully formatted BOMs can be uploaded to outside systems.
An ExactFlat LocalDB is appropriate for individual users. A sample database is created when ExactFlat is installed. A local database is set up automatically when ExactFlat is installed. The advantage of a local database is simplicity, however there are many disadvantages including:
- Data backups require managing the local database file.
- Data communication with other users is restricted.
- Install either SQL Server 2012 or use the SQL LocalDB option packaged with the installer.
- Add a Database Connection to the Database Manager.
- Connect a database Refresh Database using SolidWorks.
A Stand Alone Database provides the ability to manage and use local data rather than using a network database. Each local database stores data in a .mdf format which can be edited using the ExactFlat Database Manager. Each database is stored in a folder located here:
- C:\ProgramData\Tri-D Technologies Inc\ExactFlat\Standalone Databases
- A Microsoft SQL Server 2008 R2 instance has been installed.
- The instance ID is ExactFlat.
- The database engine has been configured for mixed mode authentication.
- The system administrator password is ExactFlat.
- The SQL Server administrator is ExactFlatSA.
5.1.6. Database Engine Configuration: Tri-D Technologies Inc. recommends changing the authentication mode during the Database Engine Configuration step. The default is Windows authentication mode which gives a specific Windows user on the installation server administrative permissions to the instance. This may become a problem for remote administration in non-active directory environments or if the the selected user account does not exist on the remote computer used for instance administration. For these reasons, we recommend Mixed Mode authentication. For the purpose of this guide, the SQL Server system administrator (sa) password will be ExactFlat. For added security, Tri-D Technologies Inc. recommends a dedicated user account be created to act as the system administrator. The dedicated user does not require administrative privileges on the server to be a SQL Server system administrator. For the purpose of this guide, the dedicated user account name will be ExactFlatSA.
- Note: The system administrator user account is a special user account that has full administrative permissions to the server instance. This user can perform any action to any database hosted on the server instance. The password for this account should be a tightly guarded strong password to prevent unwanted access of the database or unintended data loss.
By default, the instance root is “%ProgramFiles%\Microsoft SQL Server”. This is the directory where all database files will be stored. This can be changed so the data is stored on a separate drive other than the root drive. Possible locations include network shares or NFS shares.
Connection to a Microsoft SQL Server instance over a network requires the TCP/IP protocol to be enabled for instance ID ExactFlat. This is done through the SQL Server Configuration Manager.
- In the left-hand panel, expand SQL Server Network Configuration and select the instance ID of your new server.
- In the right-hand panel, right-click TCP/IP and select Properties.
- Under the Protocol tab, change the value of Enabled to yes.
- Under the IP Addresses tab, find the IP address you wish to expose your instance on. Change the value of Enabled to yes. Delete the value of TCP Dynamic Ports if not empty. Change the value of TCP Port to the desired port number. The default port number for the Microsoft SQL Server Database Engine is TCP port 1433. If Port 1433 is already in use, then port 1443 is an acceptable alternative. Please contact your network administrator if you are unsure of which port to use. This guide will use port 1443.
- Click the Apply button.
- In the left-hand panel, select SQL Server Services.
- In the right-hand panel, select the instance ID of your new server.
- Either right-click the instance name and select Restart, or click the blue Restart icon in the toolbar. The instance will be restarted.
- The TCP/IP protocol has been enabled for instance ExactFlat.
- The TCP/IP protocol has been enabled on IP address 172.27.83.69 for instance ExactFlat.
- Dynamic ports have been disabled on IP address 172.27.83.69 for instance ExactFlat.
- IP address 172.27.83.69 for instance ExactFlat is listening on port TCP 1443.
- Instance ExactFlat has been restarted to allow the changes to take effect.
In most cases, your network or IT administrator will be required to make changes to a firewall to allow remote access to your database instance. Changes may be required to a hardware firewall, a software firewall on the server itself, or both. If your server is protected by a firewall, the firewall will need to be configured to allow inbound TCP traffic to the port on which your database instance is listening. For this guide, the port is 1443. The most common software firewall is the Windows firewall. Detail instructions for configuring a Windows firewall for database engine access can be found at the following link:
Do not connect to the database using the system administrator user account. Instead, create a separate non-administrative database user account for use with ExactFlat for SOLIDWORKS.
ExactFlat for SOLIDWORKS requires these permissions on the database user account to function correctly:
- Create table
Enter the server address (formatted as server_address,port).
Enter the system administrator username (for this guide, ExactFlatSA) and password.
Click the Connect button.