On May 12, 2017, an extremely virulent ransomware variant named WCry 2.0 began to infect organizations. Within several hours, over 75,000 victims were reported in 90+ countries. Learn more from our research team about this threat & how to protect your organization!
Course Of The Month
3 days, 23 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| Change subnet - effects on server | 14 | 42 | |
| Exchange 2016->2010 migration - Autodiscover SCP question. | 5 | 29 | |
| Writing reports to a script | 7 | 29 | |
| Export Active Directory Members from a Group | 15 | 20 |
In-place Upgrading Dirsync to Azure AD Connect
This article describes my battle tested process for setting up delegation.
I use this process anywhere that I need to setup delegation.
In the article I will show how it applies to Active Directory
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
This Micro Tutorial hows how you can integrate Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease.
The following video show how to bind OSX Mavericks to …
Suggested Courses
Course of the Month3 days, 23 hours left to enroll
751 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.