When loading patch with multiple instances of Sql and one
instance does not appear in the drop down list of choices?
How can I get this instance to appear in the drop down
list?Is the instance running and is it configured the same like the other
instances in terms of security (do you have permission to access it)?
--
Mike Epprecht, Microsoft SQL Server MVP
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Bart" <anonymous@.discussions.microsoft.com> wrote in message
news:551101c47420$e6235ff0$a501280a@.phx.gbl...
> When loading patch with multiple instances of Sql and one
> instance does not appear in the drop down list of choices?
> How can I get this instance to appear in the drop down
> list?
Showing posts with label multiple. Show all posts
Showing posts with label multiple. Show all posts
Friday, March 23, 2012
MSO3-031 Patch for SQL Server
When loading patch with multiple instances of Sql and one
instance does not appear in the drop down list of choices?
How can I get this instance to appear in the drop down
list?
Is the instance running and is it configured the same like the other
instances in terms of security (do you have permission to access it)?
--
Mike Epprecht, Microsoft SQL Server MVP
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Bart" <anonymous@.discussions.microsoft.com> wrote in message
news:551101c47420$e6235ff0$a501280a@.phx.gbl...
> When loading patch with multiple instances of Sql and one
> instance does not appear in the drop down list of choices?
> How can I get this instance to appear in the drop down
> list?
sql
instance does not appear in the drop down list of choices?
How can I get this instance to appear in the drop down
list?
Is the instance running and is it configured the same like the other
instances in terms of security (do you have permission to access it)?
--
Mike Epprecht, Microsoft SQL Server MVP
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Bart" <anonymous@.discussions.microsoft.com> wrote in message
news:551101c47420$e6235ff0$a501280a@.phx.gbl...
> When loading patch with multiple instances of Sql and one
> instance does not appear in the drop down list of choices?
> How can I get this instance to appear in the drop down
> list?
sql
MSO3-031 Patch for SQL Server
When loading patch with multiple instances of Sql and one
instance does not appear in the drop down list of choices?
How can I get this instance to appear in the drop down
list?Is the instance running and is it configured the same like the other
instances in terms of security (do you have permission to access it)?
--
Mike Epprecht, Microsoft SQL Server MVP
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Bart" <anonymous@.discussions.microsoft.com> wrote in message
news:551101c47420$e6235ff0$a501280a@.phx.gbl...
> When loading patch with multiple instances of Sql and one
> instance does not appear in the drop down list of choices?
> How can I get this instance to appear in the drop down
> list?
instance does not appear in the drop down list of choices?
How can I get this instance to appear in the drop down
list?Is the instance running and is it configured the same like the other
instances in terms of security (do you have permission to access it)?
--
Mike Epprecht, Microsoft SQL Server MVP
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Bart" <anonymous@.discussions.microsoft.com> wrote in message
news:551101c47420$e6235ff0$a501280a@.phx.gbl...
> When loading patch with multiple instances of Sql and one
> instance does not appear in the drop down list of choices?
> How can I get this instance to appear in the drop down
> list?
Wednesday, March 7, 2012
MSDTC Resource in the Cluster Group
Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even if
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?
It's more a matter of usage and availability. If you use it a lot, even
though its small, it takes it toll on the disk. You would never want MSDTC
to take cycles away from what the quorum is trying to use. As for
availability, what happens if you have a resource failure? By default, the
group is afftected. Putting more things in ANY group, affects the group as a
whole. For the Highest Availability, keep everything separate.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Wayne" <Wayne@.discussions.microsoft.com> wrote in message
news:E91F75E1-1006-4062-8BC7-35D94FD3E77F@.microsoft.com...
> Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even
> if
> the MSDTC has its own IP Address and Network Name?
> In my planned multiple instance sql cluster, I can see giving up a
> physical
> disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
> doesn't use tons on disk space, can I put it in the same group as the
> defualt
> instance of SQL, again as long has it has its own IP Address and Network
> Name?
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?
It's more a matter of usage and availability. If you use it a lot, even
though its small, it takes it toll on the disk. You would never want MSDTC
to take cycles away from what the quorum is trying to use. As for
availability, what happens if you have a resource failure? By default, the
group is afftected. Putting more things in ANY group, affects the group as a
whole. For the Highest Availability, keep everything separate.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Wayne" <Wayne@.discussions.microsoft.com> wrote in message
news:E91F75E1-1006-4062-8BC7-35D94FD3E77F@.microsoft.com...
> Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even
> if
> the MSDTC has its own IP Address and Network Name?
> In my planned multiple instance sql cluster, I can see giving up a
> physical
> disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
> doesn't use tons on disk space, can I put it in the same group as the
> defualt
> instance of SQL, again as long has it has its own IP Address and Network
> Name?
Saturday, February 25, 2012
MSDTC in Cluster Group
Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even if
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?
The original MS KB posts recommended using the Cluster Group resource;
however, we've found out that it does not work and an instance of SQL Server
can not bind to it unless it's on the same node.
You can put it in the SQL Server Group resource, but it won't work once you
go multi-instanced. At that point, MS recommends that you create a seperate
shared disk resource with its own IP and Network Name resources and cluster
MS DTC as a seperate group. Looks like the coders didn't think through the
implications of the Quorum and coded against it. The SQL Server
developement group did not realize this.
Sincerely,
Anthony Thomas
"Wayne" <Wayne@.discussions.microsoft.com> wrote in message
news:922FDA87-A645-43C7-8442-BAD97525A3F1@.microsoft.com...
Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even
if
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the
defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?
The original MS KB posts recommended using the Cluster Group resource;
however, we've found out that it does not work and an instance of SQL Server
can not bind to it unless it's on the same node.
You can put it in the SQL Server Group resource, but it won't work once you
go multi-instanced. At that point, MS recommends that you create a seperate
shared disk resource with its own IP and Network Name resources and cluster
MS DTC as a seperate group. Looks like the coders didn't think through the
implications of the Quorum and coded against it. The SQL Server
developement group did not realize this.
Sincerely,
Anthony Thomas
"Wayne" <Wayne@.discussions.microsoft.com> wrote in message
news:922FDA87-A645-43C7-8442-BAD97525A3F1@.microsoft.com...
Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even
if
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the
defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?
Monday, February 20, 2012
MSDTC / sql2000 active/active
We need to create an active/active sql 2000 cluster on 2003 enterprise
server. Do I need multiple MSDTC or just one?
Windows 2000/2003 server clustering only allows for instance within a
cluster.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:C3B393B5-2BBA-46C5-8F4B-7942EBCD8E84@.microsoft.com...
> We need to create an active/active sql 2000 cluster on 2003 enterprise
> server. Do I need multiple MSDTC or just one?
|||Are you saying we cannot have an active/active cluster?
We're planning on having instance 1 on node 1, instance 2 on node 2.
burt_king@.yahoo.com
"Rodney R. Fournier [MVP]" wrote:
> Windows 2000/2003 server clustering only allows for instance within a
> cluster.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "burt_king" <burt_king@.yahoo.com> wrote in message
> news:C3B393B5-2BBA-46C5-8F4B-7942EBCD8E84@.microsoft.com...
>
>
|||No, I am saying you can only have 1 copy of MSDTC within a cluster (Longhorn
will change this...).
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:F232F32F-0DF9-477B-9BBA-113FC2F4FF46@.microsoft.com...[vbcol=seagreen]
> Are you saying we cannot have an active/active cluster?
> We're planning on having instance 1 on node 1, instance 2 on node 2.
> --
> burt_king@.yahoo.com
>
> "Rodney R. Fournier [MVP]" wrote:
|||> Are you saying we cannot have an active/active cluster?
You can have multiple SQL instances, but only one MSDTC.
Linchi
"burt_king" wrote:
[vbcol=seagreen]
> Are you saying we cannot have an active/active cluster?
> We're planning on having instance 1 on node 1, instance 2 on node 2.
> --
> burt_king@.yahoo.com
>
> "Rodney R. Fournier [MVP]" wrote:
|||Great. I assume it doesn't matter which node owns the MSDTC resource... is
that correct?
"Linchi Shea" wrote:
[vbcol=seagreen]
> You can have multiple SQL instances, but only one MSDTC.
> Linchi
> "burt_king" wrote:
|||In theory yes, but we have an application that requires MSDTC to start
before its resources start. You will need to with your applications.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:DEED957B-5413-4878-A163-E1BE2B20B442@.microsoft.com...[vbcol=seagreen]
> Great. I assume it doesn't matter which node owns the MSDTC resource...
> is
> that correct?
> "Linchi Shea" wrote:
|||Does SQL Server automagically configure itself to wait for MSDTC when doing
the clustered installs?
"Rodney R. Fournier [MVP]" wrote:
> In theory yes, but we have an application that requires MSDTC to start
> before its resources start. You will need to with your applications.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "burt_king" <burt_king@.yahoo.com> wrote in message
> news:DEED957B-5413-4878-A163-E1BE2B20B442@.microsoft.com...
>
>
|||Er, no - since mine are in different groups.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:95C0486B-FA13-4085-ADF4-81DF2301E393@.microsoft.com...[vbcol=seagreen]
> Does SQL Server automagically configure itself to wait for MSDTC when
> doing
> the clustered installs?
> --
> "Rodney R. Fournier [MVP]" wrote:
server. Do I need multiple MSDTC or just one?
Windows 2000/2003 server clustering only allows for instance within a
cluster.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:C3B393B5-2BBA-46C5-8F4B-7942EBCD8E84@.microsoft.com...
> We need to create an active/active sql 2000 cluster on 2003 enterprise
> server. Do I need multiple MSDTC or just one?
|||Are you saying we cannot have an active/active cluster?
We're planning on having instance 1 on node 1, instance 2 on node 2.
burt_king@.yahoo.com
"Rodney R. Fournier [MVP]" wrote:
> Windows 2000/2003 server clustering only allows for instance within a
> cluster.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "burt_king" <burt_king@.yahoo.com> wrote in message
> news:C3B393B5-2BBA-46C5-8F4B-7942EBCD8E84@.microsoft.com...
>
>
|||No, I am saying you can only have 1 copy of MSDTC within a cluster (Longhorn
will change this...).
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:F232F32F-0DF9-477B-9BBA-113FC2F4FF46@.microsoft.com...[vbcol=seagreen]
> Are you saying we cannot have an active/active cluster?
> We're planning on having instance 1 on node 1, instance 2 on node 2.
> --
> burt_king@.yahoo.com
>
> "Rodney R. Fournier [MVP]" wrote:
|||> Are you saying we cannot have an active/active cluster?
You can have multiple SQL instances, but only one MSDTC.
Linchi
"burt_king" wrote:
[vbcol=seagreen]
> Are you saying we cannot have an active/active cluster?
> We're planning on having instance 1 on node 1, instance 2 on node 2.
> --
> burt_king@.yahoo.com
>
> "Rodney R. Fournier [MVP]" wrote:
|||Great. I assume it doesn't matter which node owns the MSDTC resource... is
that correct?
"Linchi Shea" wrote:
[vbcol=seagreen]
> You can have multiple SQL instances, but only one MSDTC.
> Linchi
> "burt_king" wrote:
|||In theory yes, but we have an application that requires MSDTC to start
before its resources start. You will need to with your applications.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:DEED957B-5413-4878-A163-E1BE2B20B442@.microsoft.com...[vbcol=seagreen]
> Great. I assume it doesn't matter which node owns the MSDTC resource...
> is
> that correct?
> "Linchi Shea" wrote:
|||Does SQL Server automagically configure itself to wait for MSDTC when doing
the clustered installs?
"Rodney R. Fournier [MVP]" wrote:
> In theory yes, but we have an application that requires MSDTC to start
> before its resources start. You will need to with your applications.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "burt_king" <burt_king@.yahoo.com> wrote in message
> news:DEED957B-5413-4878-A163-E1BE2B20B442@.microsoft.com...
>
>
|||Er, no - since mine are in different groups.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:95C0486B-FA13-4085-ADF4-81DF2301E393@.microsoft.com...[vbcol=seagreen]
> Does SQL Server automagically configure itself to wait for MSDTC when
> doing
> the clustered installs?
> --
> "Rodney R. Fournier [MVP]" wrote:
Subscribe to:
Posts (Atom)