Question

5
Replies
1757
Views
wamsi Member since 2015 22 posts
Capgemini
Posted: 2 years ago
Last activity: 2 years 7 months ago
Closed
Solved

Connect to SQL Server from Pega

Dear team,

I am getting the below error while connecting the Pega 7 to SQL server. I clicked the test connection button. tried many ways. but getting the same error. Please help me to identify the possible root cause.

Problem encountered when getting a database connection: code: 0 SQLState: 08S01 Message: The TCP/IP connection to the host LIN66003543B, port 1433 has failed. Error: "Permission denied: connect. 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.". DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host LIN66003543B, port 1433 has failed. Error: "Permission denied: connect. 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.". | SQL Code: 0 | SQL State: 08S01
Fail

***Edited by Moderator Marissa to update categories***

Data Integration
Moderation Team has archived post
Share this page LinkedIn