x

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

more ▼

asked Jun 17, 2014 at 10:12 AM in Default

avatar image

Mandar Alawani
376 40 43 48

(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1198
x376
x45
x27

asked: Jun 17, 2014 at 10:12 AM

Seen: 916 times

Last Updated: Jun 17, 2014 at 10:12 AM

Copyright 2017 Redgate Software. Privacy Policy