This message was deleted.
# _generals
Slackbot
05/11/2021, 4:13 PMThis message was deleted.
k
Kasper Johansen
05/11/2021, 4:17 PMYou sure it's port 1433 that's blocked?
t
Touseef Rehman
05/11/2021, 4:18 PMI just tried to telnet to teh IP address ...Could not open connection to the host, on port 1433: Connect failed
k
Kasper Johansen
05/11/2021, 4:19 PMand you can telnet to port 1433 when the windows firewall is disabled?
t
Touseef Rehman
05/11/2021, 4:19 PMgood point let me try that sir
k
Kasper Johansen
05/11/2021, 4:19 PMThe Windows Firewall log is found here:
%systemroot%\system32\LogFiles\Firewall\pfirewall.log
When enabled
t
Touseef Rehman
05/11/2021, 4:20 PMyeah it worked instantly
k
Kasper Johansen
05/11/2021, 4:21 PMAre you disabling the windows firewall on the SQL server or on the client trying to connect to the SQL server?
t
Touseef Rehman
05/11/2021, 4:21 PMon the server side
Touseef Rehman
05/11/2021, 4:23 PMUnder sql port properties in the inbound rules I noticed under Scope in Remote IP Address it has locol subnet enabled, and it's got specific Ip addresses in there
k
Kasper Johansen
05/11/2021, 4:24 PMIn the resource monitor, do you see this:
t
Touseef Rehman
05/11/2021, 4:24 PMI'll check brb
k
Kasper Johansen
05/11/2021, 4:25 PMRemote IP should be any unless you want to restrict which IPs are allowed to communicate with the SQL server
👏 1
t
Touseef Rehman
05/11/2021, 4:26 PMjust ran tcpip/view on the sever and i see this -
Touseef Rehman
05/11/2021, 4:26 PMah that's the solation so i removed the remote IP and now my exe's connect from the client machine
Touseef Rehman
05/11/2021, 4:26 PMCheers!!
👍 1
k
Kasper Johansen
05/11/2021, 4:26 PMNice
t
Touseef Rehman
05/11/2021, 4:27 PMso a project delayed for 1 year lol is fixed in 2 days by me and slack..scary
Touseef Rehman
05/11/2021, 4:27 PMand now slack*
👍 1
2 Views