Question

5
Replies
1951
Views
 Jaya Siva Naga Sita Rama Vamsi Varanasi (wamsi)
Capgemini

Capgemini
GB
wamsi Member since 2015 22 posts
Capgemini
Posted: February 13, 2018
Last activity: February 13, 2018
Posted: 13 Feb 2018 8:59 EST
Last activity: 13 Feb 2018 21:17 EST
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.

Accepted Solution

Posted: 3 years ago
Posted: 13 Feb 2018 12:29 EST
Ujjwal Kumar Shukla (UjjwalShukla_GCS)
PEGA
Technical Lead
Pegasystems Inc.
IN

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
Posted: 3 years ago
Posted: 13 Feb 2018 13:33 EST
Jaya Siva Naga Sita Rama Vamsi Varanasi (wamsi)
Capgemini

Capgemini
GB

Hi Ujjwal,


I have IP1 to IP9 and IPAll number exists in my TCP/IP properties. Do I need to update all my IP1 to IP9 with the Server name as my  server name - LIN66003543B ?  or only for specific IP numbers ?


Thanks,


Vamsi
Posted: 3 years ago
Posted: 13 Feb 2018 13:56 EST
Jaya Siva Naga Sita Rama Vamsi Varanasi (wamsi)
Capgemini

Capgemini
GB

Hi, 


Thank you Ujjwal. it is worked. I changed for all IP1 to 9 address to my server name. it is worked. I am able to connect now.


Thanks,


Vamsi
Posted: 3 years ago
Posted: 13 Feb 2018 12:30 EST
Adithya Kurmachalam (Adithya1)
PEGA
Solutions Engineer
Pegasystems Inc.
IN

Hi,

Show More

Hi,


  • Check if your SQL server is actually up and running

  • Check SQL server hostname, username and password is correct

  • Check there's no firewall rule blocking TCP connection to port 1433

  • Check the host is actually reachable

Check below post for more details


https://stackoverflow.com/questions/18841744/jdbc-connection-failed-error-tcp-ip-connection-to-host-failed



Show Less