SSISDB in Availability Group: Issue when adding second SSISDB of Windows Server FailOver Cluster in...
a sore throat vs a strep throat vs strep throat
Was there a Viking Exchange as well as a Columbian one?
How did Captain America manage to do this?
What happened to Captain America in Endgame?
How could Tony Stark make this in Endgame?
What are the potential pitfalls when using metals as a currency?
How to verbalise code in Mathematica?
US visa is under administrative processing, I need the passport back ASAP
How to creep the reader out with what seems like a normal person?
Is it idiomatic to construct against `this`?
Minor Revision with suggestion of an alternative proof by reviewer
Do I have to worry about players making “bad” choices on level up?
Does Gita support doctrine of eternal cycle of birth and death for evil people?
Was there a shared-world project before "Thieves World"?
What software provides a code editing environment on iPad?
Packing rectangles: Does rotation ever help?
Are Boeing 737-800’s grounded?
Interpret a multiple linear regression when Y is log transformed
How would one muzzle a full grown polar bear in the 13th century?
As an international instructor, should I openly talk about my accent?
How to pronounce 'C++' in Spanish
How can Republicans who favour free markets, consistently express anger when they don't like the outcome of that choice?
How does a program know if stdout is connected to a terminal or a pipe?
how to find the equation of a circle given points of the circle
SSISDB in Availability Group: Issue when adding second SSISDB of Windows Server FailOver Cluster in Availability Group
Timeouts when connecting to SQL Server since installing SP1 for Windows 7Installation issue for SQL Server 2005 on my Windows 7 Enterprise 32-bitRandom insane bad execution plans in Microsoft SQL ServerSQL corruption message with bogus database IDWebservice with affinity for the Primary Replica of an SQL Server AlwaysOn Availability Group
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
Context
I have followings:
2 Windows Server FailOver Cluster with 2 SQL Server 2016 instances in each one (DEV and PROD)
1 Availability Group AGDEV that contains DEV databases of the 2 DEV instances
1 Availability Group AGPROD that contains PROD databases of the 2 PROD instances
Unsolved issue
DEV SSISDB has been added in the AGDEV Availability Group and this ended up successfully
I attempted to add PROD SSISDB in AGPROD and this ended up with following error (when executing “Enable Always On Support”):
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
I found a workaround described here to manually achieve the task https://www.sqlservermigrations.com/2018/08/adding-an-integration-services-catalog-to-always-on-availability-groups-subquery-error/
I did the failover while PROD SSISDB package was running. As results, SSISDB packages are no more running (I have a database with status “In recovery”)
Question
Is there any native SQL 2016 means to set multiple SSISDB in the same Windows Server Failover Cluster? If no, is this feature implemented in SQL 2017 or planned in future releases?
Thanks in advance,
Abenico
sql-server
asked yesterday
AbenicoAbenico
1
New contributor
Abenico is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Context
I have followings:
2 Windows Server FailOver Cluster with 2 SQL Server 2016 instances in each one (DEV and PROD)
1 Availability Group AGDEV that contains DEV databases of the 2 DEV instances
1 Availability Group AGPROD that contains PROD databases of the 2 PROD instances
Unsolved issue
DEV SSISDB has been added in the AGDEV Availability Group and this ended up successfully
I attempted to add PROD SSISDB in AGPROD and this ended up with following error (when executing “Enable Always On Support”):
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
I found a workaround described here to manually achieve the task https://www.sqlservermigrations.com/2018/08/adding-an-integration-services-catalog-to-always-on-availability-groups-subquery-error/
I did the failover while PROD SSISDB package was running. As results, SSISDB packages are no more running (I have a database with status “In recovery”)
Question
Is there any native SQL 2016 means to set multiple SSISDB in the same Windows Server Failover Cluster? If no, is this feature implemented in SQL 2017 or planned in future releases?
Thanks in advance,
Abenico
sql-server
asked yesterday
AbenicoAbenico
1
New contributor
Abenico is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Context
I have followings:
2 Windows Server FailOver Cluster with 2 SQL Server 2016 instances in each one (DEV and PROD)
1 Availability Group AGDEV that contains DEV databases of the 2 DEV instances
1 Availability Group AGPROD that contains PROD databases of the 2 PROD instances
Unsolved issue
DEV SSISDB has been added in the AGDEV Availability Group and this ended up successfully
I attempted to add PROD SSISDB in AGPROD and this ended up with following error (when executing “Enable Always On Support”):
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
I found a workaround described here to manually achieve the task https://www.sqlservermigrations.com/2018/08/adding-an-integration-services-catalog-to-always-on-availability-groups-subquery-error/
I did the failover while PROD SSISDB package was running. As results, SSISDB packages are no more running (I have a database with status “In recovery”)
Question
Is there any native SQL 2016 means to set multiple SSISDB in the same Windows Server Failover Cluster? If no, is this feature implemented in SQL 2017 or planned in future releases?
Thanks in advance,
Abenico
sql-server
asked yesterday
AbenicoAbenico
1
New contributor
Abenico is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Context
I have followings:
2 Windows Server FailOver Cluster with 2 SQL Server 2016 instances in each one (DEV and PROD)
1 Availability Group AGDEV that contains DEV databases of the 2 DEV instances
1 Availability Group AGPROD that contains PROD databases of the 2 PROD instances
Unsolved issue
DEV SSISDB has been added in the AGDEV Availability Group and this ended up successfully
I attempted to add PROD SSISDB in AGPROD and this ended up with following error (when executing “Enable Always On Support”):
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
I found a workaround described here to manually achieve the task https://www.sqlservermigrations.com/2018/08/adding-an-integration-services-catalog-to-always-on-availability-groups-subquery-error/
I did the failover while PROD SSISDB package was running. As results, SSISDB packages are no more running (I have a database with status “In recovery”)
Question
Is there any native SQL 2016 means to set multiple SSISDB in the same Windows Server Failover Cluster? If no, is this feature implemented in SQL 2017 or planned in future releases?
Thanks in advance,
Abenico
sql-server
sql-server
asked yesterday
AbenicoAbenico
1
New contributor
Abenico is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
AbenicoAbenico
1
New contributor
Abenico is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
AbenicoAbenico
1
New contributor
Abenico is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
AbenicoAbenico
1
asked yesterday
AbenicoAbenico
1
1
New contributor
Abenico is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Abenico is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Abenico is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Abenico is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1429887%2fssisdb-in-availability-group-issue-when-adding-second-ssisdb-of-windows-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Abenico is a new contributor. Be nice, and check out our Code of Conduct.
Abenico is a new contributor. Be nice, and check out our Code of Conduct.
Abenico is a new contributor. Be nice, and check out our Code of Conduct.
Abenico is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1429887%2fssisdb-in-availability-group-issue-when-adding-second-ssisdb-of-windows-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
