November 2, 2015 at 8:53 am
Hi Team,
Services are failed to start when failover from one node to another node.
1. I have changed the services accounts to my name and try to start the service then its working ..
2.Again used the service account but no luck
got the below errors from the log
Error: 17190, Severity: 16, State: 1.
2015-11-02 10:07:52.03 spid15s Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0.
2015-11-02 10:07:52.03 spid15s Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
2015-11-02 10:07:52.03 spid15s Error: 17182, Severity: 16, State: 1.
2015-11-02 10:07:52.03 spid15s TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property.
2015-11-02 10:07:52.03 spid15s Error: 17182, Severity: 16, State: 1.
2015-11-02 10:07:52.03 spid15s 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.
2015-11-02 10:07:52.03 spid15s Error: 17826, Severity: 18, State: 3.
2015-11-02 10:07:52.03 spid15s 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.
2015-11-02 10:07:52.03 spid15s Error: 17120, Severity: 16, State: 1.
2015-11-02 10:07:52.03 spid15s SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
November 3, 2015 at 1:48 am
How are you changing the service accounts? Services.msc or SQL Server Configuration Manager?
November 3, 2015 at 9:28 am
SQL Server Configuration Manager?
1. Its not working with the existing domain account so i have changed to my credentials through SQL Server Configuration Manager?
November 6, 2015 at 8:07 am
Lavanyasri (11/3/2015)
SQL Server Configuration Manager?1. Its not working with the existing domain account so i have changed to my credentials through SQL Server Configuration Manager?
I wouldn't advocate using a personal domain account for a service, this is bad practice. If your company has had a password policy the service would fail.
Is the domain service account only used for this instance? if so reset it in AD and re-apply it to the service
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 17, 2015 at 2:28 am
We are using the same service account on different cluster servers but we are seeing the issue only one cluster environment ( 2 node cluster). there is no password expiry for this service account .
November 17, 2015 at 2:35 am
Has the SSL certificate expired?
Are you even using SSL to encrypt the connections to the server? If not remove it from Config Manager
November 17, 2015 at 4:26 am
Is the SPN (Service Principal Name) registered correctly
To create an SPN for the NetBIOS name of the SQL Server use the following command: setspn –A MSSQLSvc/<SQL Server computer name>:port# <Domain\Account>
To create an SPN for the FQDN of the SQL Server use the following command: setspn -A MSSQLSvc/<SQL Server FQDN>:port# <Domain\Account>
To check for the registered SPN type this in an elevated command prompt
setspn –L <domain\SQL Service Account>
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply