[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 751
  • Last Modified:

SQL SERVER Install error message: Key not valid for use in specified state

Hello All,

I am trying to install Microsoft SQL Server 2005 Express and keep getting this error message.

All help would be sincedrely appreciated: (here's the message)

Windows Error Text: Key not valid for use in specified state.

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50

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
Could not parse command line due to datastore exception.
1 Solution
It appears as though an API in the CryptAPI subsystem is failing.  This can be caused by either a problem with the cryptographic services, or with ACL permissions on a directory.  Please try each of the following, attempting setup between each:

1/ Make sure that the Folder from where SQL Setup is being run is Shared with Full
permissions to everyone

2/  Setup MSDTC as a clustered resource if you are installing onto a cluster.

3/ If the above does not work then this could be a problem with cryptographic
services and for that we can use the following KB::

4/ Repair CryptAPI
regsvr32 /s softpub.dll
regsvr32 /s wintrust.dll
regsvr32 /s initpki.dll
regsvr32 /s dssenh.dll
regsvr32 /s rsaenh.dll
regsvr32 /s cryptdlg.dll
regsvr32 /s gpkcsp.dll
regsvr32 /s sccbase.dll
regsvr32 /s slbcsp.dll
regsvr32 /s urlmon.dll
regsvr32 /s shdocvw.dll
regsvr32 /s msjava.dll
regsvr32 /s browseui.dll
regsvr32 /s mshtml.dll
regsvr32 /s jscript.dll
regsvr32 /s vbscript.dll
net stop cryptsvc
ren %systemroot%\system32\catroot catold ren %systemroot%\system32\catroot2 cat2old
net start cryptsvc

Hope this will solve your problem.

Chetan Sachdeva
paygoAuthor Commented:
Thanks for the Help. I needed to Log In as Administrator.

Then I deleted the CRPT files in DocumentsandSettings/AllUsers................ as the artice describes.



Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now