question

Mandar Alawani avatar image
Mandar Alawani asked

Run SSISDB without AlwaysOn in SQL 2012

Hi All, We have SQL 2012 installed on 2 nodes and have 2 user Dbs as part of Availability group. SSISDB is NOT part of the availability group. We have also installed SSIS Catalog on Node 1 & Node 2, with SSISDB created on each node. I have one SSIS job which runs fine on the node1 but this job fails on Node 2 with error: "cannot open ssisdb requested by login " --> this login is the SQL agent login My questions: 1. Can we run SSIS outside of the Availability group? If so, how? 2. We have deployed the SSIS packages to both the nodes and it is configured to connect to the listener SQL instance, so can I ensure that the SSIS packages run fine when /if the node failsover from Node 1 to Node2? Thanks, Regards, Mandar
ssissql-server-2012always-onavailability-groups
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.