SQL Server express 2014 installation fails
Installing SQL Server Express 2014 on Server 2012 R2 Essentials and it fails the installation. The error message in the log is as follows.
Found some related material via Google the talks about TLS 1.2 but that did not resolve the problem
Any Help would be appreciated. The complete install log is attachedCertificate-error.txt
2020-03-28 12:52:10.39 spid11s Starting up database 'model'.
2020-03-28 12:52:10.41 spid11s Clearing tempdb database.
2020-03-28 12:52:10.45 spid11s Starting up database 'tempdb'.
2020-03-28 12:52:12.38 spid14s Error: 17190, Severity: 16, State: 1.
2020-03-28 12:52:12.38 spid14s Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0.
2020-03-28 12:52:12.38 spid14s Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
2020-03-28 12:52:12.38 spid14s Error: 17182, Severity: 16, State: 1.
2020-03-28 12:52:12.38 spid14s TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property.
2020-03-28 12:52:12.38 spid14s Error: 17182, Severity: 16, State: 1.
2020-03-28 12:52:12.38 spid14s TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property.
2020-03-28 12:52:12.38 spid14s Error: 17826, Severity: 18, State: 3.
2020-03-28 12:52:12.38 spid14s Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2020-03-28 12:52:12.38 spid14s Error: 17120, Severity: 16, State: 1.
2020-03-28 12:52:12.38 spid14s SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.Found some related material via Google the talks about TLS 1.2 but that did not resolve the problem
Any Help would be appreciated. The complete install log is attachedCertificate-error.txt
ASKER
The file path C:\ProgramData\Microsoft\C
Does not exist in fact Program Data does not exist
Does not exist in fact Program Data does not exist
show hidden files mate.
or paste the path into your file explorer window.
or paste the path into your file explorer window.
ASKER
The service account has access to C:\ProgramData\Microsoft\C
the embedded link to create a cert from IIS not longer works but created and installed a cert in the machine. Still getting the same error.
the embedded link to create a cert from IIS not longer works but created and installed a cert in the machine. Still getting the same error.
ok.... are there maybe existing certs in the store which have expired or are lacking their private key ?
ASKER
Before my last attempt to install I looked at the store using cert.msc. There were several certs all with an expiration of 1 year and one that expired in 2059, I left the 2059 one and deleted all others. After the install/failure I looked at the cert store there was a new cert, expiration 1 year and the 2059 cert. I assume the install created the 1 year cert. The 1st error message in the log
2020-03-28 22:24:30.95 spid14s Error: 17190, Severity: 16, State: 1.
2020-03-28 22:24:30.95 spid14s Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0.
What does it mean by Initializing the FallBack certificate, does it mean it can create 1 cert but not a second? Is there another log that would get me closer to the problem
2020-03-28 22:24:30.95 spid14s Error: 17190, Severity: 16, State: 1.
2020-03-28 22:24:30.95 spid14s Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0.
What does it mean by Initializing the FallBack certificate, does it mean it can create 1 cert but not a second? Is there another log that would get me closer to the problem
ASKER
Should have been certmgr.msc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry for taking so long
From Hayes Jupe last suggestion
if it comes up with a big red cross within the properties stating that the certificate is not trusted.... and if so - copy it to the trusted store - and try the install again.
Copied to the trusted store installation successful
Thanks for the help
From Hayes Jupe last suggestion
if it comes up with a big red cross within the properties stating that the certificate is not trusted.... and if so - copy it to the trusted store - and try the install again.
Copied to the trusted store installation successful
Thanks for the help
C:\ProgramData\Microsoft\C
You could try pre-generating the certificate as per
https://www.beejblog.com/2012/02/sql-server-solved-unable-to-initialize.html