Installing MSDE 2000 on windows 2000 professional

Installing MSDE 2000 on windows 2000 professional

Post by Dick DeFur » Fri, 08 Jun 2001 00:44:03



Hello:

I am trying to install MSDE (Microsoft Desktop Engine) 2000 on a
Windows 2000 Professional machine (with SP2).  Note: I do not yet
have an application built that uses MSDE;
I simply want to install the Desktop Engine for evaluation.

Here's what I try:
I simply insert the SQL Server 2000 Enterprise Edition CD,
navigate to English/Ent/MSDE, and double-click on setup.exe.

The symptom is that the install nearly finishes, then silently
fails and does a rollback / removes all traces of itself.

When I save a verbose log via the /L*v switch, I get 3MB of info;
the problem seems to be that arise installing perfmon as seen
in the following lines from the logfile:

...
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 6
Action ended 8:33:19: InstallFinalize. Return value 3.
MSI (s) (FC:68): User policy value 'DisableRollback' is 0
MSI (s) (FC:68): Machine policy value 'DisableRollback' is 0
*** rollback commences here ***
...

Any help / suggestions would be much appreciated.

-DD

 
 
 

Installing MSDE 2000 on windows 2000 professional

Post by Jeremy Hurre » Fri, 08 Jun 2001 05:27:36


Ok, I don't really know exactly what's happening here, but may have some
suggestions. First of all, the error code 6 returned from PerfmonLoad
indicates an invalid handle being used somewhere in loading the performance
monitors. Generally this is caused by some corruption in the performance
monitor info stored in the registry. I don't know why it happens, but I have
seen it before.

I guess I would make sure that your machine is clean, no directories from
previous SQL installations around, no sqlctr.ini files, etc. If that doesn't
do it, one possible workaround would be to follow KB article Q161791, which
has you basically reinstall the stock performance monitor files from your
OS. NOTE: This will clobber any custom perf counters you have installed, so
you might have to reinstall something if it has perf counters.

Jeremy


Quote:> Hello:

> I am trying to install MSDE (Microsoft Desktop Engine) 2000 on a
> Windows 2000 Professional machine (with SP2).  Note: I do not yet
> have an application built that uses MSDE;
> I simply want to install the Desktop Engine for evaluation.

> Here's what I try:
> I simply insert the SQL Server 2000 Enterprise Edition CD,
> navigate to English/Ent/MSDE, and double-click on setup.exe.

> The symptom is that the install nearly finishes, then silently
> fails and does a rollback / removes all traces of itself.

> When I save a verbose log via the /L*v switch, I get 3MB of info;
> the problem seems to be that arise installing perfmon as seen
> in the following lines from the logfile:

> ...
> Starting custom action InstallPerfMon
> Registering performance counters from sqlctr.ini
> PerfmonLoad routine returned error code 6
> Action ended 8:33:19: InstallFinalize. Return value 3.
> MSI (s) (FC:68): User policy value 'DisableRollback' is 0
> MSI (s) (FC:68): Machine policy value 'DisableRollback' is 0
> *** rollback commences here ***
> ...

> Any help / suggestions would be much appreciated.

> -DD


 
 
 

Installing MSDE 2000 on windows 2000 professional

Post by Dick DeFur » Fri, 08 Jun 2001 23:14:34



> Hello:

> I am trying to install MSDE (Microsoft Desktop Engine) 2000 on a
> Windows 2000 Professional machine (with SP2).  Note: I do not yet
> have an application built that uses MSDE;
> I simply want to install the Desktop Engine for evaluation.

> Here's what I try:
> I simply insert the SQL Server 2000 Enterprise Edition CD,
> navigate to English/Ent/MSDE, and double-click on setup.exe.

> The symptom is that the install nearly finishes, then silently
> fails and does a rollback / removes all traces of itself.

> When I save a verbose log via the /L*v switch, I get 3MB of info;
> the problem seems to be that arise installing perfmon as seen
> in the following lines from the logfile:

> ...
> Starting custom action InstallPerfMon
> Registering performance counters from sqlctr.ini
> PerfmonLoad routine returned error code 6
> Action ended 8:33:19: InstallFinalize. Return value 3.
> MSI (s) (FC:68): User policy value 'DisableRollback' is 0
> MSI (s) (FC:68): Machine policy value 'DisableRollback' is 0
> *** rollback commences here ***
> ...

> Any help / suggestions would be much appreciated.

> -DD

I should have included the Application event log errors:

LoadPerf:
Installing the performance counter strings for MSSQLServer failed.
The Error code is DWORD 0 of the Record Data.

MSinstaller:
Product: Microsoft SQL Server Desktop Engine -- Installation operation failed.

-Dick

 
 
 

Installing MSDE 2000 on windows 2000 professional

Post by Rich DeFuri » Thu, 14 Jun 2001 01:45:51


All:

Here's the answer, for anyone who experiences similar problem(s);
the following is directly from Microsoft Technical Support (also
refer to the related KB article number Q192710).  This did
the trick for me.  You mileage may vary:

-bring up services manager
-sort by status
-for all services with "started" status,
 stop any that are not absolutely essential
 (e.g., IIS, SMTP, IIS Admin, et. many al.).
 n.b., MS Tech Support was particularly worried
 about any that may use SMTP
-perform the MSDE 2000 setup.exe again

My install then worked.

-Dick



> > Hello:

> > I am trying to install MSDE (Microsoft Desktop Engine) 2000 on a
> > Windows 2000 Professional machine (with SP2).  Note: I do not yet
> > have an application built that uses MSDE;
> > I simply want to install the Desktop Engine for evaluation.

> > Here's what I try:
> > I simply insert the SQL Server 2000 Enterprise Edition CD,
> > navigate to English/Ent/MSDE, and double-click on setup.exe.

> > The symptom is that the install nearly finishes, then silently
> > fails and does a rollback / removes all traces of itself.

> > When I save a verbose log via the /L*v switch, I get 3MB of info;
> > the problem seems to be that arise installing perfmon as seen
> > in the following lines from the logfile:

> > ...
> > Starting custom action InstallPerfMon
> > Registering performance counters from sqlctr.ini
> > PerfmonLoad routine returned error code 6
> > Action ended 8:33:19: InstallFinalize. Return value 3.
> > MSI (s) (FC:68): User policy value 'DisableRollback' is 0
> > MSI (s) (FC:68): Machine policy value 'DisableRollback' is 0
> > *** rollback commences here ***
> > ...

> > Any help / suggestions would be much appreciated.

> > -DD

> I should have included the Application event log errors:

> LoadPerf:
> Installing the performance counter strings for MSSQLServer failed.
> The Error code is DWORD 0 of the Record Data.

> MSinstaller:
> Product: Microsoft SQL Server Desktop Engine -- Installation operation failed.

> -Dick

--
-----------------------------------------------------------
Rich DeFuria            Phone 978-461-1105

http://www.belarc.com/  "PC Management for the Internet Age"
 
 
 

Installing MSDE 2000 on windows 2000 professional

Post by joegalax » Wed, 01 Aug 2001 23:00:20


1. Sorry for my poor english
2. I wish to thanks you both for helping me with the same problems.
   Actually I tried all the proposed fixes, without success.

a. reinstalled the stock performance counters file from the \i386 dir.
b. installing with most services stopped.
c. saving all counters and restoring them (hope to fix the registry
   info this way)
d. collecting 3.5MB windows installer log file like butterflies ;-)
e. blame the fact that I want to do everything with WinXP instead
   of Win2000.

I'm installing the MSDE provided with the download of the .NET
Framework. I tried installing the one that ships with OfficeXP.
Same results.

What else?

Does someone has an idea of where the perfmon settings are kept in
the registry?

My error messages are exactly the same as the ones of Rich DeFuria.

Thanks.

Simone Baglioni

Rich DeFuria [/i]
[B]All:

Here's the answer, for anyone who experiences similar problem(s); the following is directly from
Microsoft Technical Support (also refer to the related KB article number Q192710). This did the
trick for me. You mileage may vary:

-bring up services manager -sort by status -for all services with "started" status, stop any that
are not absolutely essential
 (e.g., IIS, SMTP, IIS Admin, et. many al.).
 e.h., MS Tech Support was particularly worried about any that may use SMTP -perform the MSDE 2000
     setup.exe again

My install then worked.

-Dick

[size=1]??[i][color="{usenetquotecolor}"]>[/color][/i][/size]

[size=1]??[i][color="{usenetquotecolor}"]> <...[/color][/i][/size">
[size=1]??[i][color="{usenetquotecolor2}"]> > Hello:[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> >[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> > I am trying to install MSDE (Microsoft Desktop Engine) 2000 on a Windows 2000 Professional[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> > machine (with SP2). Note: I do not yet have an application built that uses MSDE; I simply want[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> > to install the Desktop Engine for evaluation.[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> >[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> > Here's what I try: I simply insert the SQL Server 2000 Enterprise Edition CD, navigate to[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> > English/Ent/MSDE, and double-click on setup.exe.[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> >[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> > The symptom is that the install nearly finishes, then silently fails and does a rollback /[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> > removes all traces of itself.[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> >[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> > When I save a verbose log via the /L*v switch, I get 3MB of info; the problem seems to be that[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> > arise installing perfmon as seen in the following lines from the logfile:[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> >[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> > ... Starting custom action InstallPerfMon Registering performance counters from sqlctr.ini[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> > PerfmonLoad routine returned error code 6 Action ended 8:33:19: InstallFinalize. Return value 3.[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> > MSI (s) (FC:68): User policy value 'DisableRollback' is 0 MSI (s) (FC:68): Machine policy value[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> > 'DisableRollback' is 0 *** rollback commences here *** ...[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> >[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> > Any help / suggestions would be much appreciated.[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> >[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor2}"]> > -DD[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor}"]>[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor}"]> I should have included the Application event log errors:[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor}"]>[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor}"]> LoadPerf: Installing the performance counter strings for MSSQLServer failed. The Error code is[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor}"]> DWORD 0 of the Record Data.[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor}"]>[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor}"]> MSinstaller: Product: Microsoft SQL Server Desktop Engine -- Installation operation failed.[/color][/i][/size]
[size=1]??[i][color="{usenetquotecolor}"]>[/color][/i][/size]
  > --


  > http://www.belarc.com/"]http://www.belarc.com/ "PC Management for the
  > Internet Age"

--
Posted via dBforums, http://dbforums.com

 
 
 

Installing MSDE 2000 on windows 2000 professional

Post by Jeremy Hurre » Thu, 02 Aug 2001 03:29:37


The Perf counter information is stored in (for English):

HKLM\Software\Microsoft\Windows NT\CurrentVersion\Perflib\009

There is also information under each service in

HKLM\System\CurrentControlSet\Services\...

That tells what the first and last perf counter ids are for that service.
Unlodctr.exe uses this information when unloading counters.

Hope that helps a little...

Jeremy


Quote:

> 1. Sorry for my poor english
> 2. I wish to thanks you both for helping me with the same problems.
>    Actually I tried all the proposed fixes, without success.

> a. reinstalled the stock performance counters file from the \i386 dir.
> b. installing with most services stopped.
> c. saving all counters and restoring them (hope to fix the registry
>    info this way)
> d. collecting 3.5MB windows installer log file like butterflies ;-)
> e. blame the fact that I want to do everything with WinXP instead
>    of Win2000.

> I'm installing the MSDE provided with the download of the .NET
> Framework. I tried installing the one that ships with OfficeXP.
> Same results.

> What else?

> Does someone has an idea of where the perfmon settings are kept in
> the registry?

> My error messages are exactly the same as the ones of Rich DeFuria.

> Thanks.

> Simone Baglioni

> Rich DeFuria [/i]
> [B]All:

> Here's the answer, for anyone who experiences similar problem(s); the

following is directly from
Quote:> Microsoft Technical Support (also refer to the related KB article number

Q192710). This did the
Quote:> trick for me. You mileage may vary:

> -bring up services manager -sort by status -for all services with

"started" status, stop any that
Quote:> are not absolutely essential
>  (e.g., IIS, SMTP, IIS Admin, et. many al.).
>  e.h., MS Tech Support was particularly worried about any that may use

SMTP -perform the MSDE 2000
>      setup.exe again

> My install then worked.

> -Dick


> [size=1] [i][color="{usenetquotecolor}"]>[/color][/i][/size]



Quote:> [size=1] [i][color="{usenetquotecolor}"]>

<...[/color][/i][/size">
Quote:> [size=1] [i][color="{usenetquotecolor2}"]> > Hello:[/color][/i][/size]
> [size=1] [i][color="{usenetquotecolor2}"]> >[/color][/i][/size]
> [size=1] [i][color="{usenetquotecolor2}"]> > I am trying to install MSDE

(Microsoft Desktop Engine) 2000 on a Windows 2000
Professional[/color][/i][/size]
Quote:> [size=1] [i][color="{usenetquotecolor2}"]> > machine (with SP2). Note: I

do not yet have an application built that uses MSDE; I simply
want[/color][/i][/size]
Quote:> [size=1] [i][color="{usenetquotecolor2}"]> > to install the Desktop Engine

for evaluation.[/color][/i][/size]
Quote:> [size=1] [i][color="{usenetquotecolor2}"]> >[/color][/i][/size]
> [size=1] [i][color="{usenetquotecolor2}"]> > Here's what I try: I simply

insert the SQL Server 2000 Enterprise Edition CD, navigate
to[/color][/i][/size]
Quote:> [size=1] [i][color="{usenetquotecolor2}"]> > English/Ent/MSDE, and

double-click on setup.exe.[/color][/i][/size]
Quote:> [size=1] [i][color="{usenetquotecolor2}"]> >[/color][/i][/size]
> [size=1] [i][color="{usenetquotecolor2}"]> > The symptom is that the

install nearly finishes, then silently fails and does a rollback
/[/color][/i][/size]
Quote:> [size=1] [i][color="{usenetquotecolor2}"]> > removes all traces of

itself.[/color][/i][/size]
Quote:> [size=1] [i][color="{usenetquotecolor2}"]> >[/color][/i][/size]
> [size=1] [i][color="{usenetquotecolor2}"]> > When I save a verbose log via

the /L*v switch, I get 3MB of info; the problem seems to be
that[/color][/i][/size]
Quote:> [size=1] [i][color="{usenetquotecolor2}"]> > arise installing perfmon as

seen in the following lines from the logfile:[/color][/i][/size]
Quote:> [size=1] [i][color="{usenetquotecolor2}"]> >[/color][/i][/size]
> [size=1] [i][color="{usenetquotecolor2}"]> > ... Starting custom action

InstallPerfMon Registering performance counters from
sqlctr.ini[/color][/i][/size]
Quote:> [size=1] [i][color="{usenetquotecolor2}"]> > PerfmonLoad routine returned

error code 6 Action ended 8:33:19: InstallFinalize. Return value
3.[/color][/i][/size]
Quote:> [size=1] [i][color="{usenetquotecolor2}"]> > MSI (s) (FC:68): User policy

value 'DisableRollback' is 0 MSI (s) (FC:68): Machine policy
value[/color][/i][/size]
Quote:> [size=1] [i][color="{usenetquotecolor2}"]> > 'DisableRollback' is 0 ***

rollback commences here *** ...[/color][/i][/size]
Quote:> [size=1] [i][color="{usenetquotecolor2}"]> >[/color][/i][/size]
> [size=1] [i][color="{usenetquotecolor2}"]> > Any help / suggestions would

be much appreciated.[/color][/i][/size]
Quote:> [size=1] [i][color="{usenetquotecolor2}"]> >[/color][/i][/size]
> [size=1] [i][color="{usenetquotecolor2}"]> > -DD[/color][/i][/size]
> [size=1] [i][color="{usenetquotecolor}"]>[/color][/i][/size]
> [size=1] [i][color="{usenetquotecolor}"]> I should have included the

Application event log errors:[/color][/i][/size]
Quote:> [size=1] [i][color="{usenetquotecolor}"]>[/color][/i][/size]
> [size=1] [i][color="{usenetquotecolor}"]> LoadPerf: Installing the

performance counter strings for MSSQLServer failed. The Error code
is[/color][/i][/size]
Quote:> [size=1] [i][color="{usenetquotecolor}"]> DWORD 0 of the Record

Data.[/color][/i][/size]
Quote:> [size=1] [i][color="{usenetquotecolor}"]>[/color][/i][/size]
> [size=1] [i][color="{usenetquotecolor}"]> MSinstaller: Product: Microsoft

SQL Server Desktop Engine -- Installation operation
failed.[/color][/i][/size]

- Show quoted text -

> [size=1] [i][color="{usenetquotecolor}"]>[/color][/i][/size]

>   > --


>   > http://www.belarc.com/"]http://www.belarc.com/ "PC Management for the
>   > Internet Age"

> --
> Posted via dBforums, http://dbforums.com