Working with a remote SQL Server
PTC Modeler provides the flexibility of installing PTC Modeler Server and SQL Server on different machines to allow for maximum utilization of hardware resources. This topic provides instructions on configuring PTC Modeler to work with a remotely installed SQL Server.
 |
Local Windows users cannot connect to a remote SQL Server.
|
Prerequisites
• This task must be performed by a SQL Server Administrator.
• Ensure that both the servers are on the same domain/network.
• Ensure that the firewall rules on the remote SQL Server are correctly configured to allow connections from PTC Modeler. Fore more information on configuring the Windows firewall, see Setting up the Windows Firewall.
• Ensure that the folder located at %PROGRAMDATA%\PTC Integrity Modeler\ModelerATFiles is shared to all PTC Modeler users with Write access.
Setting up a Web Interface account with remote SQL Server
Perform the following steps to connect a Web Interface website with a remote SQL Server:
1. The IIS must be configured with the domain user (for example DomainName\UserName).
2. The DomainName\UserName must have at least Read Access to all Modeler databases.
3. The DomainName\UserName must open Model Explorer once and bookmark all Modeler databases.
4. To create local web interface user accounts (such as a tester account), the SQL Server Administrator must provide db_owner access to the DomainName\UserName for the StudioRESTService database through SSMS.
5. The DomainName\UserName must be an Administrator for the machine where the PTC Modeler Server is installed.