Groups | Blog | Home
all groups > sql server msde > march 2005 >

sql server msde : When does installing msde require a reboot?


Lucas Albers
3/3/2005 8:51:05 AM
We are installing msde in an unattended mode on win2k+sp4.
This is on a completelly clean windows install that has had no applications
installed on it.

We spent a day reading documentation and experimenting trying to determine
under what conditions msde needs to reboot.

It currently gives the 1641 error in the setup log indicating it needs to
reboot.
(or it just reboots.)

Does installing msde always require a reboot?
Can it be installed without a reboot?
Can the reboot be suppressed via install switches we are not aware of?

The install switches we are using are:

setup.exe DISABLENETWORKPROTOCOLS=0 SAPWD="blah" SECURITYMODE=SQL /L*v
c:\temp\msde.log /qb-

MSDE install then initiates a reboot.


##log entries
Starting custom action InstallSqlRedis
Executing "c:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
/q:a"
MDAC requested a reboot

MSI (s) (6C:CC): Note: 1: 1707
MSI (s) (6C:CC): Product: Microsoft SQL Server Desktop Engine --
Installation operation completed successfully.

MSI (s) (6C:CC): Cleaning up uninstalled install packages, if any exist
MSI (s) (6C:CC): MainEngineThread is returning 1641
MSI (c) (5C:FC): Decrementing counter to disable shutdown. If counter >= 0,
shutdown will be denied. Counter after decrement: -1
MSI (c) (5C:FC): Performing reboot from the client process.
MSI (c) (5C:FC): MainEngineThread is returning 1641
##log entries
Lucas Albers
3/3/2005 2:33:03 PM
I guess the answer would be that msde requires a reboot to register mdac
correctly?


[quoted text, click to view]
Andrea Montanari
3/3/2005 7:15:18 PM
hi Lucas,
[quoted text, click to view]

usually a reboot is required for MDAC components to be properly registered,
as long as for all other COM components like SQL-DMO....
if not SQL-DMO, which can probably waiting for a pending reboot before being
called by users/connections/applications, MDAC (at the 2.7.1 sp level in
MSDE sp3) is for sure not already present (at this sp level) on a clean
Win2k pc...

[quoted text, click to view]
http://tinyurl.com/5ecrp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/msi/setup/reboot.asp

I even saw an earlier post indicating to add the
REBOOT=ReallySuppress
parameter to the setup.exe boostrap installer call, by I never tried it and
it seems not to be included in the parameter list accepted by setup.exe
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/di
stsql_84xl.asp)
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Andrea Montanari
3/4/2005 12:16:57 AM
[quoted text, click to view]
probably :D

--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

AddThis Social Bookmark Button