MSSQL2K and MSSQL side by side in clustered environment

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.
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
"Bjrn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
message news:CF3CA7C9-DEE9-41DF-9C0C-FBF48B93156E@.microsoft.com...
>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.
|||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?LinkI...d Disks%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@.discussions.microsoft.com> wrote in
> message news:CF3CA7C9-DEE9-41DF-9C0C-FBF48B93156E@.microsoft.com...
>
>
|||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
"Bjrn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
message news:5B0D9134-9B9A-4ABE-BE48-2564C3555079@.microsoft.com...[vbcol=seagreen]
> 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?LinkI...d Disks%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,
> Bjrn
> "Michael Hotek" skrev:
|||You also want to run the .Net Framework 2.0 install on all nodes in the
cluster. It will REALLY speed up the install.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Bjrn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
message news:5B0D9134-9B9A-4ABE-BE48-2564C3555079@.microsoft.com...[vbcol=seagreen]
> 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?LinkI...d Disks%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,
> Bjrn
> "Michael Hotek" skrev:
|||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@.discussions.microsoft.com> wrote in
> message news:5B0D9134-9B9A-4ABE-BE48-2564C3555079@.microsoft.com...
>
>
|||Ok, I thought the installation would take care of this for me. I will try
installing ASP .Net on the other node,
would it be a good thing to install the SQL native client on the other node
too?
Thanks,
Bj?rn
"Michael Hotek" skrev:

> You also want to run the .Net Framework 2.0 install on all nodes in the
> cluster. It will REALLY speed up the install.
> --
> Mike
> Mentor
> Solid Quality Learning
> http://www.solidqualitylearning.com
>
> "Bj?rn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
> message news:5B0D9134-9B9A-4ABE-BE48-2564C3555079@.microsoft.com...
>
>
|||Yes. If the cluster has any resource or resource group offline, the SQL
installer will crash. The SQL installer tries to enumerate resources and
properties during a cluster install and fails badly if anything is offline.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Bjrn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
message news:F16A596E-7B06-47F9-B416-CF4FD897B0A8@.microsoft.com...[vbcol=seagreen]
> 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:
|||I have installed the following environment:
MS Windows 2003 EE + MS SQL Server 2005 EE
Services not installed:
Analysis services
Reporting services
At the end of the first named instance installation I get the same
error/alert messages.
I have tried some SQL Server operations and tested the fail-over
cluster and everything seems to be working fine.
I will carry some more tests but If I didn't get any operational
errors I will passed to production environment at the end of the week.