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

SQLEXPRESS 2012 install fails

I'm trying to install Sqlexpress 2012 with management tools on a 2008 R2 server.  It fails with "could not open key" error.  See attached.

Any help will be appreciate
sqlexpress.png
0
J.R. Sitman
Asked:
J.R. Sitman
  • 7
  • 5
  • 3
  • +1
1 Solution
 
David Johnson, CD, MVPOwnerCommented:
right click on the installer and run as administrator..
0
 
J.R. SitmanAuthor Commented:
just tried it.  Didn't work.  I even tried a different version. the first was sqlexpress with tools. This time is was just sqlexpress SP2
0
 
J.R. SitmanAuthor Commented:
What if I try the upgrade instead of a fresh install?  I just need to make sure nothing in my current SQL will change.
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 
David Johnson, CD, MVPOwnerCommented:
You probably should have been doing an upgrade rather than a fresh install.. You do have the prerequisites i.e. .net 4 and so forth.
0
 
J.R. SitmanAuthor Commented:
Yes, prerequisites are installed
0
 
J.R. SitmanAuthor Commented:
just tried the upgrade "exact" same error
0
 
David Johnson, CD, MVPOwnerCommented:
There are a few things to try @ http://blogs.msdn.com/b/sqlserverfaq/archive/2010/03/30/sql-server-2008-setup-fails-to-install-with-error-1402.aspx
Work Around #3
Another possible solution is for the ‘Administrator’ account to take ownership of HKEY_LOCAL_MACHINE registry hive. Owner can be found under Permissions->Advanced
0
 
Philip ElderTechnical Architect - HA/Compute/StorageCommented:
Suggestion: Click START then type: CMD.

CTRL + SHFT + ENTER

UAC

In the command line:

Navigate to the setup file and SETUP [ENTER]
0
 
NARANTHIRANCommented:
Disable the Virus scanner and try installing.
0
 
J.R. SitmanAuthor Commented:
Taking ownership of the reg key didn't work.

Disabling AV didn't work.

@Phillip Elder, Your suggestion is not clear.  in the CMD when I do CTRL+SHIFT+ENTER nothing happens.  When I type UAC it states not recognized.  Please explain
0
 
Philip ElderTechnical Architect - HA/Compute/StorageCommented:
Step 1: Click on START then type CMD

When the little black icon comes up in search results make sure it is highlighted and hit CTRL+SHFT+ENTER on the keyboard

This will prompt to Run As Admin (UAC)

Navigate to the Setup.EXE file

Setup.EXE [ENTER]


The above will run the installer in a full admin context (there are differences to running via right click in Explorer - witness the issues we had with early Exchange 2010 SPs and URs).
0
 
J.R. SitmanAuthor Commented:
ok, tried it.  Same exact error.
0
 
Philip ElderTechnical Architect - HA/Compute/StorageCommented:
Right click on the downloaded file and Properties. Is there an UNBLOCK button under the ADVANCED button?

If yes, click that and then APPLY and OK.

Run As Admin or via the CMD process above.
0
 
Philip ElderTechnical Architect - HA/Compute/StorageCommented:
And finally, while for a Symantec product, this should get you through to a successful install:

http://www.symantec.com/business/support/index?page=content&id=TECH135922
0
 
J.R. SitmanAuthor Commented:
Finally is right.  What a nightmare.  #3 in the link worked.  THANKS so much.
0
 
Philip ElderTechnical Architect - HA/Compute/StorageCommented:
Welcome. :)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 7
  • 5
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now