Re-publishing Report does not update Application Intent

Hi mcho ,

You can use the following sql query to determine if the multi-subtnet failover works.

SELECT DATABASEPROPERTYEX(DB_NAME(), ‘Updateability’) AS Access;

SELECT

       req.session_id,

       req.status,

       req.command,

       req.cpu_time,

       req.total_elapsed_time,

       s.host_name,

       s.program_name,

       s.login_name

FROM sys.dm_exec_requests req

INNER JOIN sys.dm_exec_sessions s ON  req.session_id = s.session_id

WHERE s.program_name = ‘Mashup Engine’;

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai