Fix for - Could not open connection to the host, on port 1433: Connect failed

Аватар автора
Лекции для интеллектуалов
This video is the solution to Could not open connection to the host, on port 1433: Connect failed has been given. 01:30 Problem of connecting to remort MSSQL Server exlpained 02:01 Adding firewall rule (both program and port on the host server into Windows Defender Firewall - Windows Defender Firewall with Advanceed Security 04:16 Enabling TCPIP port on SQL Server configuration manager and setting ipaddress. 05:15 Testing the connection from remote client using telnet and Oracle SQL Developer client 07:39 Summarizing Path of the sqlservr.exe to be added Program FilesMicrosoft SQL ServerMSSQL15.EXPRESSMSSQLBin For version 16 change MSSQL15.EXPRESS to MSSQL16.EXPRESS Mocrosoft ODBC SQL driver 18 download link for x64: Mocrosoft ODBC SQL driver 18 download link for arm64: Oracle SQL Developer without JRE for Windows 10 64 bit :

0/0


0/0

0/0

0/0