I had implemented successfully SQL Server Routing List Feature many times... but I have a very special scenario where our Reporting Services Node is located in a different Domain than SQL Server Nodes.
Brief environment description:
- Reporting Services/SQL2012 (connection success with other server environments using Application Intent)
- Always On Nodes/SQL2014.
- There are several security levels between then. Only require port for SQL Server Listener is open.
- When I built a Reporting Services DataSource without Application Intent Property, the connection test run with success but as soon I activate
ApplicationIntent=ReadOnly;MultiSubnetFailover=Truethe connection fails throwing the following error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.)
- Datasource is using SQL Auth, and the user exist in all participant nodes of the availability group.