Hello,
I am having a huge problem trying to get MSDE to install. The problem
reported in the error log is:
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (TheComputerName,LocalSystem,87).
Action ended 10:44:27: InstallFinalize. Return value 3.
I have done plenty of searches regarding this problem. Many of them
refer me to Microsoft Knowledge Base article 829386. The article
stated to insure that the server service was running. I checked this
and it was. I restarted it just in case, but that didn't help.
The article also talked about a hotfix, which I obtained from
Microsoft. The article said to apply this hotfix in the following way:
Extract all the files from the hotfix installer, and then locate the
Semnt.dll file.
Create the following two folders on the destination computer (where
InstallPath is the location where you want to install MSDE 2000
[typically C:\Program Files\Microsoft SQL Server] and Instance_Name is
the name of the instance that you want to use):
<InstallPath>\<Instance_Name>\Binn
<InstallPath>\80\Tools\Binn
Copy the Semnt.dll file to both of the folders that you created in
step 2.
Run MSDE 2000 Setup.
I have done this, but the installation still fails with the same
error.
I am attempting to install from the command prompt in the following
way:
setup SAPWD="Thepassword" INSTANCENAME="Sharepoint" /l*v
C:\install.log
I have the semnt.dll file in the following directories
C:\Program Files\Microsoft SQL Server\80\Tools\Binn
C:\Program Files\Microsoft SQL Server\Sharepoint\Binn
Installation fails and rolls back on this everytime.
Does anyone know where I am going wrong?
Any help would be greatly appreciated.
Newsgroups: microsoft.public.sqlserver.msde
From: girishs@.microsoft.com (Girish Sundaram)
Organization: Microsoft
Date: Fri, 24 Sep 2004 20:27:41 GMT
Subject: RE: Cannot get MSDE to install.
X-Tomcat-NG: microsoft.public.sqlserver.msde
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Try out the following steps
1) Remove terminal services from the control panel if it is enabled
Reboot the machine before trying to install msde once again.
Before doing the reinstall remove msde manually from teh machine using the
following steps:
<MANUALLY REMOVE MSDE>
A)Remove the following registry:
1) Remove the following ID_Number from your MSDE 2.0 instance
HKEY_CLASSES_ROOT\Installer\Products\ID_Number
-- It has key value name 'ProductName' which displays the instance name.
For example, "ProductName" = Microsoft SQL Server Desktop Engine
(MYINSTANCE)
2)If you had patch applied on this MSDE 2.0 instance, you need to remove
ID_Number
for that MSDE 2.0 instance:
HKEY_CLASSES_ROOT\Installer\Patches\ID_Number
3) For MSDE 2.0 Default instance, remove
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
For MSDE 2.0 named instance, remove
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\Your_instance_name
4)If you have the following key points to MSDE 2.0 productGUID, then remove
the
InstanceComponentSet.x
For example, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\Component
SetInstanceComponentSet.x
-- For example, InstanceComponentSet.1 the has value matching the
productGUID of
sqlrun01.msi.
-- Refers to SOX020218700073
5)Remove :
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr entVersion\Uninstall\Produ
ctGUID
-- the Product GUID which refers to your MSDE 2.0 instance.
6)Remove the Sql server service key:
For MSDE 2.0 default instance, remove
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\MSSQLServer
For MSDE 2.0 named instance, remove
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\MSSQL$Your_Instance_Nam
e
7)Remove the Sql server agent service key:
For MSDE 2.0 default instance, remove
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\SQLServerAgent
For MSDE 2.0 named instance, remove
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\SQLAgent$Your_Instance_
Name
B)Remove the MSDE 2.0 instance data and program install directory:
For example, G:\Program Files\Microsoft SQL
Server\MSSQL$Your_instanceName\data
For example, G:\Program Files\Microsoft SQL
Server\MSSQL$Your_instanceName\binn
...
</MANUALLY REMOVE MSDE>
You can also try to out the following command to prevent rollback of the
installation.
setup SAPWD="AStrongSAPassword" /L*v C:/MSDELog.log
INSTANCENAME="InstanceName" DISABLENETWORKPROTOCOLS=0 disablerollback=1
Look into the cnfgsvr.out file for details about why the setup is failing
at the configuration stage. Send me the cnfgsvr.out and the msdelog.log
file for analysis at girishs@.microsoft.com for further analysis.
This posting is provided "AS IS" with no warranties, and confers no rights.
Please send me your feedback at girishs@.microsoft.com
-------
No comments:
Post a Comment