sql server msde: Hello,

I'm attempting to install MSDE SP3 (and SP4) on a 2000 SP4 Server that is
configured as a file server and a secondary DC/DNS server on an ADS domain
(whose GCS is a 2003 Server). This is a new installation that never had SQL
installed (I rebuilt this file server recently). MSDE SP3 shipped with
Backup Exec 10d as the database that stores the backup catalogs. During the
Backup Exec install, the MSDE installation fails. When I attempt to install
MSDE manually, the installation again fails. I then ran the installation at
the command line with the following command (according to Veritas/Symantec
support):

Setup.exe INSTANCENAME=BKUPEXEC DISABLENETWORKPROTOCOLS=0 SAPWD=mypassword
TARGETDIR="E:\VERITAS\MSDE" /L*v C:\msde_BKUPEXEC.log

After this also failed, I downloaded MSDE SP4 from microsoft and attempted
to install this, which also failed. I checked the version of MDAC and
installed version 2.8, again attempting the installation, which as you
probably guessed, failed.

Here is some output from the msde installation log, where I isolated the
word "error". It seems like something is missing on the system, or corrupted
(condition is false), note that this latest is from the command line option
above where I named the instance BKUPEXEC. I am installing this as
Administrator.

MSI (s) (EC:FC) [19:05:13:414]: Skipping action:
ErrorCodeIE.2D02443E_7002_4C0B_ABC9_EAB2C064397B (condition is false)
MSI (s) (EC:FC) [19:05:13:414]: Skipping action:
FatalErrorIE.2D02443E_7002_4C0B_ABC9_EAB2C064397B (condition is false)

Action ended 19:05:13: GetSqlStates.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
Return value 1.
MSI (s) (EC:FC) [19:05:13:507]: Skipping action:
DetectUpgrade.2D02443E_7002_4C0B_ABC9_EAB2C064397B (condition is false)
MSI (s) (EC:FC) [19:05:13:507]: Skipping action:
SqlDisableNetAccessError.2D02443E_7002_4C0B_ABC9_EAB2C064397B (condition is
false)

MSI (s) (EC:FC) [19:05:14:054]: Skipping action:
ErrorCodeUpgrade.2D02443E_7002_4C0B_ABC9_EAB2C064397B (condition is false)
MSI (s) (EC:FC) [19:05:14:054]: Skipping action:
FatalErrorUpgrade.2D02443E_7002_4C0B_ABC9_EAB2C064397B (condition is false)

MSI (s) (EC:FC) [19:05:41:320]: Executing op:
ServiceInstall(Name=SQLAgent$BKUPEXEC,DisplayName=SQLAgent$BKUPEXEC,ImagePath=E:\VERITAS\MSDEMSSQL$BKUPEXEC\Binn\sqlagent.EXE
-i
BKUPEXEC,ServiceType=16,StartType=3,ErrorControl=1,,Dependencies=MSSQL$BKUPEXEC[~][~],,,,)

MSI (s) (EC:FC) [19:05:41:601]: Executing op:
ServiceInstall(Name=MSSQL$BKUPEXEC,DisplayName=MSSQL$BKUPEXEC,ImagePath=E:\VERITAS\MSDEMSSQL$BKUPEXEC\Binn\sqlservr.exe
-sBKUPEXEC,ServiceType=16,StartType=2,ErrorControl=1,,,,,,)

MSI (s) (EC:FC) [19:05:49:101]: Error in rollback skipped. Return: 5

MSI (c) (C4:F0) [19:05:49:304]: Note: 1: 1708
MSI (c) (C4:F0) [19:05:49:304]: Product: Microsoft SQL Server Desktop Engine
-- Installation operation failed.

MSI (c) (C4:F0) [19:05:49:320]: Grabbed execution mutex.
MSI (c) (C4:F0) [19:05:49:320]: Cleaning up uninstalled install packages, if
any exist
MSI (c) (C4:F0) [19:05:49:320]: MainEngineThread is returning 1603


Any help would be greatly appreciated, I cannot have a file server that does
not have a good backup program (yikes!).

--

Thanks for the fast response!

Ok, I have found that it is the "SQLAgentSecurity" component that is failing
during the installation:

SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (KNS04,LocalSystem,87).
Action ended 19:05:42: InstallFinalize. Return value 3.

Server service is running and file and printer sharing was enabled (or else,
I'd have some angry users!), it is a functioning file server.

Does this mean that an account cannot be created for the SQL Agent to run as
a service?

--
Thanks, Jeff


[quoted text, click to view]