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
Solved

How to determine if port 1433 is using ssl

Posted on 2010-09-14
7
2,009 Views
Last Modified: 2012-05-10
Hello,

I'm relatively new to SQL Server.  How do I determine if a port, in particular is using SSL.
0
Comment
Question by:chtullu135
  • 4
  • 2
7 Comments
 
LVL 22

Accepted Solution

by:
Matt V earned 500 total points
ID: 33676449
First, I would check the configuration on the listener using that port to see if it is setup to use SSL.
Another round-about way is to use a packet sniffer (Wireshark or MS Network Monitor) and capture some traffic on that port.  If you can see the plain text, it is not using SSL.
0
 

Author Comment

by:chtullu135
ID: 33676734
<First, I would check the configuration on the listener using that port to see if it is setup to use SSL.

How would you do that
0
 
LVL 22

Expert Comment

by:Matt V
ID: 33677076
In the SQL Server Configuration Manager usually, unless this is SQL Xpress
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:chtullu135
ID: 33677533
Where in the SQL Server Configuration Manager
0
 
LVL 22

Expert Comment

by:Matt V
ID: 33678038

To verify the port configuration of an instance of SQL Server, follow these steps:

   1. Start Registry Editor.
   2. In Registry Editor, locate the following registry key:
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<InstanceName>\MSSQLServer\SuperSocketNetLib\Tcp
      Note If you are using SQL Server 2005, locate the following registry subkey:
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<MSSQL.x>\MSSQLServer\SuperSocketNetLib\Tcp\IPAll
      Notice the TCPDynamicPorts value and the TCPPort value. These values appear as follows, depending on your port allocation method:
          * Static Port Allocation
            If you configure an instance of SQL Server to use a static port, and you have not yet restarted the instance of SQL Server, the registry values are set as follows:
            TCPDynamicPorts = Last port used
            TCPPort = New static port to be used after the next restart; new static port that you set by using the Server Network Utility
            However, if you configure an instance of SQL Server to use a static port, and you restart the instance of SQL Server, the registry values are set as follows:
            TCPDynamicPorts = Blank
            TCPPort = New static port that you set by using the Server Network Utility
          * Dynamic Port Allocation
            If you configure an instance of SQL Server to use dynamic port allocation, and you have not yet restarted the instance of SQL Server, the registry values are set as follows:
            TCPDynamicPorts = Blank
            TCPPort = 0
            However, if you configure an instance of SQL Server to use dynamic port allocation, and you restart the instance of SQL Server, the registry values are set as follows:
            TCPDynamicPorts = Current port used
            TCPPort = Current port used
0
 
LVL 22

Expert Comment

by:Matt V
ID: 33678045
Also refer to this article, port 443 is for SSL connections.

http://www.experts-exchange.com/Microsoft/Applications/Q_23935908.html
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33679141
You have to use a Network Monitoring tool like Microsoft Network Monitor or Network sniffer to check whether SSL is enabled for your connection.

If you are connecting SQL Server from the application, then check in the connection credentials whether Encryption is enabled or not.
More info below:

http://support.microsoft.com/kb/316898
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Managing Columnstore Indexes 2 38
Find results from sql within a time span 11 46
how to restore or keep sql2000  backups useful... 2 12
What is this datetime? 1 19
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.

856 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