Data Connection Error : Telnet connection to the host MSSQLSERVER2019:1433 failed. Telnet failure indicates that either host/port combination is incorrect or the extractor is not allowed to access the database due to firewall or access permissions.

Question

Hi,

I am trying to create a new connection to the on-prem MS SQL Server Database on my personal system for training purposes with database type as Microsoft SQL Server(native) but getting an error

Telnet connection to the host MSSQLSERVER2019:1433 failed. Telnet failure indicates that either host/port combination is incorrect or the extractor is not allowed to access the database due to firewall or access permissions.

Please see the screenshot below.

Port Number: 1433

Please help to resolve the issue.

.14600110018 · Answer

Hi @jaikishan.pandy11,In SQL server database you need to configure the firewall settings.Probably this guide will help you: https://docs.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-ver16Let me know!

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN