SQL Server Setup Unexpectedly Failed

  • Pls help, I cant install the SQL Server Express Edition.  Any idea, thank you...  I have done a lot of things already.  Some people say it is a cryptographic services. Some says Create a directory Servers and Tools. Some people say about Protected Storage.  Some people say to delete the files on CRYPTO directory.  I did all of these  advise but still cant install SQL Server Express Ed.  Pls Help...

    Here is the error log:

    FILENAME:  SQLSetup0013_VICRIZA_Core

    Microsoft SQL Server 2005 Setup beginning at Sun Sep 16 02:45:46 2007

    Process ID      : 1072

    C:\sqlserver2005express\Servers\setup.exe Version: 2005.90.3042.0

    Running: LoadResourcesAction at: 2007/8/16 2:45:46

    Complete: LoadResourcesAction at: 2007/8/16 2:45:46, returned true

    Running: ParseBootstrapOptionsAction at: 2007/8/16 2:45:46

    Loaded DLL:C:\sqlserver2005express\Servers\xmlrw.dll Version:2.0.3609.0

    Complete: ParseBootstrapOptionsAction at: 2007/8/16 2:45:46, returned false

    Error: Action "ParseBootstrapOptionsAction" failed during execution.  Error information reported during run:

    Could not parse command line due to datastore exception.

      Source File Name: utillib\persisthelpers.cpp

    Compiler Timestamp: Wed Jun 14 16:30:14 2006

         Function Name: writeEncryptedString

    Source Line Number: 124

    ----------------------------------------------------------

    writeEncryptedString() failed

       Source File Name: utillib\persisthelpers.cpp

     Compiler Timestamp: Wed Jun 14 16:30:14 2006

          Function Name: writeEncryptedString

     Source Line Number: 123

     ----------------------------------------------------------

             Error Code: 0x80070002 (2)

    Windows Error Text: The system cannot find the file specified.

      Source File Name: cryptohelper\cryptsameusersamemachine.cpp

    Compiler Timestamp: Wed Jun 14 16:28:04 2006

         Function Name: sqls::CryptSameUserSameMachine:rotectData

    Source Line Number: 50

    2

    Could not skip Component update due to datastore exception.

      Source File Name: datastore\cachedpropertycollection.cpp

    Compiler Timestamp: Wed Jun 14 16:27:59 2006

         Function Name: CachedPropertyCollection::findProperty

    Source Line Number: 130

    ----------------------------------------------------------

    Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "1072"} in cache

       Source File Name: datastore\propertycollection.cpp

     Compiler Timestamp: Wed Jun 14 16:28:01 2006

          Function Name: SetupBootstrapOptionsScope.InstallMediaPath

     Source Line Number: 44

     ----------------------------------------------------------

     No collector registered for scope: "SetupBootstrapOptionsScope"

    Running: ValidateWinNTAction at: 2007/8/16 2:45:46

    Complete: ValidateWinNTAction at: 2007/8/16 2:45:46, returned true

    Running: ValidateMinOSAction at: 2007/8/16 2:45:46

    Complete: ValidateMinOSAction at: 2007/8/16 2:45:46, returned true

    Running: PerformSCCAction at: 2007/8/16 2:45:46

    Complete: PerformSCCAction at: 2007/8/16 2:45:46, returned true

    Running: ActivateLoggingAction at: 2007/8/16 2:45:46

    Error: Action "ActivateLoggingAction" threw an exception during execution.  Error information reported during run:

    Datastore exception while trying to write logging properties.

      Source File Name: datastore\cachedpropertycollection.cpp

    Compiler Timestamp: Wed Jun 14 16:27:59 2006

         Function Name: CachedPropertyCollection::findProperty

    Source Line Number: 130

    ----------------------------------------------------------

    Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache

       Source File Name: datastore\propertycollection.cpp

     Compiler Timestamp: Wed Jun 14 16:28:01 2006

          Function Name: SetupStateScope.primaryLogFiles

     Source Line Number: 44

     ----------------------------------------------------------

     No collector registered for scope: "SetupStateScope"

    02B0CFC0Unable to proceed with setup, there was a command line parsing error. : 2

            Error Code: 0x80070002 (2)

    Windows Error Text: The system cannot find the file specified.

      Source File Name: datastore\propertycollection.cpp

    Compiler Timestamp: Wed Jun 14 16:28:01 2006

         Function Name: SetupBootstrapOptionsScope.InstallMediaPath

    Source Line Number: 44

    Class not registered.

    Failed to create CAB file due to datastore exception

      Source File Name: datastore\cachedpropertycollection.cpp

    Compiler Timestamp: Wed Jun 14 16:27:59 2006

         Function Name: CachedPropertyCollection::findProperty

    Source Line Number: 130

    ----------------------------------------------------------

    Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "1072"} in cache

       Source File Name: datastore\propertycollection.cpp

     Compiler Timestamp: Wed Jun 14 16:28:01 2006

          Function Name: SetupBootstrapOptionsScope.HostSetup

     Source Line Number: 44

     ----------------------------------------------------------

     No collector registered for scope: "SetupBootstrapOptionsScope"

    Message pump returning: 2

  • PLS... ANYBODY... HELP...

  • Vic,

    Never seen anything like that. What are you installing on? (OS/SP), any other SQL services?

  • Hi Steve,

    Thanks for your reply, appreciate it so much...  My OS is Windows XP Home Edition SP2. With 2GB RAM, Dual-Core Processor. I think I have met the SQL Server Express Ed reqt.  Yes, I have installed some SQL Services like Oracle and MySQL.  My goal is to learn the basics of these SQL Services since I am pursuing a career in Business Intelligence.  I really dont know if these SQL Services conflicts the installation. Does it?

     

     

  • Vic, open up your Services window and check the service named Protected Storage. It should be running. If not, that's the likely culprit, so start it up and try again.

    Also, while I'm guessing you're past this point already, I'll toss it out just in case. Make sure you are logged on with an administrator account.

    If the above doesn't solve this, you might want to post it in a different forum, such as SQLServer 2005 Express forum, as this is likely one of the least read forums on the board (other than Steve, who might actually wander in here ).

  • Hi David,

    I did checked the services.msc and Protected Storage is running.  I am also logged on as Administrator. 

    I already posted this issue in MSDN Forum under the SQL Server Setup and Upgrades, here are the links: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2000565&SiteID=1 and http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1981932&SiteID=1.  It is sad that nobody really replied on this issue.

    I even attempted to call Microsoft and they said that they can help me but of course with a fee.  I am not really ready to pay them hourly just to install the express edition.

    If you have any other ideas please let me know... Thanks for your time and effort...

  • No idea on what's wrong. Any chance you can grab a copy of Virtual PC, setup a machine and install it in there? There might be some conflict, though it seems more like an OS conflict of some sort from your first post.

  • Hello!

    Amy Lewis from SQL Server Team found a workaround for this problem. This is his explanation:

    "Setup failed to call CryptProtectData API that returned error 2 (The system cannot find the file specified). This is most likely because some Crypto registry keys used the user profile are corrupted. A workaround could be to create a new user on that machine, add this new user to the administrator group, logon as this new user and rerun the setup under the new account."

    Regards

    Anton Kalcik

  • Creating a local account worked for me.

    Many thanks.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply