Article - CS374730
DPM SaaS dev instance lost connectivity to the Microsoft SQL server
Modified: 15-Aug-2022
Applies To
- ThingWorx Platform 9.3
Description
- RCA for DPM connectivity loss on PTC Cloud hosted instance
- Why did DPM lose connection to MS SQL Server database?
- Error in Application log-
- [L: ERROR] [O: c.p.d.DatabaseConnectionManager] [I: ] [U: GEA-AP1-FAB] [S: ] [P: ] [T: https-jsse-nio-8443-exec-33] Error getting database connection
- [L: ERROR] [O: c.p.d.TransactionManager] [I: ] [U: GEA-AP1-FAB] [S: ] [P: ] [T: https-jsse-nio-8443-exec-33] com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host eddf06df6456.tr28526.eastus1-a.worker.database.windows.net, port 11060 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
This is a printer-friendly version of Article 374730 and may be out of date. For the latest version click CS374730