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 When to use SQL Server authentication with PI AF server.

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 Learn about firewalls and PI AF security.