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 SQL Server installed on a remote computer.
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.
To connect to a remote SQL Server
1. Execute the adminscript_master.sql script in SSMS. You can contact PTC Support to obtain this script file.
2. Execute the UNCPath.sql script in SSMS by passing the location of the ModelerATFiles folder. You can contact PTC Support to obtain this script file.
3. You can now connect to the remote SQL Server as <machinename@Instancename> through Model Explorer.
 |
For a case-sensitive SQL Server Instance, the Windows user or group name must be case sensitive while creating a login. For more information, see <<Creating server logins for users and groups (Model Explorer)>>.
|