Solved

unidirectional to 1433

Posted on 2011-02-15
4
1,342 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
[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
  • 2
4 Comments
 
LVL 8

Accepted Solution

by:
dba2dba earned 500 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 500 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

724 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