<div>
I found the problem. the SMSS doesn't negotiate with TLS 1.1 or 1.2. It has to be installed with service pack on both server and workstation
</div>


I found the problem. the SMSS doesn't negotiate with TLS 1.1 or 1.2. It has to be installed with service pack on both server and workstation

<div>
crcsupport, thanks for the points but in these cases that you solved your own issue you should accept your own comment stating the resolution since our comments didn't help or pointed you to the real cause.<br />
Cheers
</div>


crcsupport, thanks for the points but in these cases that you solved your own issue you should accept your own comment stating the resolution since our comments didn't help or pointed you to the real cause.
Cheers

<div>
In fact, I based on Arnold's thought and researched to find the answer. So, I think it's valid points for him and others helped.
</div>


In fact, I based on Arnold's thought and researched to find the answer. So, I think it's valid points for him and others helped.

<div>
<div class="content wysiwyg-content">
Spec:<br />
Windows Server 2012, SQL 2008 STD. <br />
<br />
For PCI scanning, to protect Sweet32 Birthday attack, I had to disable Triple DES as recommended. <br />
After then, SQL Management Studio cannot connect to the server. <br />
How can I resolve this problem? <br />
<br />
TLS 1.0, 1.1, 2.0 enabled.
</div>
</div>


Spec:
Windows Server 2012, SQL 2008 STD. 

For PCI scanning, to protect Sweet32 Birthday attack, I had to disable Triple DES as recommended. 
After then, SQL Management Studio cannot connect to the server. 
How can I resolve this problem? 

TLS 1.0, 1.1, 2.0 enabled.

SQL management studio fails to connect after Triple DES cipher disabled.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Operating system security (OS security) is the process of ensuring OS integrity, confidentiality and availability. OS security refers to specified steps or measures used to protect the OS from threats, viruses, worms, malware or remote hacker intrusions. OS security encompasses all preventive-control techniques, which safeguard any computer assets capable of being stolen, edited or deleted if OS security is compromised, including authentication, passwords and threats to systems and programs.

OS Security

Windows Server 2012 is the server version of Windows 8 and the successor to Windows Server 2008 R2. Windows Server 2012 is the first version of Windows Server to have no support for Itanium-based computers since Windows NT 4.0. Windows Server 2012, now in its second release (Windows Server 2012 Release 2) includes Foundation, Essentials, Standard and Datacenter, and does not support IA-32 or IA-64 processors.

Windows Server 2012

IIS is Internet Information Services, the web server included with Windows Server operating systems. All current versions are built on a modular architecture; modules can be added or removed individually so that those required for specific functionality are installed. The full installation of IIS includes HTTP, security, content, compression, caching, logging and diagnostics.