Installing MSDTC Resource after installing SQL Server 2000 cluster

Is it possible to install and configure the MSDTC resource in a SQL Server 2000 cluster after SQL is installed and running?

When I recently went through a rebuild of my cluster, I forgot to install the resource before installing SQL Server. Now, if I install and bring online the MSDTC resource the SQL disk groups will not fail over correctly. The SQL Server resource will not come online.

Thanks in advance for any help. I would really like to avoid rebuilding again.

Andy

I am not an expert on clusters but you might want to check out the following article

http://support.microsoft.com/kb/294209/en-us

Michelle

sql

installing management studio on a cluster

Hi,
I am installing sql 2005 on a two node cluster. I have managed to complete
the installation and then wanted to add the sql management studio on to the
cluster. I installed disk two and chose the support tools but have way
through the installation it failed with the following error:
Failed to install and configure assemblies C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The Transaction Manager is not available. (Exception from
HRESULT: 0x8004D01B)
I was installing this on the first node which had ownership of the shared
disks
Any ideas
Looks like you need to install a clustered instance of MSDTC.
http://www.microsoft.com/technet/prodtechnol/biztalk/2006/library/bts06clustering/55b0c81f-44a5-4069-b065-57df1cce19ac.mspx?mfr=true
Ignore the incoming caller stuff. That is for Biztalk.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:D07341A6-EDDA-4448-9C8A-23A1727E565B@.microsoft.com...
> Hi,
> I am installing sql 2005 on a two node cluster. I have managed to complete
> the installation and then wanted to add the sql management studio on to
> the
> cluster. I installed disk two and chose the support tools but have way
> through the installation it failed with the following error:
> Failed to install and configure assemblies C:\Program Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from
> HRESULT: 0x8004D01B)
> I was installing this on the first node which had ownership of the shared
> disks
>
> Any ideas

Installing cluster in Windows 2000 + 2003

I have a Windows 2000 that crashed and was part of a active/active SQL cluster (SQL 2000).
Instead of reinstall the box with Windows 2000, I reinstalled it with Windows 2003 Advanced.
In Cluster Administrator (on the Windows 2003 box), I am trying to add the node, and I always get the following error:
- sql1: The list of nodes to configure is empty.
- Error 0x800713ac: A cluster node is not available for this operation.
here's the content of the log:
2004-04-02 13:34:10.084 [INFO] [CConnPointEnum::HrAddConnection] punk 0x0cd808 added to the connection point enumerator. (hr=00000000)
2004-04-02 13:34:10.214 [INFO] [CConnPointEnum::HrAddConnection] punk 0x0ce2f8 added to the connection point enumerator. (hr=00000000)
2004-04-02 13:34:25.195 [INFO] [WIZ] Setting analyze page active. Setting aborted to FALSE.
2004-04-02 13:34:25.336 [INFO] [MT] [CTaskAnalyzeClusterBase] Beginning task...
2004-04-02 13:34:25.446 [INFO] CLUSTER2: Checking for an existing cluster... (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 0), (null)
2004-04-02 13:34:25.556 [INFO] [CTaskAnalyzeClusterBase] Setting completion cookie 4 at array index 0 into the gather cluster information
task for node CLUSTER2.shop.clic.net
2004-04-02 13:34:25.656 [INFO] [MT] The name to connect to is 'CLUSTER2'.
2004-04-02 13:34:25.736 [INFO] [MT] Requesting a remote connection to 'CLUSTER2'.
2004-04-02 13:34:25.846 [INFO] CLUSTER2: The DNS record for "CLUSTER2.shop.clic.net" is "192.168.0.233". (hr=00000000,
{B8453B8F-92FD-4350-A6D9-551FD018B791}, {D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
2004-04-02 13:34:25.937 [INFO] sql1: Requesting a remote connection to "CLUSTER2" in domain "shop.clic.net" with binding string
"192.168.0.233" (hr=00000000, {B8453B8F-92FD-4350-A6D9-551FD018B791}, {26015CA7-EAE1-43F4-AC1E-718D80629E93}, 1, 1, 1), (null)
2004-04-02 13:34:26.067 [INFO] [MT] Connection to 'CLUSTER2' with binding string '192.168.0.233' failed because one or more classes are not
registered.
2004-04-02 13:34:26.187 [INFO] CLUSTER2: The DNS record for "CLUSTER2.shop.clic.net" is "192.168.0.233". (hr=00000000,
{B8453B8F-92FD-4350-A6D9-551FD018B791}, {D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
2004-04-02 13:34:26.427 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for the completion cookie 1.
2004-04-02 13:34:26.537 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for the completion cookie 4.
2004-04-02 13:34:26.628 [INFO] [CTaskAnalyzeClusterBase] Clearing completion cookie 4 at array index 0
2004-04-02 13:34:26.658 [INFO] CLUSTER2: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 1), (null)
2004-04-02 13:34:26.718 [INFO] [MT] [CTaskGatherClusterInfo] exiting task. The task was not cancelled.
2004-04-02 13:34:26.808 [INFO] CLUSTER2: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 2), (null)
2004-04-02 13:34:26.988 [INFO] [MT] Adding node 'SQL1.shop.clic.net' to the list of user-added nodes.
2004-04-02 13:34:27.128 [INFO] CLUSTER2: Collecting nodes currently in the cluster... (hr=00000000, {EBC8AEFF-10C3-4D5B-AC17-FC0F4C3871B7},
{72A04E74-2D14-4AD8-8E12-4AFBA56FD0E0}, 0, 1, 0), (null)
2004-04-02 13:34:27.389 [INFO] [MT] Connecting to cluster node 'SQL2.shop.clic.net'
2004-04-02 13:34:27.519 [INFO] CLUSTER2: Collecting nodes currently in the cluster... (hr=00000000, {EBC8AEFF-10C3-4D5B-AC17-FC0F4C3871B7},
{72A04E74-2D14-4AD8-8E12-4AFBA56FD0E0}, 0, 1, 1), (null)
2004-04-02 13:34:27.649 [INFO] CLUSTER2: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 90), (null)
2004-04-02 13:34:27.789 [INFO] sql1: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062}, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, 0,
90, 0), (null)
2004-04-02 13:34:27.919 [INFO] CLUSTER2: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{CC5E57B1-4520-4672-B4BA-A288EC42946E}, 0, 90, 0), (null)
2004-04-02 13:34:28.050 [INFO] [CTaskAnalyzeClusterBase] Setting completion cookie 6 at array index 0 into the gather node information task
for node SQL1.shop.clic.net
2004-04-02 13:34:28.190 [INFO] [CTaskAnalyzeClusterBase] Setting completion cookie 7 at array index 1 into the gather node information task
for node SQL2.shop.clic.net
2004-04-02 13:34:28.190 [INFO] SQL1: Connecting to server... (hr=00000000, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0, 1, 0), (null)
2004-04-02 13:34:28.320 [INFO] SQL2: Connecting to server... (hr=00000000, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0, 1, 0), (null)
2004-04-02 13:34:28.460 [INFO] [MT] The name to connect to is 'SQL1'.
2004-04-02 13:34:28.590 [INFO] [MT] The name to connect to is 'SQL2'.
2004-04-02 13:34:28.721 [INFO] [MT] Requesting a local connection to 'SQL1'.
2004-04-02 13:34:28.851 [INFO] [MT] Requesting a remote connection to 'SQL2'.
2004-04-02 13:34:29.061 [WARN] sql1: This node is already a member of a cluster, but the cluster service is not running. This node will not
be configured at this time. (hr=0x000001, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {8028BF97-2D57-4628-845D-C4BEFFEB531A}, 1, 1, 1), The
cluster service on this node is configured but is not currently running. This node will be skipped and no further tasks will be performed on
it. If this node is not supposed to be a member of any cluster, then clean it up using the "cluster node /forcecleanup" command and try
again.
2004-04-02 13:34:29.131 [INFO] SQL2: The DNS record for "SQL2.shop.clic.net" is "192.168.0.242". (hr=00000000,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
2004-04-02 13:34:29.271 [WARN] sql1: This node is already a member of a cluster, but the cluster service is not running. This node will not
be configured at this time. (hr=0x000001, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {8028BF97-2D57-4628-845D-C4BEFFEB531A}, 1, 1, 1), The
cluster service on this node is configured but is not currently running. This node will be skipped and no further tasks will be performed on
it. If this node is not supposed to be a member of any cluster, then clean it up using the "cluster node /forcecleanup" command and try
again.
2004-04-02 13:34:29.402 [INFO] sql1: Requesting remote connections... (hr=00000000, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{1B606398-7193-4A48-AFBD-98AC8BACB690}, 1, 1, 1), (null)
2004-04-02 13:34:29.542 [INFO] [SRV] The cluster service is down on this node.
2004-04-02 13:34:29.672 [INFO] sql1: Requesting a remote connection to "SQL2" in domain "shop.clic.net" with binding string "192.168.0.242"
(hr=00000000, {1B606398-7193-4A48-AFBD-98AC8BACB690}, {7DCE2976-3E89-4683-8980-B41130CBABD9}, 1, 1, 1), (null)
2004-04-02 13:34:29.812 [INFO] [SRV] CClusCfgClusterInfo::Initialize() returning (hr=0x0713ba)
2004-04-02 13:34:29.962 [INFO] [MT] Connection to 'SQL2' with binding string '192.168.0.242' failed because one or more classes are not
registered.
2004-04-02 13:34:30.093 [WARN] sql1: GetClusterConfigInfo() completed. (hr=0x0713ba, {05AA0768-5F49-49CD-AFDC-96F9D51802D4},
{B460EA73-6223-44FA-84E0-DE7EC069DDD4}, 1, 1, 1), (null)
2004-04-02 13:34:30.253 [INFO] SQL2: The DNS record for "SQL2.shop.clic.net" is "192.168.0.242". (hr=00000000,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
2004-04-02 13:34:30.403 [WARN] sql1: The cluster configuration server has been started. (hr=0x0713ba,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {39371CBA-A47B-4A4F-9042-6BECD321E9E2}, 1, 1, 1), (null)
2004-04-02 13:34:30.613 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for the completion cookie 5.
2004-04-02 13:34:30.663 [WARN] sql1: The cluster configuration server has been started. (hr=0x0713ba,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {39371CBA-A47B-4A4F-9042-6BECD321E9E2}, 1, 1, 1), (null)
2004-04-02 13:34:30.804 [INFO] SQL2: (null) (hr=00000000, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0,
1, 1), (null)
2004-04-02 13:34:30.964 [INFO] [MT] The cluster service on node 'SQL1' is down.
2004-04-02 13:34:31.084 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for the completion cookie 7.
2004-04-02 13:34:31.244 [WARN] SQL1: (null) (hr=0x0713ba, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0,
1, 1), (null)
2004-04-02 13:34:31.414 [INFO] [CTaskAnalyzeClusterBase] Clearing completion cookie 7 at array index 1
2004-04-02 13:34:31.545 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for the completion cookie 6.
2004-04-02 13:34:31.675 [INFO] [MT] [CTaskGatherNodeInfo] exiting task. The task was not cancelled.
2004-04-02 13:34:31.805 [INFO] [CTaskAnalyzeClusterBase] Clearing completion cookie 6 at array index 0
2004-04-02 13:34:32.075 [INFO] sql1: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062}, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, 0,
90, 1), (null)
2004-04-02 13:34:32.075 [INFO] [MT] [CTaskGatherNodeInfo] exiting task. The task was not cancelled.
2004-04-02 13:34:32.216 [ERR ] sql1: The list of nodes to configure is empty. (hr=0x800713ac, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{A678963B-9173-4393-B21B-0B4337B28EE2}, 1, 1, 1), (null)
2004-04-02 13:34:32.486 [INFO] CLUSTER2: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{CC5E57B1-4520-4672-B4BA-A288EC42946E}, 0, 90, 90), (null)
2004-04-02 13:34:32.626 [INFO] [MT] [CTaskAnalyzeClusterBase] Exiting task. The task was not cancelled.
SQL1 is the Windows 2003 box newly installed and SQL2 is the old Windows 2000 box.
Can anyone see anything wrong?
Thanks in advance.
Paul
My Cluster Service does not want to start on SQL1. Event Viewer says:
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7031
Date:4/2/2004
Time:1:39:12 PM
User:N/A
Computer:SQL1
Description:
The Cluster Service service terminated unexpectedly. It has done this 4 time(s). The following corrective action will be taken in 480000
milliseconds: Restart the service.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
What do you suggest?
Paul
|||Paul,
As the log indicates try adding the new node (SQL1) after cleaning it up
using the "cluster node /forcecleanup" command.
2004-04-02 13:34:29.061 [WARN] sql1: This node is already a member of a
cluster, but the cluster service is not running. This node will not
be configured at this time. (hr=0x000001,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{8028BF97-2D57-4628-845D-C4BEFFEB531A}, 1, 1, 1), The
cluster service on this node is configured but is not currently running.
This node will be skipped and no further tasks will be performed on
it. If this node is not supposed to be a member of any cluster, then clean
it up using the "cluster node /forcecleanup" command and try
again.
Hope this helps.
Regards,
Shon Shah
Software Test Engineer
Microsoft Cluster Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples, if any, are subject to the terms specified
at http://www.microsoft.com/info/cpyright.htm
"Paul Dube" <pdube@.clic.net> wrote in message
news:4dcr6016mhj94s2cvet4hqhjvblhgf72fp@.4ax.com...
> I have a Windows 2000 that crashed and was part of a active/active SQL
cluster (SQL 2000).
> Instead of reinstall the box with Windows 2000, I reinstalled it with
Windows 2003 Advanced.
> In Cluster Administrator (on the Windows 2003 box), I am trying to add the
node, and I always get the following error:
> - sql1: The list of nodes to configure is empty.
> - Error 0x800713ac: A cluster node is not available for this operation.
> here's the content of the log:
> 2004-04-02 13:34:10.084 [INFO] [CConnPointEnum::HrAddConnection] punk
0x0cd808 added to the connection point enumerator. (hr=00000000)
> 2004-04-02 13:34:10.214 [INFO] [CConnPointEnum::HrAddConnection] punk
0x0ce2f8 added to the connection point enumerator. (hr=00000000)
> 2004-04-02 13:34:25.195 [INFO] [WIZ] Setting analyze page active. Setting
aborted to FALSE.
> 2004-04-02 13:34:25.336 [INFO] [MT] [CTaskAnalyzeClusterBase] Beginning
task...
> 2004-04-02 13:34:25.446 [INFO] CLUSTER2: Checking for an existing
cluster... (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
> {B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 0), (null)
> 2004-04-02 13:34:25.556 [INFO] [CTaskAnalyzeClusterBase] Setting
completion cookie 4 at array index 0 into the gather cluster information
> task for node CLUSTER2.shop.clic.net
> 2004-04-02 13:34:25.656 [INFO] [MT] The name to connect to is 'CLUSTER2'.
> 2004-04-02 13:34:25.736 [INFO] [MT] Requesting a remote connection to
'CLUSTER2'.
> 2004-04-02 13:34:25.846 [INFO] CLUSTER2: The DNS record for
"CLUSTER2.shop.clic.net" is "192.168.0.233". (hr=00000000,
> {B8453B8F-92FD-4350-A6D9-551FD018B791},
{D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
> 2004-04-02 13:34:25.937 [INFO] sql1: Requesting a remote connection to
"CLUSTER2" in domain "shop.clic.net" with binding string
> "192.168.0.233" (hr=00000000, {B8453B8F-92FD-4350-A6D9-551FD018B791},
{26015CA7-EAE1-43F4-AC1E-718D80629E93}, 1, 1, 1), (null)
> 2004-04-02 13:34:26.067 [INFO] [MT] Connection to 'CLUSTER2' with binding
string '192.168.0.233' failed because one or more classes are not
> registered.
> 2004-04-02 13:34:26.187 [INFO] CLUSTER2: The DNS record for
"CLUSTER2.shop.clic.net" is "192.168.0.233". (hr=00000000,
> {B8453B8F-92FD-4350-A6D9-551FD018B791},
{D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
> 2004-04-02 13:34:26.427 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for
the completion cookie 1.
> 2004-04-02 13:34:26.537 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for
the completion cookie 4.
> 2004-04-02 13:34:26.628 [INFO] [CTaskAnalyzeClusterBase] Clearing
completion cookie 4 at array index 0
> 2004-04-02 13:34:26.658 [INFO] CLUSTER2: (null) (hr=00000000,
{FDC75680-7DBB-42CA-8003-E4CDB01FF062},
> {B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 1), (null)
> 2004-04-02 13:34:26.718 [INFO] [MT] [CTaskGatherClusterInfo] exiting task.
The task was not cancelled.
> 2004-04-02 13:34:26.808 [INFO] CLUSTER2: (null) (hr=00000000,
{FDC75680-7DBB-42CA-8003-E4CDB01FF062},
> {B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 2), (null)
> 2004-04-02 13:34:26.988 [INFO] [MT] Adding node 'SQL1.shop.clic.net' to
the list of user-added nodes.
> 2004-04-02 13:34:27.128 [INFO] CLUSTER2: Collecting nodes currently in the
cluster... (hr=00000000, {EBC8AEFF-10C3-4D5B-AC17-FC0F4C3871B7},
> {72A04E74-2D14-4AD8-8E12-4AFBA56FD0E0}, 0, 1, 0), (null)
> 2004-04-02 13:34:27.389 [INFO] [MT] Connecting to cluster node
'SQL2.shop.clic.net'
> 2004-04-02 13:34:27.519 [INFO] CLUSTER2: Collecting nodes currently in the
cluster... (hr=00000000, {EBC8AEFF-10C3-4D5B-AC17-FC0F4C3871B7},
> {72A04E74-2D14-4AD8-8E12-4AFBA56FD0E0}, 0, 1, 1), (null)
> 2004-04-02 13:34:27.649 [INFO] CLUSTER2: (null) (hr=00000000,
{FDC75680-7DBB-42CA-8003-E4CDB01FF062},
> {B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 90), (null)
> 2004-04-02 13:34:27.789 [INFO] sql1: (null) (hr=00000000,
{FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, 0,
> 90, 0), (null)
> 2004-04-02 13:34:27.919 [INFO] CLUSTER2: (null) (hr=00000000,
{FDC75680-7DBB-42CA-8003-E4CDB01FF062},
> {CC5E57B1-4520-4672-B4BA-A288EC42946E}, 0, 90, 0), (null)
> 2004-04-02 13:34:28.050 [INFO] [CTaskAnalyzeClusterBase] Setting
completion cookie 6 at array index 0 into the gather node information task
> for node SQL1.shop.clic.net
> 2004-04-02 13:34:28.190 [INFO] [CTaskAnalyzeClusterBase] Setting
completion cookie 7 at array index 1 into the gather node information task
> for node SQL2.shop.clic.net
> 2004-04-02 13:34:28.190 [INFO] SQL1: Connecting to server... (hr=00000000,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
> {E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0, 1, 0), (null)
> 2004-04-02 13:34:28.320 [INFO] SQL2: Connecting to server... (hr=00000000,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
> {E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0, 1, 0), (null)
> 2004-04-02 13:34:28.460 [INFO] [MT] The name to connect to is 'SQL1'.
> 2004-04-02 13:34:28.590 [INFO] [MT] The name to connect to is 'SQL2'.
> 2004-04-02 13:34:28.721 [INFO] [MT] Requesting a local connection to
'SQL1'.
> 2004-04-02 13:34:28.851 [INFO] [MT] Requesting a remote connection to
'SQL2'.
> 2004-04-02 13:34:29.061 [WARN] sql1: This node is already a member of a
cluster, but the cluster service is not running. This node will not
> be configured at this time. (hr=0x000001,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{8028BF97-2D57-4628-845D-C4BEFFEB531A}, 1, 1, 1), The
> cluster service on this node is configured but is not currently running.
This node will be skipped and no further tasks will be performed on
> it. If this node is not supposed to be a member of any cluster, then clean
it up using the "cluster node /forcecleanup" command and try
> again.
> 2004-04-02 13:34:29.131 [INFO] SQL2: The DNS record for
"SQL2.shop.clic.net" is "192.168.0.242". (hr=00000000,
> {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
> 2004-04-02 13:34:29.271 [WARN] sql1: This node is already a member of a
cluster, but the cluster service is not running. This node will not
> be configured at this time. (hr=0x000001,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{8028BF97-2D57-4628-845D-C4BEFFEB531A}, 1, 1, 1), The
> cluster service on this node is configured but is not currently running.
This node will be skipped and no further tasks will be performed on
> it. If this node is not supposed to be a member of any cluster, then clean
it up using the "cluster node /forcecleanup" command and try
> again.
> 2004-04-02 13:34:29.402 [INFO] sql1: Requesting remote connections...
(hr=00000000, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
> {1B606398-7193-4A48-AFBD-98AC8BACB690}, 1, 1, 1), (null)
> 2004-04-02 13:34:29.542 [INFO] [SRV] The cluster service is down on this
node.
> 2004-04-02 13:34:29.672 [INFO] sql1: Requesting a remote connection to
"SQL2" in domain "shop.clic.net" with binding string "192.168.0.242"
> (hr=00000000, {1B606398-7193-4A48-AFBD-98AC8BACB690},
{7DCE2976-3E89-4683-8980-B41130CBABD9}, 1, 1, 1), (null)
> 2004-04-02 13:34:29.812 [INFO] [SRV] CClusCfgClusterInfo::Initialize()
returning (hr=0x0713ba)
> 2004-04-02 13:34:29.962 [INFO] [MT] Connection to 'SQL2' with binding
string '192.168.0.242' failed because one or more classes are not
> registered.
> 2004-04-02 13:34:30.093 [WARN] sql1: GetClusterConfigInfo() completed.
(hr=0x0713ba, {05AA0768-5F49-49CD-AFDC-96F9D51802D4},
> {B460EA73-6223-44FA-84E0-DE7EC069DDD4}, 1, 1, 1), (null)
> 2004-04-02 13:34:30.253 [INFO] SQL2: The DNS record for
"SQL2.shop.clic.net" is "192.168.0.242". (hr=00000000,
> {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
> 2004-04-02 13:34:30.403 [WARN] sql1: The cluster configuration server has
been started. (hr=0x0713ba,
> {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{39371CBA-A47B-4A4F-9042-6BECD321E9E2}, 1, 1, 1), (null)
> 2004-04-02 13:34:30.613 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for
the completion cookie 5.
> 2004-04-02 13:34:30.663 [WARN] sql1: The cluster configuration server has
been started. (hr=0x0713ba,
> {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{39371CBA-A47B-4A4F-9042-6BECD321E9E2}, 1, 1, 1), (null)
> 2004-04-02 13:34:30.804 [INFO] SQL2: (null) (hr=00000000,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0,
> 1, 1), (null)
> 2004-04-02 13:34:30.964 [INFO] [MT] The cluster service on node 'SQL1' is
down.
> 2004-04-02 13:34:31.084 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for
the completion cookie 7.
> 2004-04-02 13:34:31.244 [WARN] SQL1: (null) (hr=0x0713ba,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0,
> 1, 1), (null)
> 2004-04-02 13:34:31.414 [INFO] [CTaskAnalyzeClusterBase] Clearing
completion cookie 7 at array index 1
> 2004-04-02 13:34:31.545 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for
the completion cookie 6.
> 2004-04-02 13:34:31.675 [INFO] [MT] [CTaskGatherNodeInfo] exiting task.
The task was not cancelled.
> 2004-04-02 13:34:31.805 [INFO] [CTaskAnalyzeClusterBase] Clearing
completion cookie 6 at array index 0
> 2004-04-02 13:34:32.075 [INFO] sql1: (null) (hr=00000000,
{FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, 0,
> 90, 1), (null)
> 2004-04-02 13:34:32.075 [INFO] [MT] [CTaskGatherNodeInfo] exiting task.
The task was not cancelled.
> 2004-04-02 13:34:32.216 [ERR ] sql1: The list of nodes to configure is
empty. (hr=0x800713ac, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
> {A678963B-9173-4393-B21B-0B4337B28EE2}, 1, 1, 1), (null)
> 2004-04-02 13:34:32.486 [INFO] CLUSTER2: (null) (hr=00000000,
{FDC75680-7DBB-42CA-8003-E4CDB01FF062},
> {CC5E57B1-4520-4672-B4BA-A288EC42946E}, 0, 90, 90), (null)
> 2004-04-02 13:34:32.626 [INFO] [MT] [CTaskAnalyzeClusterBase] Exiting
task. The task was not cancelled.
> SQL1 is the Windows 2003 box newly installed and SQL2 is the old Windows
2000 box.
> Can anyone see anything wrong?
> Thanks in advance.
> Paul
|||Great! It works 8-).
Thanks!
Paul
On Fri, 2 Apr 2004 10:48:52 -0800, "Shon Shah [MSFT]" <shonsh@.online.microsoft.com> wrote:

>Paul,
>As the log indicates try adding the new node (SQL1) after cleaning it up
>using the "cluster node /forcecleanup" command.
>2004-04-02 13:34:29.061 [WARN] sql1: This node is already a member of a
>cluster, but the cluster service is not running. This node will not
>be configured at this time. (hr=0x000001,
>{93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
>{8028BF97-2D57-4628-845D-C4BEFFEB531A}, 1, 1, 1), The
>cluster service on this node is configured but is not currently running.
>This node will be skipped and no further tasks will be performed on
>it. If this node is not supposed to be a member of any cluster, then clean
>it up using the "cluster node /forcecleanup" command and try
>again.
>Hope this helps.
|||You must evict the node from the cluster before joining it
back in.
HTH
Bjorn
>--Original Message--
>My Cluster Service does not want to start on SQL1. Event
Viewer says:
>Event Type:Error
>Event Source:Service Control Manager
>Event Category:None
>Event ID:7031
>Date:4/2/2004
>Time:1:39:12 PM
>User:N/A
>Computer:SQL1
>Description:
>The Cluster Service service terminated unexpectedly. It
has done this 4 time(s). The following corrective action
will be taken in 480000
>milliseconds: Restart the service.
>For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
>
>What do you suggest?
>Paul
>.
>

Installing a Second Instance

Hi,
I'm trying to install a 2nd instance on a cluster.
We've setup two cluster groups C101TC001 and C101TC002, one for each instance.
I've stopped all the services and managed to get the installation to run,
but it won't allow me to apply the Service Pack (3a).
It reports an error
An error has occurred while creating virtual resources for clustering. Can
not create a file when that file already exists.
This then invalidates the instance.
Can anyone assist?
Thanks
Bev
After this I'm unable to get the instance registered or even started.
The error message that you got can be due to various reasons. Here is one Microsoft Knowledge base articles that has the same error (but as I said you may be having a
different issue)
BUG: The Setup program of SQL Server 2000 Service Pack 2 or a later version may stop responding in a Windows clustering environment if there is an offline database
http://support.microsoft.com/default...B;EN-US;320524
This KB says the cause is "This problem occurs because Setup program cannot access the database.
During installation in a Windows Clustering environment, Setup program must query the user databases to make sure that all the database files are on disk resources that
have the correct dependencies and the virtual SQL Server resource. The virtual SQL Server resource is required for the failover support. When a database is offline, Setup
program cannot access the database. "
I understand you are installing SP3a and the above KB is for SP2 but one can still get similar error message.
You last point stated that "After this I'm unable to get the instance registered or even started." I think you will need to first concentrate on why this instance is not starting.
Anyways to be able to apply SP3a, the sql instance needs to be running. So, need to troubleshoot why this instance is not coming online. See what errors you get when
you try to being this SQL Server resource online. Try starting it from command promt and see if that works outside the cluster. The errors in SQL Errorlog, NT App, System
logs and cluster.log should be helpful to troubleshoot this further.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
sql

Installing a Named SQL Instance

I am migrating a SQL Instance to an existing SQL 2000 cluster that already
has the default instance installed. There is a large user community that
will be accessing the databases in the 2nd instance and I am trying to find a
way to configure the installation so that they can continue to use the same
ODBC connections. Today, they are configured using a single name (such as
RAVEN). Is it possible to configure the 2nd instance using this single name?
Thanks in advance.
You should be able to create a DNS SRV record to point to the named
instance.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:9FC76909-7CB6-48E2-A5E5-236F7665A150@.microsoft.com...
I am migrating a SQL Instance to an existing SQL 2000 cluster that already
has the default instance installed. There is a large user community that
will be accessing the databases in the 2nd instance and I am trying to find
a
way to configure the installation so that they can continue to use the same
ODBC connections. Today, they are configured using a single name (such as
RAVEN). Is it possible to configure the 2nd instance using this single
name?
Thanks in advance.
|||I remember doing this on a migration, and i had issues with some clients
trying to access using the new DNS record, it ws solved applying MDAC 2.8.
I hope you don't run in this error but try to check this is you experience
any problem.
"Tom Moreau" wrote:

> You should be able to create a DNS SRV record to point to the named
> instance.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Brian" <Brian@.discussions.microsoft.com> wrote in message
> news:9FC76909-7CB6-48E2-A5E5-236F7665A150@.microsoft.com...
> I am migrating a SQL Instance to an existing SQL 2000 cluster that already
> has the default instance installed. There is a large user community that
> will be accessing the databases in the 2nd instance and I am trying to find
> a
> way to configure the installation so that they can continue to use the same
> ODBC connections. Today, they are configured using a single name (such as
> RAVEN). Is it possible to configure the 2nd instance using this single
> name?
> Thanks in advance.
>
|||I assumed he was using current MDAC, but that's a good point.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Frivas" <Frivas@.discussions.microsoft.com> wrote in message
news:3DFCE095-1AD3-42E5-B97B-D38570E13B8D@.microsoft.com...
I remember doing this on a migration, and i had issues with some clients
trying to access using the new DNS record, it ws solved applying MDAC 2.8.
I hope you don't run in this error but try to check this is you experience
any problem.
"Tom Moreau" wrote:

> You should be able to create a DNS SRV record to point to the named
> instance.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Brian" <Brian@.discussions.microsoft.com> wrote in message
> news:9FC76909-7CB6-48E2-A5E5-236F7665A150@.microsoft.com...
> I am migrating a SQL Instance to an existing SQL 2000 cluster that already
> has the default instance installed. There is a large user community that
> will be accessing the databases in the 2nd instance and I am trying to
> find
> a
> way to configure the installation so that they can continue to use the
> same
> ODBC connections. Today, they are configured using a single name (such as
> RAVEN). Is it possible to configure the 2nd instance using this single
> name?
> Thanks in advance.
>
|||Named Instance support was introduced in MDAC 2.6. If you have to use an
earlier MDAC stack, you must alias the named instance using the client
network utility on each client.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Frivas" <Frivas@.discussions.microsoft.com> wrote in message
news:3DFCE095-1AD3-42E5-B97B-D38570E13B8D@.microsoft.com...[vbcol=seagreen]
>I remember doing this on a migration, and i had issues with some clients
> trying to access using the new DNS record, it ws solved applying MDAC 2.8.
> I hope you don't run in this error but try to check this is you experience
> any problem.
> "Tom Moreau" wrote:

Installing a local instance of SQL on a Cluster Node

Hi
I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.
I would like to install a local copy of SQL Server on the node that is
currently passive - if I start the SQL install process, it does give me
this option but I don't know what, if any, problems this might cause.
I appreciate if the currently active node fails, it will failover to
the node which also has a local version running as well.
Has anyone done this? I've tried searching groups and Microsoft without
success.
Thanks
Toby
It's OK to install local instances on cluster nodes. Just make sure the
instance name does not conflict with any instance on the cluster.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
<tjbeaumont@.gmail.com> wrote in message
news:1160036955.164570.322690@.i3g2000cwc.googlegro ups.com...
Hi
I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.
I would like to install a local copy of SQL Server on the node that is
currently passive - if I start the SQL install process, it does give me
this option but I don't know what, if any, problems this might cause.
I appreciate if the currently active node fails, it will failover to
the node which also has a local version running as well.
Has anyone done this? I've tried searching groups and Microsoft without
success.
Thanks
Toby
|||<tjbeaumont@.gmail.com> wrote in message
news:1160036955.164570.322690@.i3g2000cwc.googlegro ups.com...
> Hi
> I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.
> I would like to install a local copy of SQL Server on the node that is
> currently passive - if I start the SQL install process, it does give me
> this option but I don't know what, if any, problems this might cause.
Yes, you can do it, but it is a violation of the HA spirit. Meaning, why in
the world would you want to screw around and do that when the company has
obviously felt that the other SQL instances (in the cluster) require HA?
Don't mess with the HA environment!
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
|||That's true for production clusters. But we install standalone SQL instances
on a clustered node all the time on our test clusters.
Linchi
"Russ Kaufmann" wrote:

> <tjbeaumont@.gmail.com> wrote in message
> news:1160036955.164570.322690@.i3g2000cwc.googlegro ups.com...
> Yes, you can do it, but it is a violation of the HA spirit. Meaning, why in
> the world would you want to screw around and do that when the company has
> obviously felt that the other SQL instances (in the cluster) require HA?
> Don't mess with the HA environment!
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
>
>
|||"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:6B70403B-35CF-4773-9160-8FFC9DDC8638@.microsoft.com...
> That's true for production clusters. But we install standalone SQL
> instances
> on a clustered node all the time on our test clusters.
So, your test environment doesn't mirror production?
Actually, I can see doing that.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

Installing A Failover Cluster

I have two matched servers, one will be Active and one will be Passive.
The servers have Windows 2000 Advanced Server and I have SQL Server 2000
Enterprise Edition.
My question is, do I also need a box called a Shared Disk Array, or can I
use another server I currently have that has lots of disk space on it?
Correction: I have Windows 2000 Advanced Server
"Vincel2k2" wrote:

> I have two matched servers, one will be Active and one will be Passive.
> The servers have Windows 2000 Advanced Server and I have SQL Server 2000
> Enterprise Edition.
> My question is, do I also need a box called a Shared Disk Array, or can I
> use another server I currently have that has lots of disk space on it?
>
|||You will indeed need shared storage.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Vincel2k2" <Vincel2k2@.discussions.microsoft.com> wrote in message
news:FF446D59-A73C-43EA-9EC2-4B9D03CFD51B@.microsoft.com...[vbcol=seagreen]
> Correction: I have Windows 2000 Advanced Server
> "Vincel2k2" wrote:
|||Hi
You need to get your self a Storage Area Network (SAN) to store your data
on.
For clustering, make sure that your hardware is on the Windows Hardware
Compatibility List (HCL)
Read the documentation on
http://www.microsoft.com/windowsserv...g/default.mspx
to get an understanding.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Vincel2k2" <Vincel2k2@.discussions.microsoft.com> wrote in message
news:FF446D59-A73C-43EA-9EC2-4B9D03CFD51B@.microsoft.com...[vbcol=seagreen]
> Correction: I have Windows 2000 Advanced Server
> "Vincel2k2" wrote:
I[vbcol=seagreen]
|||I also have two matched servers with Win2003EntSrv that I would like to
install an active/passive failover cluster of Yukon on. Since this is a lab
environment and I don't have the $$ for a SAN, will it work with a Network
Storage HD? I realize the performance won't be great, but I'm looking for
the experience in how to build/configure the environment.
Any tips?
An alternative question for the lab environment is ... how would you do this
in two VPC? Or would you steer clear?
Thanks
Al
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> You need to get your self a Storage Area Network (SAN) to store your data
> on.
> For clustering, make sure that your hardware is on the Windows Hardware
> Compatibility List (HCL)
> Read the documentation on
> http://www.microsoft.com/windowsserv...g/default.mspx
> to get an understanding.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Vincel2k2" <Vincel2k2@.discussions.microsoft.com> wrote in message
> news:FF446D59-A73C-43EA-9EC2-4B9D03CFD51B@.microsoft.com...
> I
>
>
|||Virtual Server 2005 will work nicely for this test. See
http://www.hands-on-labs.com/microsoft.asp?ID=4477 for the steps
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"al_stark_born" <al_stark_born@.discussions.microsoft.com> wrote in message
news:E579B181-45E6-4DF2-8BCA-E7F1D2DD44C7@.microsoft.com...[vbcol=seagreen]
>I also have two matched servers with Win2003EntSrv that I would like to
> install an active/passive failover cluster of Yukon on. Since this is a
> lab
> environment and I don't have the $$ for a SAN, will it work with a Network
> Storage HD? I realize the performance won't be great, but I'm looking for
> the experience in how to build/configure the environment.
> Any tips?
> An alternative question for the lab environment is ... how would you do
> this
> in two VPC? Or would you steer clear?
> Thanks
> Al
> "Mike Epprecht (SQL MVP)" wrote:
sql

Installing a cluster on an existing instance of SQL 2000 SP3A

I have been "tapped" to install a passive node on an instance of SQL
that is not currently configured for clustering on a W2003. Can I
simply install clustering services on the current production instance,
then install a new instance on what would be the passive node? Then add
it via cluster admin?
Can I run cluster communications, heartbeat, etc on the public NICs..I
do not have two interfaces on each server.
Any information would be greatly appreciated as I have only done new
deployments and this being a prod server I do not want to try the trial
and error approach.
Thanks,
Hulicat
You can use the current active node as a cluster member. You can then
install a clustered instance of SQL and migrate the databases. The final
step is to turn off the original instance. Possible, Yes. Recommended, NO.
This entire project sounds like a low-availability solution. You are
reusing equipment instead of purchasing a certified cluster configuration.
The one-NIC cluster is possible but falls into the "worst practices"
category. Not having a test platform, even a virtual one, is asking for
even more trouble.
Clustering is a hardware and systems tool to help achieve increased system
availability. Shortcutting the hardware and the procedures will result in
lower availability rather than higher availability.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Hulicat" <dennis_A_white@.yahoo.com> wrote in message
news:1162242129.910915.61910@.e3g2000cwe.googlegrou ps.com...
>I have been "tapped" to install a passive node on an instance of SQL
> that is not currently configured for clustering on a W2003. Can I
> simply install clustering services on the current production instance,
> then install a new instance on what would be the passive node? Then add
> it via cluster admin?
> Can I run cluster communications, heartbeat, etc on the public NICs..I
> do not have two interfaces on each server.
> Any information would be greatly appreciated as I have only done new
> deployments and this being a prod server I do not want to try the trial
> and error approach.
> Thanks,
> Hulicat
>
|||Thanks for that!
I am going tp lobby for new hardware or scratch the idea.
It's a small SPS portal.
Regards~~~
Geoff N. Hiten wrote:[vbcol=seagreen]
> You can use the current active node as a cluster member. You can then
> install a clustered instance of SQL and migrate the databases. The final
> step is to turn off the original instance. Possible, Yes. Recommended, NO.
> This entire project sounds like a low-availability solution. You are
> reusing equipment instead of purchasing a certified cluster configuration.
> The one-NIC cluster is possible but falls into the "worst practices"
> category. Not having a test platform, even a virtual one, is asking for
> even more trouble.
> Clustering is a hardware and systems tool to help achieve increased system
> availability. Shortcutting the hardware and the procedures will result in
> lower availability rather than higher availability.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Hulicat" <dennis_A_white@.yahoo.com> wrote in message
> news:1162242129.910915.61910@.e3g2000cwe.googlegrou ps.com...

Installation SQL-Cluster failed

Hi,
we are trying to install "SQL-Server Version 8.00.780 SP3" on a Win2003
2-node Cluster. The Installation breaks, and in the sqlstp.log we find the
Message "remsetup.exe not find". In the Knowledge Base we find problems with
Terminal Service (no TS installed) and with special character in connection
names (the names are public and private). We have log in as a domain admin
and the sql engine and the agent are started with a domain admin.
1.copyexe=cnvsvc1.exe
08:28:41 Setup is performing required operations on cluster nodes. This may
take a few minutes...
08:28:41 C:\WINDOWS\TEMP\SqlSetup\Bin\remsetup.exe C:\WINDOWS\remsetup.ini
08:30:14 Process Exit Code: (2) The system cannot find the file specified.
08:30:14 Begin Action : GetRemsetupRetCode
08:30:14 Installation return status on OBELIX : 2
08:30:14 End Action : GetRemsetupRetCode
#### SQL Server Remote Setup - Start Time 05/14/04 08:28:41 ####
CThreadPool::RunUntilCompleteHlpr create thread, index=0
CThread::Run thread [0x74] created for execution.
CThread::Process [0x74]
CThreadPool::RunUntilCompleteHlpr start thread [0x74],index=0
Script file copied to '\\OBELIX\ADMIN$\OBELIX_MSSQLSERVER.iss' successfully.
Installing remote service (OBELIX)...
Running '\\ASTERIX\Z$\x86\setup\setupsql.exe k=ClSec k=Rm k=Cl -SMS -s -f
"\\ASTERIX\Z$\x86\setup\setup.ins" -f1
\\OBELIX\ADMIN$\OBELIX_MSSQLSERVER.iss -f2 "\\OBELIX\admin$\setup.log" -e
"stpsilnt._ex" -x "C:\"' (OBELIX) ...
CRemoteProcess::RunUntilComplete [0x74] exit code: 2
Remote process exit code was '2' (OBELIX).
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0x74]
Thread [0x74] exit code: [0x2]
CThreadPool::RunUntilComplete returned 2
CThreadPool::RunUntilComplete execution level=1, need execution: 0
One or more errors occurred while running the remote/unattended setups.
Disconnecting from remote machine (OBELIX)...
Service removed successfully.
Remote files removed successfully.
#### SQL Server Remote Setup - Stop Time 05/14/04 08:30:14 ####
08:30:14 End Action : Run setup on cluster nodes
08:30:14 One or more errors occurred while running remote setup on the
clustered machines.
08:30:28 Setup failed to perform required operations on the cluster nodes.
08:30:28 Begin Action : ClusterErrorCleanup
08:30:28 End Action : ClusterErrorCleanup
08:30:28 End Action : ClusterSetupHelper
Thank you for help.
Sound to me like your MS cluster isn't installed correctly.
Have you carried out the tests suggested in the Cluster checklist?
If you are happy with the installation try copying the remsetup.ini file from the user dir as mentioned in KB301520.
|||Try these steps to see if you can resolve the problem:
1) Check and see if the machine is configured to disallow 8.3 name creation
by
checking the following registry key:
HKLM\SYSTEM\CURRENTCONTROLSET\CONTROL\FileSystem\N tfsDisable8dot3NameCreatio
n
A value of 1 means this is disabled and hence change it back to 0. This
requires a
reboot for it to take effect
OR
2) Change the TEMP and TMP User Environment Variables to a path that does
not have
spaces in them. For example: c:\temp. Use the SET command to verify the new
TEMP
location is in effect. This does not require a reboot
Rand
This posting is provided "as is" with no warranties and confers no rights.

Installation SQL Server 2k Cluster on Windows 2003 failed. Please help.

Hello group,
today we tried to install a SQL 2k cluster very unsuccessfully. Would
need your support.
What we have:
2 Server (node 1, node 2) with external storage installed as a cluster
(MSCS). Partitions are C (for node 1 and 2), e and q (quorum db) - both
on the external storage.
OS is Windows 2003 Enterprise
We copied the installfiles to C:\temp on node1 and made a share. Node2
can access this share.
Antivirus was disabled.
We started the installation with a domainaccount that has local
administrative rights on both nodes and can be started as a service.
As installation target for the program we chosed C:... and the data
should be stored on e:...
Installation started - we gave the virtual server a different name than
the cluster and a free ip adress. Both nodes were seen during the next
steps and we gave an instancename like "DECGNWSSQL20007". Licensing was
choosen as 2CPU.
When the server should start the installation, it immediately stopped
with the message: Setup failed to perform required operations on the
cluster nodes.
We don=B4t have any clue how to continue. Could need your help.
Thanks in advance
Stefan
The error message "Setup failed to perform required operations on the cluster nodes." is a generic message. To understand where the setup failed, one has to review the sqlstp.log (search for this on the node
where you ran the setup). Based on this file, you will know where the error occurred and then accordingly you may need to review additional logs like sqlstpN.log (where N is an integer) on one/both nodes,
sqlclstr.log, cluster.log.
For detailed information on troubleshooting setup failures on cluster, please review
Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
http://support.microsoft.com/default...lurb020703.asp
The above webcast may not give you the solution but will give you steps that you can use to troubleshoot and find the solution using Microsoft Knowledge Base articles.
Also, make sure that you have all the pre-reqs of installing SQL 2K on Win2K3. A list of pre-reqs and other related info can be found at
TechNet Support WebCast: How to install a Microsoft SQL Server 2000 virtual server on a Microsoft Windows Server 2003 cluster
Discusses how to install Microsoft SQL Server 2000 clustering on Microsoft Windows Server 2003 and differences between Microsoft Windows 2000 Server and Windows Server 2003.
http://support.microsoft.com/default...b;en-us;888121
If you need more help, feel free to post your questions.
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Hi,
what IU inbetween found out is that the installed Terminal Server caused
the problems. Now the installation starts fine, runs and finishes with
the message that the "Virtual server cannot go online". Then the
uninstall started automatically. Do you know more about this problem? Is
it why we try to install SP2 first and then to update to SP3?
Thanks in advance
Stefan
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||You cannot run a SQL Cluster and Terminal Server on the same system.
SQL Server 2000 cluster does not install on Windows Server 2003-based
computers where Terminal Services is installed
http://support.microsoft.com/default...b;en-us;301520
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Stefan Gsundbrunn" <info@.gsundbrunn.de> wrote in message
news:uPYXood7EHA.1408@.TK2MSFTNGP10.phx.gbl...
> Hi,
> what IU inbetween found out is that the installed Terminal Server caused
> the problems. Now the installation starts fine, runs and finishes with
> the message that the "Virtual server cannot go online". Then the
> uninstall started automatically. Do you know more about this problem? Is
> it why we try to install SP2 first and then to update to SP3?
> Thanks in advance
> Stefan
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Hi,

> You cannot run a SQL Cluster and Terminal Server on the same system.
Yes, as mentioned I deinstalled Terminal Server and then the installation
started. But: At the end of the installation the message appeared like
"Virtual server cannot go online" and automatically the desintallation
starts. I don′t have any clue for the reason. Does anybody know how to fix?
Thanks in advance!
Stefan

> SQL Server 2000 cluster does not install on Windows Server 2003-based
> computers where Terminal Services is installed
> http://support.microsoft.com/default...b;en-us;301520
>
--
Stefan Gsundbrunn
Project Design - Software Design - Brain Design
http://www.gsundbrunn.de
Cell: +49.173.3426906
|||Stefan,
Looks like the unattended installation on all cluster nodes succeeded and failed during the virtual resources creation step. Ofcourse check sqlstp.log to find out where exactly the issue is. If indeed it failed during the
virtual server resources section then you will need to review sqlclstr.log and cluster.log to get to the root cause.
Additional Information
=====================
TechNet Support WebCast:
Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
http://support.microsoft.com/default...lurb020703.asp
How to install a Microsoft SQL Server 2000 virtual server on a Microsoft Windows Server 2003 cluster
Discusses how to install Microsoft SQL Server 2000 clustering on Microsoft Windows Server 2003 and differences between Microsoft Windows 2000 Server and Windows Server 2003.
http://support.microsoft.com/default...b;en-us;888121
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Installation Reporting services on SQL fail-over cluster

Hi,
Perhaps a simple question, but I could not find a clear answer in the
deployment guide. I want to install SQL Reporting Services on a SQL fail over
cluster to be used for MOM Reporting. I was wondering where to run the set up
for SRS. Do I run it on the Virtual server or on one (or both) of the nodes?
Does anyone know?
Regards, MartijnIt is best practice to run SQL Server or RS on the CLuster node. In Any case
once you go to the virtual server, you will be directed to the "Physical
Node" that owns the cluster resources. Always use the Virtual Server name to
do anything for RS or SQL Server.
"Martijn" wrote:
> Hi,
> Perhaps a simple question, but I could not find a clear answer in the
> deployment guide. I want to install SQL Reporting Services on a SQL fail over
> cluster to be used for MOM Reporting. I was wondering where to run the set up
> for SRS. Do I run it on the Virtual server or on one (or both) of the nodes?
> Does anyone know?
> Regards, Martijn

Installation of SQL sp3a on Windows 2003 ent Failover Clustering

Platform: Windows 2003 ent failover cluster SQL Server 2k ent
We did installation of SQL Server 2k ent successfully. We are using Mixed
mode which allow both NT and SQL authentication. We assigned sa password. We
are able to start/stop/start SQL servrices. We are able to failover to
another node on SQL server. Right after completed SQL Server 2k ent
installation, we started to apply SP3a. But we got error in middle of serivce
pack: Setup was unable to verify the state of the server for an upgrade.
Verify the server is able to start and that you provide a valid sa password
and restart setup. We followed the instruction on article ID 330022 and
readme come with CD but it still doesn't work.
I also referenced the article http://support.microsoft.com/?id=814844 but
they are not really applied to our case. Our platform is on WINDOWS 2003.
We are implementing Failover Clustering. Our MDAC is 2.8 version above. We
didn't have any problem to install sql sp3a on any other win2k or win2k3 ent
platform. Only this time is Windows 2003 ent FAILOVER CLUSTERING.
Look at
PRB: Installation of a named instance of SQL Server 2000 virtual server on a
Windows 2003-based cluster fails
http://support.microsoft.com/default...b;en-us;815431
The aliases have to stay in place until SP3a is complete.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:4CDB4730-44F5-4EFC-9F5F-030CAF9A9101@.microsoft.com...
> Platform: Windows 2003 ent failover cluster SQL Server 2k ent
> We did installation of SQL Server 2k ent successfully. We are using Mixed
> mode which allow both NT and SQL authentication. We assigned sa password.
We
> are able to start/stop/start SQL servrices. We are able to failover to
> another node on SQL server. Right after completed SQL Server 2k ent
> installation, we started to apply SP3a. But we got error in middle of
serivce
> pack: Setup was unable to verify the state of the server for an upgrade.
> Verify the server is able to start and that you provide a valid sa
password
> and restart setup. We followed the instruction on article ID 330022 and
> readme come with CD but it still doesn't work.
> I also referenced the article http://support.microsoft.com/?id=814844 but
> they are not really applied to our case. Our platform is on WINDOWS 2003.
> We are implementing Failover Clustering. Our MDAC is 2.8 version above.
We
> didn't have any problem to install sql sp3a on any other win2k or win2k3
ent
> platform. Only this time is Windows 2003 ent FAILOVER CLUSTERING.
>

Installation of Multiple named instances in Cluster environment

Hi All..

We are planning to build a cluster environment on MS SQL 2005. We want to install multiple named instances in a single database server and use cluster for that database server.

Is this option possible ? Any relevant documentation would be helpful

Thanks in advance

Regards

Madhav

Yes, you can install multiple instances of SQL Server into a cluster. All of the relevant information can be found in Books Online.|||

here is some supplemental information to Books Online that was recently published:

SQL Server Failover Clustering White Paper
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en

Installation error the parameter is incorrect

We are attempting to install a cluster for further SAP installation. I have
read the following article:
http://support.microsoft.com/default...b;en-us;302491
I get this exact error message but (as far as I can tell) I have no invalid
characters. The ipAddresses string = 10.10.0.18,255.0.0.0,Public
Can anyone help (I'm a bit baffled at the moment!)
Thanks
I have now worked out what the problem is. There is another cluster with
"Public" defined. Have changed this to something else and it now works.

Installation Error - Need some Help

Hello All:
Had a working SQL cluster but we had to uninstall SQL. When we go to
reinstall SQL (virtual server) on node 1, we get the following error.
"An error occured while creating SQL virtual server resources for
clustering. Setup could not connect to the database to update
cluster-specific information is the system tables."
Setup then goes to cleaning up etc and exits. However, SQL server is not
succesfully installed. I cannot find referrence to this error anywhere and
cannot figure out what the problem is. I would greatly appreciate any help.
Stan,
I see no one has answered you. I am having a similar problem with almost the same error message. The one I'm getting is more like:
"An error occured while creating SQL virtual server resources for
clustering. The specified module could not be found".
My problem is on a brand new cluster, both nodes working fine, passing all failover tests. This is on the initial installation attempt. I don't know what gives.
I am seeking help as well, but there aren't a whole lot of individuals out there that have gone down this path. What a piece of crap Microsoft has dumped on us now. Good luck in finding your answer.
"stan" wrote:

> Hello All:
> Had a working SQL cluster but we had to uninstall SQL. When we go to
> reinstall SQL (virtual server) on node 1, we get the following error.
> "An error occured while creating SQL virtual server resources for
> clustering. Setup could not connect to the database to update
> cluster-specific information is the system tables."
> Setup then goes to cleaning up etc and exits. However, SQL server is not
> succesfully installed. I cannot find referrence to this error anywhere and
> cannot figure out what the problem is. I would greatly appreciate any help.
>
>
|||Guy
I similar problem If you uninstall sql server and reinstall
it with same name make sure you do clean up record in
Wins and Dns server and replicate if you use AD.
good luck
>--Original Message--
>Stan,
>I see no one has answered you. I am having a similar
problem with almost the same error message. The one I'm
getting is more like:
>"An error occured while creating SQL virtual server
resources for
> clustering. The specified module could not be found".
>My problem is on a brand new cluster, both nodes working
fine, passing all failover tests. This is on the initial
installation attempt. I don't know what gives.
>I am seeking help as well, but there aren't a whole lot
of individuals out there that have gone down this path.
What a piece of crap Microsoft has dumped on us now. Good
luck in finding your answer.[vbcol=seagreen]
>"stan" wrote:
When we go to[vbcol=seagreen]
following error.[vbcol=seagreen]
resources for[vbcol=seagreen]
update[vbcol=seagreen]
SQL server is not[vbcol=seagreen]
this error anywhere and[vbcol=seagreen]
appreciate any help.
>.
>
|||Guy
I similar problem If you uninstall sql server and reinstall
it with same name make sure you do clean up record in
Wins and Dns server and replicate if you use AD.
good luck
>--Original Message--
>Stan,
>I see no one has answered you. I am having a similar
problem with almost the same error message. The one I'm
getting is more like:
>"An error occured while creating SQL virtual server
resources for
> clustering. The specified module could not be found".
>My problem is on a brand new cluster, both nodes working
fine, passing all failover tests. This is on the initial
installation attempt. I don't know what gives.
>I am seeking help as well, but there aren't a whole lot
of individuals out there that have gone down this path.
What a piece of crap Microsoft has dumped on us now. Good
luck in finding your answer.[vbcol=seagreen]
>"stan" wrote:
When we go to[vbcol=seagreen]
following error.[vbcol=seagreen]
resources for[vbcol=seagreen]
update[vbcol=seagreen]
SQL server is not[vbcol=seagreen]
this error anywhere and[vbcol=seagreen]
appreciate any help.
>.
>