We are trying to set up TDM Portal using Integrated Security with our SQL Server Database. However, the connection to the SQL Server Database is failing. We have verified the account we are using does have access and can connect to the SQL DB / Instance via Windows Integrated Security, and are using this same account to log into CA TDM when trying to set up the Connection Profile in TDM Portal. We contacted our DBA, who confirmed the connection is not even making it to the DB server, so nothing to see.
The Connection Profile error displayed on Testing the connection:
The server replied: Failed to obtain JDBC Connection; The connection to the host LOUSQLWQSxxx.domain.com, named instance LOUSQLWQSxxx failed. Error: "java.net.SocketTimeoutException: Receive timed out". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.
We are unable to find any log entries on the CA TDM server that could assist us, and this is our first attempt to utilize integrated security to make a DB connection, but is quickly becoming the standard for our company.
Release : 4.9 and later
Components: TDM Web Portal and DataMaker
From the startup.log I can see the TDMConnectionProfileManager service for Portal is running on 'LOUAPPWQSxxxx'.
There are two errors that we see thrown in the TDMConnectionProfileManager.log.
I know host LOUAPPWQSxxxx is the TDM Portal server. I assume host LOUSQLWQSxxx is the SQL Server hosting the database you are trying to connect to, and the connection requests from LOUAPPWQSxxxx are failing because the socket we are trying to communicate across is timing out.
There are many things that can cause this, but the most common are:
I would like for you to try to create a new Connection Profile using GT DataMaker, and see if you are able to connect o the SQL Server database. This will remove TDM Portal from the picture.
To create a new Connection Profile:
The new profile will be visible, and usable from CA DataMaker, as well as Portal.
How to enable debugging for TDM Portal - https://knowledge.broadcom.com/external/article?articleId=9851