Multi processor OS restriction?

Hi, Ive been told this, but I hope it is NOT true. I have an sql
server2000 installation running on a server that has four processors.
It is on a active network but is not the domain controller so
essentially it is fully dedicated to servicing the needs of sql
server, (a bit of browsing, a bit of ms Office, but almost wholly
dedicated to sqlserver. Now, the big question, why, when the server
properties have been set to utilize all four processors, can any one
job never get more than 25% of cpu time? I can launch multiple
instance of QA and run the same job on each one and that will utilise
more and more cpu time, but if you launch multile QA windows from
within one insance of QA, you can NEVER get more than 25% CPU
utilisation. Now i have to run a job (FTS is a good example,
re-indexing lots of db's another, or even a huge query with multiple
ufd's on computed cols which I hoped would grab lots of CPU time that
they need, but no. So do I have to live with this or can I tell either
windows or sql server to grab more cpu when it want to ie use my spare
CPU capacity more efficiently or am i working on a misguided premise
and 25% per job is your lot?

DMAC>>Hi, Ive been told this, but I hope it is NOT true. I have an sql
>>server2000 installation running on a server that has four processors.
>>It is on a active network but is not the domain controller so
>>essentially it is fully dedicated to servicing the needs of sql
>>server, (a bit of browsing, a bit of ms Office, but almost wholly
>>dedicated to sqlserver. Now, the big question, why, when the server
>>properties have been set to utilize all four processors, can any one
>>job never get more than 25% of cpu time?
MSSQL can utilize 'parallelism' to make use of multi processors. But
it doesn't work half the time. Unless you have a single user, it is
better for MSSQL to save those other processors for other SPIDS.

>>I can launch multiple
>>instance of QA and run the same job on each one and that will utilise
>>more and more cpu time, but if you launch multile QA windows from
>>within one insance of QA, you can NEVER get more than 25% CPU
>>utilisation. Now i have to run a job (FTS is a good example,
>>re-indexing lots of db's another, or even a huge query with multiple
>>ufd's on computed cols which I hoped would grab lots of CPU time that
>>they need, but no. So do I have to live with this or can I tell
either
>>windows or sql server to grab more cpu when it want to ie use my
spare
>>CPU capacity more efficiently or am i working on a misguided premise
>>and 25% per job is your lot?
What's FTS & UFDs? User defined function?|||The SQL Server optimizer will generate a parallel plan only when it makes
sense to do so and the current server workload permits it. Many queries
will not benefit from a parallel plan. In practice, parallelism can be a
symptom of needed indexes or poorly formulated query.

> I can launch multiple
> instance of QA and run the same job on each one and that will utilise
> more and more cpu time, but if you launch multile QA windows from
> within one insance of QA, you can NEVER get more than 25% CPU
> utilisation.

This is not consistent with my experience. For example, I see both
processors fully used on my dual-cpu box by running the following query from
within the same QA instance. Do you get similar results?

USE master
SELECT COUNT(*)
FROM sysobjects a
CROSS JOIN sysobjects b
CROSS JOIN sysobjects c
CROSS JOIN sysobjects d
GO

--
Hope this helps.

Dan Guzman
SQL Server MVP

"DMAC" <drmcl@.drmcl.free-online.co.uk> wrote in message
news:462ac9a0.0501180705.4f2c5be7@.posting.google.c om...
> Hi, Ive been told this, but I hope it is NOT true. I have an sql
> server2000 installation running on a server that has four processors.
> It is on a active network but is not the domain controller so
> essentially it is fully dedicated to servicing the needs of sql
> server, (a bit of browsing, a bit of ms Office, but almost wholly
> dedicated to sqlserver. Now, the big question, why, when the server
> properties have been set to utilize all four processors, can any one
> job never get more than 25% of cpu time? I can launch multiple
> instance of QA and run the same job on each one and that will utilise
> more and more cpu time, but if you launch multile QA windows from
> within one insance of QA, you can NEVER get more than 25% CPU
> utilisation. Now i have to run a job (FTS is a good example,
> re-indexing lots of db's another, or even a huge query with multiple
> ufd's on computed cols which I hoped would grab lots of CPU time that
> they need, but no. So do I have to live with this or can I tell either
> windows or sql server to grab more cpu when it want to ie use my spare
> CPU capacity more efficiently or am i working on a misguided premise
> and 25% per job is your lot?
> DMAC|||Thanks Dan,

Your query did indeed put all four processors into overdrive, (took me
a while to cancel it cos I could not get my mouse click over the wire)
so my problem probably lies with your first suggestion about poorly
formed queries. Is there any mechanism to influence the optimiser or
thread selection to have my one really bad query utilise its own
processor( or just generally so that I can keep developement to its own
cpu/thread combo), leaving everthing else to utilize the other
processors, ie why did sql server immediately grap all the cpu time from
your query?

Cheers

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||> Is there any mechanism to influence the optimiser or
> thread selection to have my one really bad query utilise its own
> processor( or just generally so that I can keep developement to its own
> cpu/thread combo), leaving everthing else to utilize the other
> processors,

You can specify a MAXDOP hint to limit parallelism to the specified number
of processors: for a particular query:

USE master
SELECT COUNT(*)
FROM sysobjects a
CROSS JOIN sysobjects b
CROSS JOIN sysobjects c
CROSS JOIN sysobjects d
OPTION (MAXDOP 1)
GO

You can also adjust the server-wide setting with the 'max degree of
parallelism' configuration option. On a server with 4 or more processors, I
usually use this option to specify fewer processors than are available (e.g.
3) so that a single query won't monopolize CPU resources.

> ie why did sql server immediately grap all the cpu time from
> your query?

When SQL Server determines a query can benefit from parallelism, it
considers the current server workload and adjusts the number of parallel
threads accordingly. The optimizer may choose to use a single thread or
fewer processors when the machine is busy and a more aggressive plan when
not currently busy.

It's a good practice to segregate development and production on different
servers when possible.

--
Hope this helps.

Dan Guzman
SQL Server MVP

<DMAC@.devdex.com> wrote in message news:41ef7c7f$1_2@.127.0.0.1...
> Thanks Dan,
> Your query did indeed put all four processors into overdrive, (took me
> a while to cancel it cos I could not get my mouse click over the wire)
> so my problem probably lies with your first suggestion about poorly
> formed queries. Is there any mechanism to influence the optimiser or
> thread selection to have my one really bad query utilise its own
> processor( or just generally so that I can keep developement to its own
> cpu/thread combo), leaving everthing else to utilize the other
> processors, ie why did sql server immediately grap all the cpu time from
> your query?
> Cheers
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

MSXML6 breaks viewer used with Microsoft Electronic Learning Library

Installation of SQL 2005 Express resulted in the failure of the viewer used with the Microsoft Electronic Learning Library products. The viewer runs under IE and is driven by an XML file.

This has been verified on several systems. I uninstalled only MSXML6 and the viewer worked normally.

I have no idea if the problem is with the viewer script, the XML file driving it, or MSXML6 but obviously this might be a breaking change to the product.

Can anyone shed light?

Tom Skinner [C# MVP]

Hi Tom,

I'm looking into this for you.

Mike Wachal
SQL Express

|||

I found a workaround. If you disable the XML DOM Document 6.0 add-on in IE the viewer loads OK. Apparently MSXML6 is used by IE as the default if it is installed. This broke the MELL viewer. It would still be valuable to know why as other programs using IE as a frontend may break as well.

Tom Skinner [C# MVP]

|||

Hi,

The MELL dev team has been made aware of the issue that XML Parser 6.0 breaks MELL. They are currently working on putting together a patch for this. As soon as the patch becomes available, we will let you know.

Thanks.

|||

Before you run Mell, open up a dos window and run:

regsvr32 -u %windir%\system32\msxml6.dll

You should get an acknowledgement that the unregister was successful.

Start up your Mell training.

Go back to the DOS window and run:

regsvr32 %windir%\system32\msxml6.dll

Again, you should get an acknowledgement. Learn away. Doing it this way means you won't forget to put things back so that SQL Server 2005 is fully functional.

David Rogers (MCP, LIMOM)

|||Thanks. This fix my e-learning viewer problem. Is SQL 2005 express the only program dependent on msxml6.dll?|||according to MS this "bug" was done by design, the new xml parser blocks certain calls from mell because they are less secure, and ms is suppossed to have released a fix for this, but they have not done so yet...and the ppl from the xml team say the work around posted here (which has been suggested in many other places) is not recommended since it defaults your system to use the older less secure xml parser|||The fix is now located at http://support.microsoft.com/kb/917583/en-us

MSXML6 breaks viewer used with Microsoft Electronic Learning Library

Installation of SQL 2005 Express resulted in the failure of the viewer used with the Microsoft Electronic Learning Library products. The viewer runs under IE and is driven by an XML file.

This has been verified on several systems. I uninstalled only MSXML6 and the viewer worked normally.

I have no idea if the problem is with the viewer script, the XML file driving it, or MSXML6 but obviously this might be a breaking change to the product.

Can anyone shed light?

Tom Skinner [C# MVP]

Hi Tom,

I'm looking into this for you.

Mike Wachal
SQL Express

|||

I found a workaround. If you disable the XML DOM Document 6.0 add-on in IE the viewer loads OK. Apparently MSXML6 is used by IE as the default if it is installed. This broke the MELL viewer. It would still be valuable to know why as other programs using IE as a frontend may break as well.

Tom Skinner [C# MVP]

|||

Hi,

The MELL dev team has been made aware of the issue that XML Parser 6.0 breaks MELL. They are currently working on putting together a patch for this. As soon as the patch becomes available, we will let you know.

Thanks.

|||

Before you run Mell, open up a dos window and run:

regsvr32 -u %windir%\system32\msxml6.dll

You should get an acknowledgement that the unregister was successful.

Start up your Mell training.

Go back to the DOS window and run:

regsvr32 %windir%\system32\msxml6.dll

Again, you should get an acknowledgement. Learn away. Doing it this way means you won't forget to put things back so that SQL Server 2005 is fully functional.

David Rogers (MCP, LIMOM)

|||Thanks. This fix my e-learning viewer problem. Is SQL 2005 express the only program dependent on msxml6.dll?|||according to MS this "bug" was done by design, the new xml parser blocks certain calls from mell because they are less secure, and ms is suppossed to have released a fix for this, but they have not done so yet...and the ppl from the xml team say the work around posted here (which has been suggested in many other places) is not recommended since it defaults your system to use the older less secure xml parser|||The fix is now located at http://support.microsoft.com/kb/917583/en-ussql

MSXML6 breaks viewer used with Microsoft Electronic Learning Library

Installation of SQL 2005 Express resulted in the failure of the viewer used with the Microsoft Electronic Learning Library products. The viewer runs under IE and is driven by an XML file.

This has been verified on several systems. I uninstalled only MSXML6 and the viewer worked normally.

I have no idea if the problem is with the viewer script, the XML file driving it, or MSXML6 but obviously this might be a breaking change to the product.

Can anyone shed light?

Tom Skinner [C# MVP]

Hi Tom,

I'm looking into this for you.

Mike Wachal
SQL Express

|||

I found a workaround. If you disable the XML DOM Document 6.0 add-on in IE the viewer loads OK. Apparently MSXML6 is used by IE as the default if it is installed. This broke the MELL viewer. It would still be valuable to know why as other programs using IE as a frontend may break as well.

Tom Skinner [C# MVP]

|||

Hi,

The MELL dev team has been made aware of the issue that XML Parser 6.0 breaks MELL. They are currently working on putting together a patch for this. As soon as the patch becomes available, we will let you know.

Thanks.

|||

Before you run Mell, open up a dos window and run:

regsvr32 -u %windir%\system32\msxml6.dll

You should get an acknowledgement that the unregister was successful.

Start up your Mell training.

Go back to the DOS window and run:

regsvr32 %windir%\system32\msxml6.dll

Again, you should get an acknowledgement. Learn away. Doing it this way means you won't forget to put things back so that SQL Server 2005 is fully functional.

David Rogers (MCP, LIMOM)

|||Thanks. This fix my e-learning viewer problem. Is SQL 2005 express the only program dependent on msxml6.dll?|||according to MS this "bug" was done by design, the new xml parser blocks certain calls from mell because they are less secure, and ms is suppossed to have released a fix for this, but they have not done so yet...and the ppl from the xml team say the work around posted here (which has been suggested in many other places) is not recommended since it defaults your system to use the older less secure xml parser|||The fix is now located at http://support.microsoft.com/kb/917583/en-us

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.