Solved

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

Posted on 2013-10-23
2
683 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
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Trying to figure out group policy inheritance and which settings apply where can be a chore.  Here's a very simple summary I've written which might help.  Keep in mind, this is just a high-level conceptual overview where I try to avoid getting bogge…
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 show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
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 …

770 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