{"id":526,"date":"2017-03-13T12:00:20","date_gmt":"2017-03-13T16:00:20","guid":{"rendered":"http:\/\/www.amixa.com\/blog\/?p=526"},"modified":"2017-10-03T16:43:45","modified_gmt":"2017-10-03T20:43:45","slug":"classic-asp-switch-to-tls-1-2","status":"publish","type":"post","link":"https:\/\/www.amixa.com\/blog\/2017\/03\/13\/classic-asp-switch-to-tls-1-2\/","title":{"rendered":"Classic ASP switch to TLS 1.2"},"content":{"rendered":"<p>I recently came across a failed PCI scan for one of our clients.\u00a0 This failure was due to TLS 1.0 being enabled on that Windows server.<\/p>\n<p>We ran IISCRYPTO (<a href=\"https:\/\/www.nartac.com\/Products\/IISCrypto\" target=\"_blank\" rel=\"noopener\">link<\/a>) and disabled TLS.<\/p>\n<p>Upon restarting the server, the Classic ASP site threw the following error:<\/p>\n<p>Microsoft OLE DB Provider for ODBC Drivers (0x80004005)<br \/>\n[Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error<\/p>\n<p>That error is because the web server is no longer using TLS 1.0 and the Classic ASP application (web site) is using too old of a driver on the server, to communicate with TLS 1.1 and\/or 1.2.<\/p>\n<p>To get around this, go download the latest ODBC driver from Microsoft, which is version 13.1 as of today.\u00a0 You will most likely need to install the 32-bit version (as most ASP apps run in 32 bit mode).\u00a0 <a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=53339\" target=\"_blank\" rel=\"noopener\">Link here<\/a><\/p>\n<p>Install that driver.<\/p>\n<p>then go to your Windows server, Administrative tools and open the <strong>ODBC Data Sources (32-bit)<\/strong><\/p>\n<p>The 32-bit ODBC Administrator is found here: <strong>C:\\Windows\\SysWOW64\\odbcad32.exe<\/strong><\/p>\n<p>go to the SYSTEM tab<\/p>\n<p>add a new data source<\/p>\n<p>Pick &#8220;ODBC DRIVER 13 for SQL Server&#8221;&#8230; (hit finish)<\/p>\n<p>&nbsp;<\/p>\n<p>put in the name (no spaces or punctuation)<\/p>\n<p>server name (or IP address) (NEXT)<\/p>\n<p>&nbsp;<\/p>\n<p>authentication (USE SQL server auth, enter the LoginID and PW) (NEXT)<\/p>\n<p>&nbsp;<\/p>\n<p>continue, then test the connection (it should work).<\/p>\n<p>go to your Classic ASP application.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>You will need to update the connection string to this:<\/p>\n<p>DSN=YourNewSystemDSNName;Uid=YourSQLUsernameHere;Pwd=SQLpassword;<\/p>\n<p>You can now use IISCrypto and disable TLS 1.0<\/p>\n<p>Reboot the server<\/p>\n<p>re-test your Classic ASP app and now you should be up and running on TLS 1.1 or 1.2<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I recently came across a failed PCI scan for one of our clients.\u00a0 This failure was due to TLS 1.0 being enabled on that Windows server. We ran IISCRYPTO (link) and disabled TLS. Upon restarting the server, the Classic ASP site threw the following error: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error That<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33,4,88,22],"tags":[103,8],"class_list":["post-526","post","type-post","status-publish","format-standard","hentry","category-classic-asp","category-iis-tips-n-tricks","category-microsoft-sql-server-mssql","category-windows-server","tag-classic-asp","tag-microsoft-windows-server"],"_links":{"self":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts\/526","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/comments?post=526"}],"version-history":[{"count":6,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts\/526\/revisions"}],"predecessor-version":[{"id":553,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts\/526\/revisions\/553"}],"wp:attachment":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/media?parent=526"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/categories?post=526"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/tags?post=526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}