ERROR: "Database failed : SqlDependency does not support calling Start() with different connection strings having the same server, user, and database in the same app domain."

Applies To: AutoMate BPA Server 10, AutoMate 10, Automate Enterprise 11, Automate 11
Published: 4/23/18

ERROR MESSAGE:
Database failed : SqlDependency does not support calling Start() with different connection strings having the same server, user, and database in the same app domain.

AFFECTED COMPONENT:
Database Trigger

SOLUTION / EXPLANATION:
Based on the restrictions outlined below, multiple database triggers using the same

https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldependency.start(v=vs.110).aspx

Multiple calls to the Start method can be made, subject to the following restrictions:

- Multiple calls with identical parameters (the same connection string and Windows credentials in the calling thread) are valid.
- Multiple calls with different connection strings are valid as long as:
   - Each connection string specifies a different database, or
   - Each connection string specifies a different user, or
   - The calls come from different application domains.