Re: MSSQL2K and MSSQL side by side in clustered environment

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.
>>
>>
>>


.