Small background of this issue , TDOD service stopped automatically yesterday.
Prior to yesterday, Service was running fine and was able to connect to Service layer from Datamaker and ARD.
Below is the message I receive when I try to start TDOD Service:
Error Message:
The CA TDOD Service service on Local Computer started and then Stopped.
Some Services stop automatically if they are not in use by other services or programs.
TDOD Log:
2019-09-17 08:53:10,585 [4] INFO GTWCFHost.GTWCFHost - Connection Details
2019-09-17 08:53:10,604 [4] INFO GTWCFHost.GTWCFHost - Data Source=Server Name
2019-09-17 08:53:10,604 [4] INFO GTWCFHost.GTWCFHost - User ID=gtrep
2019-09-17 08:53:10,604 [4] INFO GTWCFHost.GTWCFHost - Initial Catalog=gtrep
2019-09-17 08:53:10,604 [4] INFO GTWCFHost.GTWCFHost - Connection Lifetime=60
2019-09-17 08:53:10,604 [4] INFO GTWCFHost.GTWCFHost - Min Pool Size=1
2019-09-17 08:53:10,604 [4] INFO GTWCFHost.GTWCFHost - Network Library=dbmssocn
2019-09-17 08:53:10,604 [4] INFO GTWCFHost.GTWCFHost - Application Name=GT TDoD Service
2019-09-17 08:53:10,605 [4] INFO GTWCFHost.GTWCFHost - Connection Provider: System.Data.SqlClient
2019-09-17 08:53:10,605 [4] INFO GTWCFHost.GTWCFHost - Validating database connection
2019-09-17 08:53:25,148 [4] FATAL GTWCFHost.GTWCFHost - Exception occured while validating database connection
2019-09-17 08:53:25,148 [4] FATAL GTWCFHost.GTWCFHost - Exception: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The remote computer refused the network connection.)
2019-09-17 08:53:25,149 [4] FATAL GTWCFHost.GTWCFHost - Inner Exception: The remote computer refused the network connection
2019-09-17 08:53:25,149 [4] FATAL GTWCFHost.GTWCFHost - Exception occurred while opening service host connection
2019-09-17 08:53:25,149 [4] FATAL GTWCFHost.GTWCFHost - Exception: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The remote computer refused the network connection.)
2019-09-17 08:53:25,149 [4] FATAL GTWCFHost.GTWCFHost - Inner Exception: The remote computer refused the network connection