4 edited tags
| link
3 added 11 characters in body
source | link

During my 2014 SQL Server (enterprise)2014 Enterprise installation efforts, I encountered an error near the end of the install that has prevented completion.

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)."

There is currently no cert on the server so it looks as though SQL HasServer has generated a self signed cert to connect with, but isn't being trusted.

Note that all this is happening before the install is complete, so configuration manager isn't available yet. My thought is to turn encryption off, but with no config manager, I am not sure where there may be a config file for the install somewhere that I can edit. Or maybe I would need to put a trusted cert on the server, but without configuration manager fully available, there isn't a way to tell SQL Server to use this the trust cert.

During my 2014 SQL Server (enterprise) installation efforts, I encountered an error near the end of the install that has prevented completion.

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)."

There is currently no cert on the server so it looks as though SQL Has generated a self signed cert to connect with, but isn't being trusted.

Note that all this is happening before the install is complete, so configuration manager isn't available yet. My thought is to turn encryption off, but with no config manager, I am not sure where there may be a config file for the install somewhere that I can edit. Or maybe I would need to put a trusted cert on the server, but without configuration manager fully available, there isn't a way to tell SQL to use this the trust cert.

During my SQL Server 2014 Enterprise installation efforts, I encountered an error near the end of the install that has prevented completion.

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.).

There is currently no cert on the server so it looks as though SQL Server has generated a self signed cert to connect with, but isn't being trusted.

Note that all this is happening before the install is complete, so configuration manager isn't available yet. My thought is to turn encryption off, but with no config manager, I am not sure where there may be a config file for the install somewhere that I can edit. Or maybe I would need to put a trusted cert on the server, but without configuration manager fully available, there isn't a way to tell SQL Server to use this the trust cert.

2 There's no such thing as "MSSQL" - this is only what the script kiddies call it
source | link

SSL error during SQL Server install

During my 2014 MSSQLSQL Server (enterprise) installation efforts, I encountered an error near the end of the install that has prevented completion.

"A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)."

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)."

There is currently no cert on the server so it looks as though SQL Has generated a self signed cert to connect with, but isn't being trusted.

Note that all this is happening before the install is complete, so configuration manager isn't available yet. My thought is to turn encryption off, but with no config manager, I am not sure where there may be a config file for the install somewhere that I can edit. Or maybe I would need to put a trusted cert on the server, but without configuration manager fully available, there isn't a way to tell SQL to use this the trust cert.

SSL error during SQL install

During my 2014 MSSQL (enterprise) installation efforts, I encountered an error near the end of the install that has prevented completion.

"A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)."

There is currently no cert on the server so it looks as though SQL Has generated a self signed cert to connect with, but isn't being trusted.

Note that all this is happening before the install is complete, so configuration manager isn't available yet. My thought is to turn encryption off, but with no config manager, I am not sure where there may be a config file for the install somewhere that I can edit. Or maybe I would need to put a trusted cert on the server, but without configuration manager fully available, there isn't a way to tell SQL to use this the trust cert.

SSL error during SQL Server install

During my 2014 SQL Server (enterprise) installation efforts, I encountered an error near the end of the install that has prevented completion.

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)."

There is currently no cert on the server so it looks as though SQL Has generated a self signed cert to connect with, but isn't being trusted.

Note that all this is happening before the install is complete, so configuration manager isn't available yet. My thought is to turn encryption off, but with no config manager, I am not sure where there may be a config file for the install somewhere that I can edit. Or maybe I would need to put a trusted cert on the server, but without configuration manager fully available, there isn't a way to tell SQL to use this the trust cert.

1
source | link