Unable to start Test Data on Demand (TDOD) Service. Exception: A network-related or instance-specific error occurred while establishing a connection to SQL Server.
search cancel

Unable to start Test Data on Demand (TDOD) Service. Exception: A network-related or instance-specific error occurred while establishing a connection to SQL Server.

book

Article ID: 137428

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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
 

Environment

CA Test Data Manager 
TDOD
TDM Portal

Cause

SQL Server could not be reached.

Resolution

Had to update the Data source name from Fully qualified name to Server name , Port number.