[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

unidirectional to 1433

Posted on 2011-02-15
4
Medium Priority
?
1,450 Views
Last Modified: 2012-05-11
when a PC needs to hit a SQL Server, port 1433 has to be opened. Does it have to be bi-directional or uni-directional is enough?

thanks
0
Comment
Question by:anushahanna
  • 2
  • 2
4 Comments
 
LVL 8

Accepted Solution

by:
dba2dba earned 2000 total points
ID: 34898372
It should be unidirectional. Only the Port 1433 on the Remote Server should be opened up to be able to be accessed by the PC.

Thanks,
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34898391
dba2dba- with Reads, the direction would be towards the PC and with writes, the direction is towards the SQL Server, right? still unidirectional is enough? is that a special property of port 1433?
0
 
LVL 8

Assisted Solution

by:dba2dba
dba2dba earned 2000 total points
ID: 34928852
Normally, If you want to connect to the SQL Server from PC. You need to have the port 1433 open for communication.

Once the Port is Open you can do reads from the SQL Server as well as writes to the SQL Server.

To see if you will be able to access the port, telnet from command prompt of PC to the specific port on SQL Server

In cmd prompt of PC:

telnet SQLServerName 1433

You should see a blank screen which indicates that you are able to access the port. 1433 does not have any special properties.

Thanks,
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34935407
appreciate your input..
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

This month, Experts Exchange’s free Course of the Month is focused on CompTIA IT Fundamentals.
Unable to change the program that handles the scan event from a network attached Canon/Brother printer/scanner. This means you'll always have to choose which program handles this action, e.g. ControlCenter4 (in the case of a Brother).
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

873 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