Question
5
Replies
1831
Views
Posted: February 13, 2018
Last activity: February 13, 2018
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***
Hi Vamsi,
You need to enable settings by using sqlServer configuration management.
Update the IP address and port number here to the IP where SQL server is installed