SQL server 2005 express setup fails unexpectedly

[Martin]

On my W2k machine the installation process of SQK Server 2005 Express aborts
with: "SQL server setup unexpectedly failed".

I already deinstalled the Beta and SQL Server 7 from this host, still
without succes.

The setup process writes the following log entries shown below.

Any help is appreciated!

Best regards,
Martin

----------------
Summary.txt:
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows 2000 Professional Service Pack 4 (Build
2195)
Time : Thu Jan 12 12:31:04 2006

----------------
SQLsetup0001_...._Core.log:
Microsoft SQL Server 2005 Setup beginning at Thu Jan 12 12:31:04 2006
Process ID : 676
c:\667892ed0de754ae9ea6eda6713f7e\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/0/12 12:31:4
Complete: LoadResourcesAction at: 2006/0/12 12:31:4, returned true
Running: ParseBootstrapOptionsAction at: 2006/0/12 12:31:4
Loaded DLL:c:\667892ed0de754ae9ea6eda6713f7e\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/0/12 12:31:4, 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: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x800706b5 (1717)
Windows Error Text: The interface is unknown. Source File Name:
cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50

1717
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope",
"", "676"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2006/0/12 12:31:4
Complete: ValidateWinNTAction at: 2006/0/12 12:31:4, returned true
Running: ValidateMinOSAction at: 2006/0/12 12:31:4
Complete: ValidateMinOSAction at: 2006/0/12 12:31:4, returned true
Running: PerformSCCAction at: 2006/0/12 12:31:4
Complete: PerformSCCAction at: 2006/0/12 12:31:4, returned true
Running: ActivateLoggingAction at: 2006/0/12 12:31:4
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: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
02AFCFC4Unable 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: Fri Jul 29 01:13:50 2005
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: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "",
"676"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

[Michael Cheng [MSFT]]

Hi Martin,

Welcome to use MSDN Managed Newsgroup!

From your descriptions, I understood you cannot install SQL Server 2005
Express Edition with the error message

Complete: ParseBootstrapOptionsAction at: 2006/0/12 12:31:4, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error
information reported during run:

If I have misunderstood your concern, please feel free to point it out.

First of all, since you have installed beta version of SQL Server 2005
before, please use Windows Installer CleanUp to remove the possible
remainings in your system.

Description of the Windows Installer CleanUp Utility
http://support.microsoft.com/kb/290301/en-us

Secondly, would you please let me know

1. Does you login account has local administrator privilege?
2. Are you installing the SQL Server 2005 Express on failover clustering
node?
3. Whether you have use this installation CD/package to make a complete
install of SQL Server 2005 Express successfully?

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

[Martin]

Hi Michael,

> From your descriptions, I understood you cannot install SQL Server 2005
> Express Edition with the error message
>
> Complete: ParseBootstrapOptionsAction at: 2006/0/12 12:31:4, returned false

Well, the error message is so long that I don't know which part is really
relevant, but I hope somebody at MS is able to interpret that error log entry.

> First of all, since you have installed beta version of SQL Server 2005
> before, please use Windows Installer CleanUp to remove the possible
> remainings in your system.

I did use some tool offered by MS to remove the Express beta versions. I
have to check whether it was this specific tool you mention.

> 1. Does you login account has local administrator privilege?

Yes. I also installed Visual Web Dev Express without error message during
installation.

> 2. Are you installing the SQL Server 2005 Express on failover clustering
> node?

No. Normal laptop.

> 3. Whether you have use this installation CD/package to make a complete
> install of SQL Server 2005 Express successfully?

No. I tried to install form downloaded file.

Thanks.

Best regards,
Martin

[Martin]

> > First of all, since you have installed beta version of SQL Server 2005
> > before, please use Windows Installer CleanUp to remove the possible
> > remainings in your system.
> I did use some tool offered by MS to remove the Express beta versions. I
> have to check whether it was this specific tool you mention.

I used Windows installer clean-up now and removed everything that had SQL in
the name. Still the same result:
- The files are extracted into a temp directory
- The error message is shown
- the temp directory is deleted

Best regards,
Martin

[Michael Cheng [MSFT]]

Hi Martin,

ParseBootstrapOptionsAction is an internal API call and usually it is
caused on SQL Server failover clustering so it's strange that you
installation on laptop report this error message.

To find out the root cause of this issue we need to analyze memory dumps,
this work has to be done by contacting Microsoft Customer Service and
Support. Therefore, we probably will not be able to resolve the issue
through the newsgroups. If the issue is urgent, I recommend that you open a
Support incident with Microsoft Customer Service and Support so that a
dedicated Support Professional can assist with this case. If you need any
help in this regard, please let me know.

For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:

http://support.microsoft.com/directory/overview.asp

[ScottZ]

Did you ever reach a resolution on this issue? I am having the identical
problem and would like to know how to fix it. Thx.

[Martin]

No, I tore out all remainders of previous SQl Server and Visual Studio
installations on the computer according to various instructions found on the
Internet, even increased the main memory of the laptop, but still no success.
It's a real pain.

I have sort of given up my hope of getting any help from MS on this.

BR/Martin

[Peter Yang [MSFT]]

Hello Martin,

From the log sqls::CryptSameUserSameMachine::ProtectData, it seems the
issue is related crypto subsystem of the OS has become damaged. You may try
the following article to test the sitaution:

You receive error message 0x80090016 or error message 0x8009000f when you
try to schedule a task
http://support.microsoft.com/default.aspx?scid=kb;en-us;246183

Also, you may want to re-apply Win2000 SP4 and try the SQL express setup
again.

As Michael mentioned, since the issue is cuased by internal API call, to
find the root cause, please contact CSS directly so that they may find some
clues by dump analysis or live debug. Thanks for your understanding.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA

[Martin]

Hello Peter,

Great! That was the solution: The Protected Storage service was not running
on my computer. Now it installed and works perfectly.

Thanks a lot!

Best regards,
Martin

[Peter Yang [MSFT]]

Hello Martin,

Welcome! Great to see the issue is resolved. :-)

[Rouse@discussions.microsoft.com Arron Rouse]

I had this problem too but Protected Storage was on. The error in the log
file was the same. After trying all of the possible solutions I could from
around the web and it still not working, I was tearing my hair out. This was
on a customer's custom Windows 2000 Pro build.

After a good amount of delving with RegMon, I found out why it was not
installing on my customer's build: there was a missing registry key.

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User
Shell Folders\AppData

When a user is created on a system, the AppData key is copied from the
.Default area of the registry:

HKEY_USERS\.DEFAULT\Software\Microsoft\Windows\CurrentVersion\Explorer\User
Shell Folders\AppData

It seems the key had been messed up in my customer's build. Both should be a
REG_EXPAND_SZ and both should be set to %USERPROFILE%\Application Data

Note that if the key is missing on your system, you might have problems when
you put it back in as many programs seem to failover to using the Local
AppData key if it's missing. You might have to set the AppData key to
%USERPROFILE%\Local Settings\Application Data

Arron

[evangelist@discussions.microsoft.com eCopy evangelist]

Same thing on a fairly fresh XP Pro sp2. Visual Studio 2005 Pro
pre-installed without MSDE 2005 EE.

Adding the key solved the problem.

/JJ

"Arron Rouse" skrev:

[Neal]

Thank you so much!!! I have been struggling with this for over a week.

--
Neal Ganslaw
MCP | MCAD.NET | MCDBA

*** Sent via Developersdex http://www.developersdex.com ***

[john weidauer]

praise Jesus, and Arron Rouse, for this one. Thank you. I even
un-installed the entire Dev Env and started all over and same thing,
dang registry.

Thanks.

[Agbi Bajrushi]

I've actually been having a problem with SQL Server also. The Company I
work for just recently joined the Microsoft Developers Program and I was
trying to install Accounting Professional 2007. Apparantly SQL Server
2005 is needed to run this (maybe so more than one user can see the
records for the company).

Anyway, I try to install, but SQL Server installation fails and then the
rest fails because that is needed. I will post the most recent Setup Log
and hopefully someone here will be able to help me out. I tried
virtually everything to fix this (That which was posted in this thread).
I looked on the Microsoft page also to see if this was a common problem,
but those solutions didn't work either. I'm also having an issue with
Windows Update (that whole genuine advantage thing. I don't think it
works right on my computer) I wonder if these are related issues.

Microsoft SQL Server 2005 Setup beginning at Mon Jul 30 00:38:21 2007
Process ID : 1632
d:\9d36de797de171c84e579477d421\setup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2007/6/30 0:38:20
Complete: LoadResourcesAction at: 2007/6/30 0:38:20, returned true
Running: ParseBootstrapOptionsAction at: 2007/6/30 0:38:20
Loaded DLL:d:\9d36de797de171c84e579477d421\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/6/30 0:38:21, 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 Oct 26 16:38:20 2005

Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp

Compiler Timestamp: Wed Oct 26 16:38:20 2005

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 Oct 26 16:37:25 2005

Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50

2

Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp

Compiler Timestamp: Wed Oct 26 16:37:20 2005

Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath"

{"SetupBootstrapOptionsScope", "", "1632"} in cache

Source File Name: datastore\propertycollection.cpp

Compiler Timestamp: Wed Oct 26 16:37:21 2005

Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"

Running: ValidateWinNTAction at: 2007/6/30 0:38:21
Complete: ValidateWinNTAction at: 2007/6/30 0:38:21, returned true
Running: ValidateMinOSAction at: 2007/6/30 0:38:21
Complete: ValidateMinOSAction at: 2007/6/30 0:38:21, returned true
Running: PerformSCCAction at: 2007/6/30 0:38:21
Complete: PerformSCCAction at: 2007/6/30 0:38:21, returned true
Running: ActivateLoggingAction at: 2007/6/30 0:38:21
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 Oct 26 16:37:20 2005

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 Oct 26 16:37:21 2005

Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"

00E2CFC0Unable 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 Oct 26 16:37:21 2005

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 Oct 26 16:37:20 2005

Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "",

"1632"} in cache

Source File Name: datastore\propertycollection.cpp

Compiler Timestamp: Wed Oct 26 16:37:21 2005

Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

Sorry this post was so long. I'm sure someone here can help.

Thanks in advance!

[anote2chris]

This totally worked!! My error was on WIN XP Pro sp2 with SQL Server
2005 Standard sp2. Up until a few weeks ago, things had been working
perfectly fine, but then this error started when I tried to open tables
or look at DB diagrams through SSMS:

Could not find the specified file. (SQLEditors)

So, as I found out through research on other posts, the fix was to
uninstall and reinstall sql server 2005. Unfortunately, I was getting
another error (presumably related) that said that I couldn't uninstall
the software. The error was error_code 50000 and related to
sqleditor.rll with at
utillib\persisthelpers.cpp@ActivateLoggingAction@writeEncryptedString@0x
2.

This fix worked to solve that problem even though the Local AppData key
was present and the AppData keyword was set to the same value as the
Local AppData key. Weird, but what a relief to get it working.

THANKS!!!

[Sikander Iqbal]

Thanks!

This fix worked on Windows Server 2003 Enterprise Edition as well.

[Hugo Alva]

Hi,

Adding

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Us
er Shell Folders\AppData

solved the problem.

It was a PC with preinstalled XP Pro SP2.

Thanks a lot.

[Laura Grob]

I am hitting the same issue on a sql 2005 cluster install. Is there
anything different for that scenario? I checked the services on both
nodes and the Protected storage service is running. The o/s is windows
2003 sp2. Both servers have the registry values set to c:\documents and
settings\%userid%\Application data

[Narine Kostandyan]

Hi Laura,

Did you ever fix the problem with the sql 2005 cluster installtion? I
ran into the same exact issue and if you've found a workaround for it.

Thank You!

[leya Miat]

To All:

for the last dew days, I have been getting the same error message
as previously stated. I am using a virtual drive , which are pointing
back to the first Node. I have checked my registry and pointing to my
%USERPROFILE%\Application Data
Nd still getting the same error.

Any help will be highly appreciate it.

Microsoft SQL Server 2005 Setup beginning at Mon Oct 05 10:34:15 2009
Process ID : 4664
\\MASIMPDB04\c$\SQLServer2005\Servers\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2009/9/5 10:34:15
Complete: LoadResourcesAction at: 2009/9/5 10:34:15, returned true
Running: ParseBootstrapOptionsAction at: 2009/9/5 10:34:15
Loaded DLL:\\MASIMPDB04\c$\SQLServer2005\Servers\xmlrw.dll
Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2009/9/5 10:34:15, 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: Fri Jul 29 01:13:55 2005

Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp

Compiler Timestamp: Fri Jul 29 01:13:55 2005

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: Mon Jun 13 14:30:00 2005

Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp

Compiler Timestamp: Fri Jul 29 01:13:49 2005

Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath"

{"SetupBootstrapOptionsScope", "", "4664"} in cache

Source File Name: datastore\propertycollection.cpp

Compiler Timestamp: Fri Jul 29 01:13:50 2005

Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"

Running: ValidateWinNTAction at: 2009/9/5 10:34:15
Complete: ValidateWinNTAction at: 2009/9/5 10:34:15, returned true
Running: ValidateMinOSAction at: 2009/9/5 10:34:15
Complete: ValidateMinOSAction at: 2009/9/5 10:34:15, returned true
Running: PerformSCCAction at: 2009/9/5 10:34:15
Complete: PerformSCCAction at: 2009/9/5 10:34:15, returned true
Running: ActivateLoggingAction at: 2009/9/5 10:34:15

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: Fri Jul 29 01:13:49 2005

Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in
cache
Source File Name: datastore\propertycollection.cpp

Compiler Timestamp: Fri Jul 29 01:13:50 2005

Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"

0000000000FBAF90Unable 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: Fri Jul 29 01:13:50 2005

Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.

[Aaron Bertrand]

Is the "protected storage" service started? While your specific error is
not mentioned in the KB, this *could* be a contributing factor.

http://support.microsoft.com/kb/246183/

On 10/5/09 12:11 PM, in article O7KkGadR...@TK2MSFTNGP06.phx.gbl, "leya
Miat" <lmi...@yahoo.com> wrote:

> 0x80070002