Configure PI AF and SQL Server database in untrusted domains

Communication must be configured between a PI AF Application Service and PI AF SQL Server database that reside in different domains and are not trusted, or are in workgroups.

1. Configure SQL Server to allow remote connections. See the Microsoft article SQL Server Documentation.

2. Configure PI AF to use SQL server security. See PI AF server configuration with SQL Server authentication.

3. If you are using a named instance of SQL Server and have not specified a port in the connect string, then make sure the SQL Server Browser service is running on the SQL Server computer. To promote the most secure environment, you should specify the port in the connection string.

4. Ensure that your system security is configured as described in Firewalls and PI AF security.