Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSIS amd always on config

Status
Not open for further replies.
niall5098

niall5098

IS-IT--Management
Jun 2, 2005
114
IE
HI There,

i have 2 new servers with always on configured for databases. I now have a requirement to install and configure SSIS. From what i can see the best approach is:

install SSIS on both nodes
initial catalog on both nodes.
delete ssidb on node2
add ssidb from node1 to always on.

the issue is if i delete the db from node2, the catalog is also removed.

of i leave the database on node 2 and try to add db to always on then i get the db already exists error.

has anyone had any experience on setting up and configuring ssis with always on?

Thanks in advance,

Niall
 
Status
Not open for further replies.

Similar threads

TheBugSlayer
  • Locked
  • Question
High Availability - insert fails on primary replica but runs on secondary after failover.
Replies
0
Views
181
TheBugSlayer
TheBugSlayer
CodeWell
  • Locked
  • Question
SQL Server 2017 Install Issue - Database Not in Configuration Manager
Replies
0
Views
253
CodeWell
CodeWell
JScannell
  • Locked
  • Question
SQL login on Classic ASP localhost site
Replies
0
Views
179
JScannell
JScannell
Craig_DaviesB2
  • Locked
  • Question
Migration of SQL 2008 R2 Standard to SQL 2012 Standard - @flags parameter not valid SSIS
Replies
1
Views
105
simian336
simian336
Farrukh hameed
  • Locked
  • Helpful tip
Single Connection string control multiple database connection on case condtion
Replies
1
Views
172
fredericofonseca
fredericofonseca

Part and Inventory Search

Sponsor

Back
Top