I can't upgrade MSDE sp2 to sp3a

I am trying to upgrade an instance of MSDE on my XP computer using
setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=AnAdminLogin
UPGRADEPWD=AdminPassword
It runs for a while and then looks like it rolls back the installation. I
check the event viewer and I see an entry that states
"Product: Microsoft SQL Server Desktop Engine -- Configuration failed.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp."
But when I look further at the other entries I can see nothing that would
indicate why it failed.
I only have one instance of MSDE on my computer and this is the results of
my @.@.version before the upgrade
Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Desktop Engine on Windows NT 5.1
(Build 2600: Service Pack 2)
I had checked the registry as per a MS article and it looks like it was
isntalled via sqlrun01.msi
Does anybody have any thoughts?
Thanks
Richard
hi Richard,
"Richard Speiss" <rspeiss@.mtxinc.com> ha scritto nel messaggio
news:%23WD%23x$TiEHA.1276@.TK2MSFTNGP09.phx.gbl...
> I am trying to upgrade an instance of MSDE on my XP computer using
> setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=AnAdminLogin
> UPGRADEPWD=AdminPassword
> It runs for a while and then looks like it rolls back the installation. I
> check the event viewer and I see an entry that states
> "Product: Microsoft SQL Server Desktop Engine -- Configuration failed.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp."
> But when I look further at the other entries I can see nothing that would
> indicate why it failed.
> I only have one instance of MSDE on my computer and this is the results of
> my @.@.version before the upgrade
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
> Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Desktop Engine on Windows NT 5.1
> (Build 2600: Service Pack 2)
> I had checked the registry as per a MS article and it looks like it was
> isntalled via sqlrun01.msi
> Does anybody have any thoughts?
please add the
/L*v "c:\msdesp3.log"
command line parameter, in order to full log the installation to a (about)
2mb log txt file where you can search for
Return Value 3 in order to toubleshoot your upgrade
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

hyper threading

Hi,
Are there any issues/benifits when running SQL Server 2000
EE SP3a/Windows 2000 Server SP4 on a machine that has CPUs
with hyper threading enabled?
Thanks
Oskar
Oskar,
Works for me - I have some 4 way servers with hyperthreading. I've not
heard of anything that would cause any issues. Make sure you are on the
latest service packs though (looks like you are).
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Oskar wrote:
> Hi,
> Are there any issues/benifits when running SQL Server 2000
> EE SP3a/Windows 2000 Server SP4 on a machine that has CPUs
> with hyper threading enabled?
> --
> Thanks
> Oskar
|||At a minimum... you might consider changing max degree of parrelism to the
PHYSICAL number of processors rather than the logical. I've seen many cases
where you'll have problems with cxpacket waits if you get a 4X plan on a box
with 2 physical but 4 logical processors...
Of course this isn't always true. But something to think about...
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Oskar" <anonymous@.discussions.microsoft.com> wrote in message
news:2df001c4a217$c7278520$a601280a@.phx.gbl...
> Hi,
> Are there any issues/benifits when running SQL Server 2000
> EE SP3a/Windows 2000 Server SP4 on a machine that has CPUs
> with hyper threading enabled?
> --
> Thanks
> Oskar
|||When is it true? And when is it NOT true?
Please give us details.
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:uQi0GkjoEHA.3900@.TK2MSFTNGP10.phx.gbl...
> At a minimum... you might consider changing max degree of parrelism to
> the
> PHYSICAL number of processors rather than the logical. I've seen many
> cases
> where you'll have problems with cxpacket waits if you get a 4X plan on a
> box
> with 2 physical but 4 logical processors...
> Of course this isn't always true. But something to think about...
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Oskar" <anonymous@.discussions.microsoft.com> wrote in message
> news:2df001c4a217$c7278520$a601280a@.phx.gbl...
>
|||Have you heard that any of post SP3(a) fixes help? I can't
find a confirmation of this on MS website though.
Oskar

>--Original Message--
>Oskar,
>Works for me - I have some 4 way servers with
hyperthreading. I've not
>heard of anything that would cause any issues. Make sure
you are on the[vbcol=seagreen]
>latest service packs though (looks like you are).
>--
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602m.html
>
>Oskar wrote:
2000[vbcol=seagreen]
CPUs
>.
>

hyper threading

Hi,
Are there any issues/benifits when running SQL Server 2000
EE SP3a/Windows 2000 Server SP4 on a machine that has CPUs
with hyper threading enabled?
--
Thanks
OskarOskar,
Works for me - I have some 4 way servers with hyperthreading. I've not
heard of anything that would cause any issues. Make sure you are on the
latest service packs though (looks like you are).
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Oskar wrote:
> Hi,
> Are there any issues/benifits when running SQL Server 2000
> EE SP3a/Windows 2000 Server SP4 on a machine that has CPUs
> with hyper threading enabled?
> --
> Thanks
> Oskar|||At a minimum... you might consider changing max degree of parrelism to the
PHYSICAL number of processors rather than the logical. I've seen many cases
where you'll have problems with cxpacket waits if you get a 4X plan on a box
with 2 physical but 4 logical processors...
Of course this isn't always true. But something to think about...
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Oskar" <anonymous@.discussions.microsoft.com> wrote in message
news:2df001c4a217$c7278520$a601280a@.phx.gbl...
> Hi,
> Are there any issues/benifits when running SQL Server 2000
> EE SP3a/Windows 2000 Server SP4 on a machine that has CPUs
> with hyper threading enabled?
> --
> Thanks
> Oskar|||When is it true? And when is it NOT true?
Please give us details.
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:uQi0GkjoEHA.3900@.TK2MSFTNGP10.phx.gbl...
> At a minimum... you might consider changing max degree of parrelism to
> the
> PHYSICAL number of processors rather than the logical. I've seen many
> cases
> where you'll have problems with cxpacket waits if you get a 4X plan on a
> box
> with 2 physical but 4 logical processors...
> Of course this isn't always true. But something to think about...
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Oskar" <anonymous@.discussions.microsoft.com> wrote in message
> news:2df001c4a217$c7278520$a601280a@.phx.gbl...
>> Hi,
>> Are there any issues/benifits when running SQL Server 2000
>> EE SP3a/Windows 2000 Server SP4 on a machine that has CPUs
>> with hyper threading enabled?
>> --
>> Thanks
>> Oskar
>|||Have you heard that any of post SP3(a) fixes help? I can't
find a confirmation of this on MS website though.
--
Oskar
>--Original Message--
>Oskar,
>Works for me - I have some 4 way servers with
hyperthreading. I've not
>heard of anything that would cause any issues. Make sure
you are on the
>latest service packs though (looks like you are).
>--
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602m.html
>
>Oskar wrote:
>> Hi,
>> Are there any issues/benifits when running SQL Server
2000
>> EE SP3a/Windows 2000 Server SP4 on a machine that has
CPUs
>> with hyper threading enabled?
>> --
>> Thanks
>> Oskar
>.
>