Forum Discussion

Uzi2019's avatar
Uzi2019
Community Champion
3 years ago
Solved

Error: 40 - Could not open a connection to SQL Server

Hi Experts, I am getting this error after our cloud team has installed VPN with SQL server. PBI gateway and SQL server are on same RDP. it was working correctly but since VPN is installed for securi...
Need Help
  • Tahreem24's avatar
    Tahreem24
    3 years ago

    Hi Uzi2019 
    Try this command from your host machine to check whether the SQL port is open or not.
    Open cmd and try this command
    Telnet [your system IP] 1433

    if you are getting this error it means you need to allow your system IP address on whitelist. 

     Appreciate with Kudos if you like my solution!

     

Tahreem24's avatar
Tahreem24
Super User
3 years ago

Hi Uzi2019 
Try this command from your host machine to check whether the SQL port is open or not.
Open cmd and try this command
Telnet [your system IP] 1433

if you are getting this error it means you need to allow your system IP address on whitelist. 

 Appreciate with Kudos if you like my solution!