Solved

How to determine if port 1433 is using ssl

Posted on 2010-09-14
7
2,050 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

726 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