How to determine if port 1433 is using ssl

Hello,

I'm relatively new to SQL Server.  How do I determine if a port, in particular is using SSL.
chtullu135Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Matt VConnect With a Mentor Commented:
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
 
chtullu135Author Commented:
<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
 
Matt VCommented:
In the SQL Server Configuration Manager usually, unless this is SQL Xpress
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
chtullu135Author Commented:
Where in the SQL Server Configuration Manager
0
 
Matt VCommented:

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
 
Matt VCommented:
Also refer to this article, port 443 is for SSL connections.

http://www.experts-exchange.com/Microsoft/Applications/Q_23935908.html
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.