07-18-2018 03:10 PM
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.
(see attached screen shot)
The failed Database Engine Services failure seems to relate to .NET Framework 3.5
The failed SQL Browser
Any thoughts greatly appreciated.
ACT! v22.214.171.124 installation on Windows Server 2012 r2
Thanks in advance
07-23-2018 12:29 AM
Had this problem a while ago as well.
Something is VERY WRONG with this server, permissions have been manipulated deeply.
Solution is here:
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.
07-19-2018 01:32 AM
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.
07-19-2018 01:46 AM
07-19-2018 10:53 AM
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.
07-20-2018 12:09 AM
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.
07-20-2018 12:19 AM - edited 07-20-2018 12:22 AM
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.
07-20-2018 12:26 AM
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.
07-20-2018 12:28 AM
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:
07-21-2018 03:44 AM
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.
Any thoughts please.
07-21-2018 04:22 AM
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.