Re: MSSQL2K and MSSQL side by side in clustered environment

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for your answer :D

I've successfully managed to create a new cluster resource group, and have
created a disk resource, an ip address resource and a network name resource
(is this what you referring to as SQL Server Virtual?). I manage to
failover/move group resources to the other node and back again. I am able to
ping the Network Name which responds well and translates to the correct IP
address, so the cluster seems to be fine. When I run the SQL Server 2005
Enterprise Edition setup program, I am required to install ASP .Net 2.0, SQL
Native Client + Setup Component files, this works fine. When I click next and
the installation program performs a system check, the application seem to
work for a while, and then I get the following error message:

There was an unexpected failure during the setup wizard. You may review the
setup logs and/or click the help button for more information.

For help, click:
http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=50000&EvtType=datastore%5cclustergroupsproperties.cpp%40InvokeSqlSetupDllAction%40ClusterGroupScope.SharedDisks%400x2

The bootstrap log files contain some error messages, listed below:

Error: Action "LaunchLocalBootstrapAction" threw an exception during
execution. Error information reported during run:
"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe"
finished and returned: 3221225477
Aborting queue processing as nested installer has completed
Message pump returning: 3221225477

Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\sqlsval.dll Version:2005.90.1399.0
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution.
Exception record 0
Exception Code 0xc0000005
Exception Flags 0
Exception Address 0x498E4A04
Number of parameters 2
Parameter 0: 0x0
Parameter 1: 0x4
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\DbgHelp.dll Version:6.5.3.7
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework 2.0.log" to cab
file : "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework 2.0 LangPack.log"
to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Upgrade
Advisor.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Upgrade Advisor
LangPack.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Windows
Installer.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_.NET Framework Windows Installer
LangPack.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0016_KK-TST-DB1_SCC.log" to cab file :
"C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\SqlSetup0016.cab" Error Code : 32
Running: UploadDrWatsonLogAction at: 2006/0/4 9:56:22
Message pump returning: 3221225477

Does any of you have experienced the setup program experiencing a unexpected
failure? Any ideas that can solve my installation problems are welcome.

Thanks,
Björn

"Michael Hotek" skrev:

> Yes, you can do this. You need to create a new group which has disks which
> have not been used for any other SQL Server Virtual. Then install a new SQL
> Server 2005 Virtual. (It will need a new name and new IP address.) Once
> installed, you can finish the migration by using either attach/detach or
> backup/restore. You can also minimize the amount of time the migration
> takes by implementing either log shipping or replication from SQL Server
> 2000 to 2005 and then cutting over where they are synchronized.
>
> --
> Mike
> Mentor
> Solid Quality Learning
> http://www.solidqualitylearning.com
>
>
> "Björn Pettersson" <BjrnPettersson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> message news:CF3CA7C9-DEE9-41DF-9C0C-FBF48B93156E@xxxxxxxxxxxxxxxx
> >I haven't been able to find any publications on Internet regarding my
> >concern.
> >
> > We have a MS SQL2K installation in a clustered environment, and would like
> > to migrate to MS SQL2K5 using a side-by-side installation. To my
> > knowledge,
> > this should be possible. Could you please direct me to any documents
> > describing how to perform this task. Is it as easy as creating two new
> > resource groups (we're using two instances for the MS SQL2K installation
> > today), create the necessary resources (sql name, sql ip, services and
> > disks), and installing MS SQL2K5 to a different location than the current
> > installation? The operative system on the servers are Windows 2003
> > Enterprise
> > Edition and the MS SQL 2K5 Server edition we intend to use is the
> > Enterprise
> > edition.
>
>
>
.

Relevant Pages

  • Re: error while installing a new named instance
    ... SQL has issues with cluster installs when you have a login open on any of the remote nodes. ... And yet another is that teh remote node may not be able to "see" the installation source. ... Error Code: 0x80070002 ... Bootstrap\LOG\Files\SQLSetup0009_CLSNODE1_.NET Framework 2.0.log" to cab file ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster setup question
    ... You begin the installation from the node that currently owns the disk ... resource you want SQL data files installed to. ...
    (microsoft.public.sqlserver.server)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: Setup Fails
    ... Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup ... Bootstrap\LOG\SqlSetup0017.cab" Error Code: 2 ... Bootstrap\LOG\Files\SQLSetup0017_SNOWFLAKE_.NET Framework 2.0 LangPack.log" ... which version and edition of SQL Server is this? ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... SQL Server 2005 failover cluster has been installed? ... drive of a SQL Server 2005 failover cluster installation? ...
    (microsoft.public.sqlserver.clustering)