Solved

how do i allowing to SQL port 2433 to go through firewall on Windows server 2012?

Posted on 2013-10-23
2
698 Views
Last Modified: 2013-10-24
i have install SQL database on Windows server machine and i able to connect from outside the network to SQL DB only when firewall is down, how do i turn firewall up but allowing Port 2433 communicate with SQL server? (how do i open port 2433 in Windows server 2012?)

Thanks
Gvilbis
0
Comment
Question by:gvilbis
[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
2 Comments
 
LVL 6

Accepted Solution

by:
Spyder2010 earned 500 total points
ID: 39595531
You could set the firewall rule using Powershell:

New-NetFirewallRule -DisplayName "Allow Port 2433" -Direction Inbound -LocalPort 2433 -Protocol TCP-Action Allow

Here's the MS TechNet article on the New-NetFirewallRule command
http://technet.microsoft.com/en-us/library/jj554908.aspx

Also, are you sure you have the right port for your SQL server?  By default, it uses port tcp/1433
0
 

Author Closing Comment

by:gvilbis
ID: 39597678
i define port in firewall windows
0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Server 2008 Not services listed 23 73
LDAP Setup 6 56
How ldap located a Domain controller? 22 69
Restore scheduled tasks from a backup 5 39
OfficeMate Freezes on login or does not load after login credentials are input.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question