This past May, Webroot surveyed more than 600 IT decision-makers at medium-sized companies to see how these small businesses perceived new threats facing their organizations. Read what Webroot CISO, Gary Hayslip, has to say about the survey in part 1 of this 2-part blog series.
Solved
Sql Server Firewall Problems
Posted on 2016-09-06
Hi experts,
I am having a problem with Sql Server 2014 and the windows firewall.
The server is under the domain. In the firewall the port 1433 TCP and 1434 UDP are opened but I cannot connect to the server from remote.
If I disable the firewall for the domain network then I am able to connect to the server.
In any case, even with the firewall off, I can only connect using: servername\sqlinstance and not using the ip address of the server.
I doubled checked that TCP/IP is enabled in the SQL configuration and the port is 1433.
Basically with firewall on I cannot connect, with firewall off I can. The rule is set to open 1433 on private, domain and public.
Any idea what can be wrong?
I am having a problem with Sql Server 2014 and the windows firewall.
The server is under the domain. In the firewall the port 1433 TCP and 1434 UDP are opened but I cannot connect to the server from remote.
If I disable the firewall for the domain network then I am able to connect to the server.
In any case, even with the firewall off, I can only connect using: servername\sqlinstance and not using the ip address of the server.
I doubled checked that TCP/IP is enabled in the SQL configuration and the port is 1433.
Basically with firewall on I cannot connect, with firewall off I can. The rule is set to open 1433 on private, domain and public.
Any idea what can be wrong?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource.
Use Google, Bing, or other preferred search engine to locate trusted NTP …
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses
Course of the Month8 days, 13 hours left to enroll
721 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.