system cannot find the file specified when starting SQL Server service

From: Jonathan Bondoc (shocker618_at_hotmail.com)
Date: 09/30/04


Date: 30 Sep 2004 06:52:26 -0700

I am trying to start the SQL Server service and I get "system cannot
find the specified file". Any help is appreciated? Thank you.
  
Specs: Windows XP Home SP1/MDAC 2.8/File and Printer sharing
enabled/Admin rights

1. sql is stopped, when tries to start it gets "your installation is
either corrupt or has been tampered with"
2. Uninstall SQL Server 2000 SP3A
3. Removed Reg Keys:
        SOFTWARE\Microsoft\MSSQLServer
        SOFTWARE\Microsoft\Microsoft SQL Server
        SOFTWARE\Microsoft\SQL Redist
        SYSTEM\CurrentControlSet\Services\MSSQLServer
        SYSTEM\CurrentControlSet\Services\SQLServerAgent
        SYSTEM\CurrentControlSet\Services\MSSQLServerADHelper
4. Restarted PC
5. Reinstalled SQL Server 2000 SP3A
6. When I try to start the service, it says "system cannot find the
file specified"

Logfile
-----------
Action ended 21:43:09: InstallValidate. Return value 1.
MSI (s) (20:9C): Doing action:
UpgDetectBlankSaLogin.2D02443E_7002_4C0B_ABC9_EAB2C064397B
Action start 21:43:09:
UpgDetectBlankSaLogin.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
MSI (s) (20:9C): Creating MSIHANDLE (142) of type 790542 for thread
412
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\Owner\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Owner\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action UpgDetectBlankSaLogin()
Entering Function MyMsiEvaluateCondition
MsiEvaluateCondition for VersionNT returned TRUE
End Function MyMsiEvaluateCondition
An error was encountered during connection to server: 2
Ending custom action UpgDetectBlankSaLogin().
Action ended 21:43:19:
UpgDetectBlankSaLogin.2D02443E_7002_4C0B_ABC9_EAB2C064397B. Return
value 3.
Action ended 21:43:19: INSTALL. Return value 3.
MSI (s) (20:9C): Note: 1: 2262 2: Control 3: -2147287038
Property(S): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
Property(S): SqlDataDir = C:\Program Files\Microsoft SQL Server\
Property(S): SqlProgramDir = C:\Program Files\Microsoft SQL Server\
Property(S): SqlInstanceName = MSSQLSERVER
Property(S): SqlSecurityMode = SQL
Property(S): SqlSa...
Property(S): SqlDisableNetworkProtocols = 0
Property(S): VersionNT = 501
Property(S): ALLUSERS = 1
Property(S): ARPNOMODIFY = 1



Relevant Pages

  • Re: Fresh installation
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... CREATE DATABASE permission denied in database 'master'. ... name exists, or specified file cannot be opened, or it is located on UNC ...
    (microsoft.public.dotnet.framework.adonet)
  • problem upgrading msde to sql server 2000 standard
    ... I'm attempting to upgrade a default instance of MSDE SP3 to SQL Server ... When I launch the setup utility (Autoplay the CD), ... The system cannot find the specified file. ...
    (microsoft.public.sqlserver.setup)
  • MSDE 2000 SP4 install gets to very end then rolls it all back
    ... On most machines my msde install goes fine. ... exuisting SQL server. ... Starting custom action SaveSqlServerServiceStates() ... Action start 14:23:53: RegisterClassInfo. ...
    (microsoft.public.sqlserver.setup)
  • Re: error installing msde rel a
    ... SOFTWARE\Microsoft\Microsoft SQL Server ... Starting custom action ConfigServer ... Rollback: ConfigServer.2D02443E_7002_4C0B_ABC9_EAB2C064397B... ... Property: ProductLanguage = 1033 ...
    (microsoft.public.sqlserver.msde)
  • Re: file backup component
    ... Otherwise you can try to use audit techniques to find out who's trying to access the LDF file. ... file backup app or any other app that need LDF file a while. ... he meant something that belongs to the SQL server itself. ... Delay the start of the SQL server service until manual start. ...
    (microsoft.public.windowsxp.embedded)

Loading