Cluster Installation Failure

Thanks in advance for any help.
A SQL 2005 Failover Clustering installation (from the RTM disks) failed on
Database Services. Please see messages below. Windows cluster server name
is COMDEVDB01 (Windows 2003), primary node = COMDEVCLU01, secondary node =
COMDEVCLU02. SQL cluster virtual name = COMDEVSQLCLU, named instance =
COMDEVPROD. I installed from COMDEVCLU01. Should I install from COMDEVDB01
while COMDEVCLU01 is the active node (i.e., I will be on COMDEVCLU01)?
Earlier install failed on SQLBrowser errors and rolled back. Before the
cluster install two non-clustered SQL 2005 named instances had been installed
on COMDEVCLU01 and SP2 had been applied (both current versions = 3152).
After the SQLBrowser failure I installed a non-clustered SQL 2005 named
instance on COMDEVCLU02 with Database Services and Integration Services (also
version 3152). After that, the cluster install on COMDEVCLU01 failed with
these errors but did not rollback.
Should I try to install SP2 for the SQL cluster from COMDEVCLU01?
Can I "complete" this installation (save it) or will I have to uninstall and
re-install?
Should I uninstall all SQL Server instances on COMDEVCLU01 and install the
clustered instance first?
summary.txt message:
Machine : COMDEVCLU01
Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0006_COMDEVCLU01_SQL.l og
Last Action : ComponentUpgrade
Error String : The setup has encountered an error while Upgrading
Components. The error: -2147019873
Error message: The group or resource is not in the correct state to perform
the requested operation.
Error Number : 29550
SQLSetup0006_COMDEVCLU01_SQL.log message:
MSI (s) (AC:14) [15:52:23:016]: Product: Microsoft SQL Server 2005 - Update
'Hotfix 3024 for SQL Server Database Services 2005 ENU (KB000000)' could not
be installed. Error code 1603.
MichaelA_CCGA
Michael:
I will be posting a similar question to yours entitled "Failed SQL Cluster
Advice." That hopefully will get answered as well.
In the meantime you mentioned RTM Disks. Are these CDs and did your install
fail when you put in Disk 2 "Tools" This is my issue and I have googled to
find that this is a known issue and the resolution is copy both disks to a
common path.
Was this your issue as well?
Thanks, emagidson
"MichaelA_CCGA" wrote:

> Thanks in advance for any help.
> A SQL 2005 Failover Clustering installation (from the RTM disks) failed on
> Database Services. Please see messages below. Windows cluster server name
> is COMDEVDB01 (Windows 2003), primary node = COMDEVCLU01, secondary node =
> COMDEVCLU02. SQL cluster virtual name = COMDEVSQLCLU, named instance =
> COMDEVPROD. I installed from COMDEVCLU01. Should I install from COMDEVDB01
> while COMDEVCLU01 is the active node (i.e., I will be on COMDEVCLU01)?
> Earlier install failed on SQLBrowser errors and rolled back. Before the
> cluster install two non-clustered SQL 2005 named instances had been installed
> on COMDEVCLU01 and SP2 had been applied (both current versions = 3152).
> After the SQLBrowser failure I installed a non-clustered SQL 2005 named
> instance on COMDEVCLU02 with Database Services and Integration Services (also
> version 3152). After that, the cluster install on COMDEVCLU01 failed with
> these errors but did not rollback.
> Should I try to install SP2 for the SQL cluster from COMDEVCLU01?
> Can I "complete" this installation (save it) or will I have to uninstall and
> re-install?
> Should I uninstall all SQL Server instances on COMDEVCLU01 and install the
> clustered instance first?
> summary.txt message:
> ----
> Machine : COMDEVCLU01
> Product : Microsoft SQL Server 2005
> Product Version : 9.00.1399.06
> Install : Failed
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0006_COMDEVCLU01_SQL.l og
> Last Action : ComponentUpgrade
> Error String : The setup has encountered an error while Upgrading
> Components. The error: -2147019873
> Error message: The group or resource is not in the correct state to perform
> the requested operation.
> Error Number : 29550
> ----
> SQLSetup0006_COMDEVCLU01_SQL.log message:
> ----
> MSI (s) (AC:14) [15:52:23:016]: Product: Microsoft SQL Server 2005 - Update
> 'Hotfix 3024 for SQL Server Database Services 2005 ENU (KB000000)' could not
> be installed. Error code 1603.
> --
> MichaelA_CCGA
|||Sorry I dropped out of the discussion but I wanted to post the question
before I took a few days off and I'm just now catching up. I have printed
your exchange with Geoff and I will review that in more detail.
I did not have the "2nd CD" problem but the information about uninstalling
may prove very useful.
Thanks again, and I'll check back in tomorrow or Thursday.
MichaelA_CCGA
"EMagidson" wrote:
[vbcol=seagreen]
> Michael:
> I will be posting a similar question to yours entitled "Failed SQL Cluster
> Advice." That hopefully will get answered as well.
> In the meantime you mentioned RTM Disks. Are these CDs and did your install
> fail when you put in Disk 2 "Tools" This is my issue and I have googled to
> find that this is a known issue and the resolution is copy both disks to a
> common path.
> Was this your issue as well?
> Thanks, emagidson
> "MichaelA_CCGA" wrote:

cluster hardware - CPU, memory

1. In MSCS and SQL Server 2-node clustering on windows 2000 advance server,
are there any restrictions on the hardware. That is, do the 2 nodes
necessarily should have the same number of CPU and memory?
2. when we have 2 node with sql server in cluster, can we install another
non-clustered instance on the same server?
3. is there a link which describes the difference between 1 sql instance
cluster and 2 sql instance cluster?
1). Certified cluster configurations must be symmetrical. That is all
nodes indentical. It is possible to run asymmetrical clusters, but they are
often more trouble and less reliable than a stand-alone SQL instance.
2). Yes.
3). The Microsoft SQL Server 2000 Resource Kit has some good information on
clustering, including using more than 2 nodes and multi-instance support.
BOL also has some basic information.
Geoff N. Hiten
Microsoft SQL Server MVP
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:2E64C5E8-A0BB-41AB-8174-FF26137A1F17@.microsoft.com...
> 1. In MSCS and SQL Server 2-node clustering on windows 2000 advance
> server,
> are there any restrictions on the hardware. That is, do the 2 nodes
> necessarily should have the same number of CPU and memory?
> 2. when we have 2 node with sql server in cluster, can we install another
> non-clustered instance on the same server?
> 3. is there a link which describes the difference between 1 sql instance
> cluster and 2 sql instance cluster?
sqlsql

client side print button not visible even in SQL Server 2005 Express SP 2.0

Hi All!

i installed SQL Server 2005 express edition Service Pack 2.0, SQL server Advance Services, and Toolkit . Still Print button in client side report is not visible in web form.

please help me.

thanks in advance.

rkraju:

Hi All!

i installed SQL Server 2005 express edition Service Pack 2.0, SQL server Advance Services, and Toolkit . Still Print button in client side report is not visible in web form.

please help me.

thanks in advance.

Wel I guess we cannot do that...printing is not available on client SSRS...Too bad...And just to let you know, if you need to send query parameters to the report forget the client SSRS again...it sucks...you have to install the report on the Web server and that way yes you can print and send query parameters and so long...other way no solution...

Read here...I'm feeling frustrated on this...

http://blogs.msdn.com/mohamed_sharafs_blog/archive/2005/12/20/LocalReportCustomCode.aspx

However if you've found another solution please let me know!!!Thanks a lot!