Setting up and configuring a remote SQL Server

Administration > SQL Server Administration > Setting up and configuring a remote SQL Server

Windchill Modeler provides the flexibility of installing the Modeler server and SQL Server on different machines to allow for maximum utilization of hardware resources. This chapter provides instructions on configuring Windchill Modeler to work with a remotely installed Microsoft SQL Server.

Ensure that both the servers are on the same domain/network.

Microsoft SQL Server

1. Install Microsoft SQL Server 2017 or higher on a server.

2. Follow the steps listed in the topic Setting up the Windows Firewall.

Windchill Modeler Server

Install SSMS and try connecting to the remote SQL Server. After a successful connection, install Windchill Modeler.