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

2148073483
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.
paygoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

csachdevaCommented:
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::
http://support.microsoft.com/default.aspx?scid=kb;en-us;246183

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.

regards,
Chetan Sachdeva

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.

Thanks

Steve
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.