Re: MSSQL2K and MSSQL side by side in clustered environment

We have 3 disk resources in a cluster group dedicated to the SQL Server 2005
installation.
We did try the installation without having sql network name and ip address
preconfigured as resources, same result.
Does the installation crashing apply to other cluster groups (other
instances) having offline resources?

"Geoff N. Hiten" skrev:

> You need to start out with a disk resource in its own resource group. The
> Network Name and IP address resource for the clustered SQL instance are
> created by the installer. It appears that the installer sees a complete
> virtual server, although without SQL, and is having problems installing to
> that resource group.
>
> Also, the installer will crash if there is any clustered resource currently
> offline.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
>
>
> "Björn Pettersson" <BjrnPettersson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> message news:5B0D9134-9B9A-4ABE-BE48-2564C3555079@xxxxxxxxxxxxxxxx
> > 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.
> >>
> >>
> >>
>
>
>
.

Loading