SmartConnector 2.4.7 fails to start after system restart

[mike_meirovitz]

SmartConnector 2.4.7 fails to start after system restart. The service is not started.

See the log below:

2018-08-17 14:09:37.9001,Error,Service,<no principal>,A system shutdown is in progress. (Exception from HRESULT: 0x8007045B)

...

...

2018-08-17 16:41:17.8454,Error,Service,<no principal>,Error while building type Mongoose.Service.LoggerFilterProvider.  See the inner exception for details

1.) new LoggerFilterProvider()

2.) Mongoose.Service.LoggerFilterProvider

3.) Instance of SxL.Common.ILoggerFilterProvider (Mongoose.Service.LoggerFilterProvider)

4.) Container.GetInstance(SxL.Common.ILoggerFilterProvider)

An exception occurred while initializing the database. See the InnerException for details.

An exception has been raised that is likely due to a transient failure. If you are connecting to a SQL Azure database consider using SqlAzureExecutionStrategy.

The underlying provider failed on Open.

An exception has been raised that is likely due to a transient failure. If you are connecting to a SQL Azure database consider using SqlAzureExecutionStrategy.

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

No process is on the other end of the pipe

I had to start the service manually.

Thanks

Mike

[JeffBowman]

Hi Michael,

Is this behavior reproducible?

It looks as though the Smart Connector service tried to start up before SQL finished starting.

Regards,

-Jeff

[mike_meirovitz]

Hi Jeff,

Not yet. Following another shut down and restart it didn't happen. 

I will let you know If it happens again.

Thank you. 

Michael 

[Adam_Summers · Accepted solution]

Hi Michael, did you follow the steps in the install guide to add service dependencies? You can modify the service behaviour to be linked to SQL and set recovery states to have the service attempt an auto restart. It’s worth having SmartConnector set to delayed start too if it’s not already.

[mike_meirovitz]

Hi Adam,

Not yet. I will do it. 

Thank you. 

Michael