Troubleshooting the on-premises sharing service for Tekla Model Sharing

Troubleshoot common problems with the on-premises sharing service for Tekla Model Sharing, or configure the SQL Server for testing or evaluation purposes.

Users cannot connect to the on-premises sharing service for Tekla Model Sharing from Tekla Structures

Ensure that the Tekla Model Sharing 3 Windows Service is running.
Ensure that your firewalls do not block the TCP/IP ports that Tekla Structures uses. The default ports are 9000 and 9997.
Ensure that the SQL Server is running correctly.

The service does not start

Check the Application Log in Windows Event Viewer for possible errors.

Set up SQL Server authentication for testing or evaluation

This authentication method is not recommended for use in a production environment. Set up SQL authentication only for testing or evaluation purposes.

Warning: When you use SQL Server authentication, the username and password for the SQL Server are stored in an unencrypted configuration file.

For more information about authentication methods for the SQL Server, see the SQL Server documentation on the Microsoft website.

Run the TeklaModelSharingService.exe installer.
- To change the configuration of an existing on-premises sharing service for Tekla Model Sharing, select the Repair option.
- For a new installation, see Download and run the on-premises sharing service for Tekla Model Sharing installer.
On the SQL Configuration: SQL Server database parameters page, fill in the information.
1. Use the default SQL Server login name.
  
  The default SQL Server login name is datasharing.
2. In the SQL Server login password box, enter the password that you created for the SQL Server login in Microsoft SQL Server Management Studio.
3. Select SQL Server Authentication.
In Microsoft SQL Server Management Studio, under the selected database engine, right-click the Security folder, then select New > Login.
On the General page, set the following options:
1. Enter a name for the login, such as datasharing.
2. Select SQL Server authentication and enter the password for the login in the Password and Confirm password boxes.
3. Clear the Enforce password expiration check box.
4. Optional: Select DataSharing9 as the Default database.
On the User Mapping page, grant rights to the database for the new login.
1. From the Users mapped to this login list, select DataSharing9.
2. From the Database role membership for list, select db_owner.
3. Click OK to create the login and the user.

Next, start the on-premises sharing service for Tekla Model Sharing.

Before using the on-premises sharing service for Tekla Model Sharing for production use, enable Windows authentication.