Community
Showing results for 
Search instead for 
Do you mean 
Reply

SQL Server 2014 x64 Installation fails

Accepted Solution Solved
Copper Contributor
Posts: 36
Country: United_Kingdom
Accepted Solution

SQL Server 2014 x64 Installation fails

Hi All

 

I have a problem installing SQL 2014 Express on a Windows 2012 r2 server.  I have run the install from the download as normal but SQL failed to start.

 

I have removed all installed applications from Programs and Features (SQL & ACT) then restarted the server.  If I run a manual SQL install to create the 'SQL ACT7 Instance'  SQL installation fails.

 

  • Database Engine Services          'Failed'
  • SQL Browser                               'Failed'
  • SQL Writer                                  'Succeeded'
  • SQL Client Connectivity              'Succeeded'
  • SQL Client Connectivity SDK     'Succeeded'

(see attached screen shot)

 

The failed Database Engine Services failure seems to relate to .NET Framework 3.5 

  1. Error code: 0x85940001

The failed SQL Browser

  1. Error code: 0x84BB0001

 

Any thoughts greatly appreciated.

 

ACT! v20.0.159.0 installation on Windows Server 2012 r2

 

Thanks in advance

david


Accepted Solutions
Solution
Accepted by topic author David Hunter
‎07-26-2018 01:57 AM
Nickel Elite Contributor
Posts: 595
Country: Germany

Re: SQL Server 2014 x64 Installation fails

Had this problem a while ago as well.

Something is VERY WRONG with this server, permissions have been manipulated deeply.

 

Solution is here:

 

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0538735d-864c-4f62-bcb3-485506ea2200/sql-se...

 

Workaround 2 did it for me:

As a workaround for the problem you can run the following command at the command prompt to reset the permissions in registry rather than rebuilding the box:

SECEDIT /CONFIGURE /CFG %WINDIR%\INF\DEFLTBASE.INF /DB DEFLTBASE.SDB /VERBOSE /AREAS REGKEYS

 

Disclaimer: The above command would revert all security settings to the default and thus may be used as a workaround to avoid rebuilding the server.

 

 

Andreas Schlesselmann
Melville-Schellmann GbR
Germany
www.melville-schellmann.de

View solution in original post


All Replies
Nickel Elite Contributor
Posts: 595
Country: Germany

Re: SQL Server 2014 x64 Installation fails

Got to the Server administration dashboard. Choose add roles & features

Step through until you see a .Net3.5 checkbox. Enable the Feature.

Sorry for the German screenshot, I don't have an appropriate test system at hand.

post.jpg

 

 

Andreas Schlesselmann
Melville-Schellmann GbR
Germany
www.melville-schellmann.de
Employee
Posts: 14
Country: United_Kingdom

Re: SQL Server 2014 x64 Installation fails

Hello David,

The above post from Melville is a step I would suggest to try.

If that doesn't work, then I would recommend trying to install the program in a new windows user. Note: The user should be an administrator.

Regards

Dan
Copper Contributor
Posts: 36
Country: United_Kingdom

Re: SQL Server 2014 x64 Installation fails

Thanks for this.

 

I tried to add .NET 3.5 as suggested above but ran in to an error over location of files.  I am doing this remotely so need the client to put the DVD in so I can set source location.

 

Will try again later and let you know how I get on.

 

david

Copper Contributor
Posts: 36
Country: United_Kingdom

Re: SQL Server 2014 x64 Installation fails

 

I have installed .NET 3.5 on the server 2012 r2.

 

Before re-installing I tried to uninstall all SQL components.  When uninstalling 'Microsoft SQL Server 2014 Setup (English)'  I get the following error:

 

Warning 26003.  Microsoft SQL Server 2014 Setup Support Files cannot be uninstalled because the following products are installed:

SQL Server 2014 Common Files

Microsoft SQL Server 2014 RsFz Driver

SQL Server 2014 Database Engine Shared

SQL Server 2014 Database Engine Services

 

All other SQL components have been removed from Programs and Features.  If I try a re-install , setup fails on 'Database Engine Services'

 

I have tried to remove all again and get the same error  when uninstalling 'Microsoft SQL Server 2014 Setup (English)'

 

Any thoughts please

 

Thanking you in advance.

Bronze Elite Contributor
Posts: 1,779
Country: United_Kingdom

Re: SQL Server 2014 x64 Installation fails

[ Edited ]

David,

 

To uninstall SQL 2014 you only need to go to Programs and Features and select Microsoft SQL Server 2014 (64bit) or (32bit).

 

That will do the job and nothing else is needed.

 

You do not need to uninstall Microsoft SQL Server 2014 Setup (English).

 

Have you gone to an Act! Certified Consultant to look at this?

 

Hope this helps.


David Shaw
Act! Certified Consultant since 2001
Office:    +44 (0)1483 714507
Mobile: +44 (0)7977 567 318
E-Mail:    dshaw@act4u.org 
Copper Contributor
Posts: 36
Country: United_Kingdom

Re: SQL Server 2014 x64 Installation fails

Thank you.

 

I did but was left with 'Microsoft SQL Server 2014 Setup (English)' which will not uninstall.

 

see screen shot of Program and Features.  When I try to uninstall I get the errors in the above post.

 

david

Nickel Elite Contributor
Posts: 595
Country: Germany

Re: SQL Server 2014 x64 Installation fails

You will have to remove especially the strange „driver“ named Microsoft SQL Server 2014 RsFz Driver

To do this I regularly use a very old Microsoft tool named “msicuu2.exe”

A Google search should turn up download possibilities.

The tool needs to be installed by running the exe file (as Admin).

It will show a list much more detailed than the list of installed programs

You can then choose entries to be removed:

 

msciuu.jpg

Andreas Schlesselmann
Melville-Schellmann GbR
Germany
www.melville-schellmann.de
Copper Contributor
Posts: 36
Country: United_Kingdom

Re: SQL Server 2014 x64 Installation fails

Hi All

 

I seem to be lurching from one challenge to another.

 

Thank you Melville, I used the 'msicuu2'.exe to remove the drivers and rebooted the server.

 

I tried re-installing and got the following errors whilst SQL was installing.

 

I found the entries in the Registry and tried to change permissions but was not allowed.  I am logged on the server as Administrator.  They won't delete either.  The installation rolls back after.

 

2.png1.png

 

Any thoughts please.

 

 

Silver Super Contributor
Posts: 2,206
Country: United_Kingdom

Re: SQL Server 2014 x64 Installation fails

This is looking more and more like a permissions problem during the installation / removal. I have run into problems before when using remote access to a server with the SQL part of the installation. I recommend that you log onto the server with a Local Administrator account for that machine (You may need to create one) and then trying again to see if you can remove the SQL completely and then do a new ACT installation from scratch.