{"id":8215,"date":"2015-10-22T11:00:37","date_gmt":"2015-10-22T11:00:37","guid":{"rendered":"https:\/\/tsisupport.com\/?p=598"},"modified":"2020-05-27T08:31:29","modified_gmt":"2020-05-27T08:31:29","slug":"sql-server-2005-end-of-support-deadline","status":"publish","type":"post","link":"https:\/\/tsisupport.com\/tsistaging\/?p=8215","title":{"rendered":"SQL Server 2005 End of Support Deadline"},"content":{"rendered":"<p>Effective April 12, 2016 Microsoft will no longer be supporting <strong>SQL Server 2005<\/strong>. This means that as of that date Microsoft will no longer be pushing out security updates or hot fixes and, as a result, your organization could be left facing vulnerabilities such as:<\/p>\n<p>&#8211; Impaired function of applications based off of the SQL Database,<br \/>\n&#8211; Applications that are at risk for security breaches or bugs,<br \/>\n&#8211; Backups that are no longer running or viable.<\/p>\n<p>In addition to being open to threats such as viruses and malware, it\u2019s possible that applications running off of your SQL database will stop functioning. When a system hits end of support, the vast majority of third party applications that are based off of the system also stop supporting the antiquated version. The result is that when a third party issues an update for their app that is deemed incompatible it may stop functioning or will not update, thus remaining at risk for security breaches or loss of functionality due to bugs.<\/p>\n<p>Another implication of running outdated versions of SQL Server is that your <a href=\"https:\/\/tsisupport.com\/tsistaging\/the-five-critical-parts-to-any-disaster-recovery-plan\/\">backups <\/a>may not function properly. Your backup solution may still be able to functionally run backups of the operating systems and databases, but if your SQL Server is out of date it\u2019s possible that the backup of the database itself will not be viable. This could put your organization in a position to experience huge losses should you experience a disaster (natural or otherwise) which requires a backup of your SQL Server to be used to restore data.<\/p>\n<p>There\u2019s just under six months of support left for <strong>SQL Server 2005<\/strong> \u2013 don\u2019t get caught out running an outdated version.<\/p>\n<p>At TSI we pride ourselves on providing our clients with superior service and best-in-class expertise. If you\u2019re interested in learning more about upgrading to SQL Server 2014 contact us today. We\u2019ll discuss your business needs, and provide project planning and implementation services while working with your application vendors to ensure that the upgrade and data migration are completed as efficiently and effectively as possible, with minimal downtime.<\/p>\n<p>For more information, call us at (508) 534-6979 or, for current clients, contact your Account Manager.<\/p>\n<p><em>Sources: <\/em><\/p>\n<ul>\n<li><a href=\"http:\/\/www.microsoft.com\/en-us\/server-cloud\/products\/sql-server-2005\/#Fragment_Scenario1\" target=\"_blank\" rel=\"noopener noreferrer\"><em>http:\/\/www.microsoft.com\/en-us\/server-cloud\/products\/sql-server-2005\/#Fragment_Scenario1<\/em><\/a><\/li>\n<li><a href=\"https:\/\/info.microsoft.com\/rs\/157-GQE-382\/images\/EN-CNTNT-Infographic-UpgradeSQL2005Datasheet.pdf\" target=\"_blank\" rel=\"noopener noreferrer\"><em>https:\/\/info.microsoft.com\/rs\/157-GQE-382\/images\/EN-CNTNT-Infographic-UpgradeSQL2005Datasheet.pdf<\/em><\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Effective April 12, 2016 Microsoft will no longer be supporting SQL Server 2005. This means that as of that date Microsoft will no longer be pushing out security updates or hot fixes and, as a result, your organization could be left facing vulnerabilities such as: &#8211; Impaired function of applications based off of the SQL&hellip;<\/p>\n","protected":false},"author":8,"featured_media":8330,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[7],"tags":[135,136,137],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server 2005 End of Support Deadline - TSI Support<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2005 End of Support Deadline - TSI Support\" \/>\n<meta property=\"og:description\" content=\"Effective April 12, 2016 Microsoft will no longer be supporting SQL Server 2005. This means that as of that date Microsoft will no longer be pushing out security updates or hot fixes and, as a result, your organization could be left facing vulnerabilities such as: &#8211; Impaired function of applications based off of the SQL&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/tsisupport.com\/tsistaging\/?p=8215\" \/>\n<meta property=\"og:site_name\" content=\"TSI Support\" \/>\n<meta property=\"article:published_time\" content=\"2015-10-22T11:00:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-05-27T08:31:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/tsisupport.com\/tsistaging\/wp-content\/uploads\/2015\/10\/SQL-Server-1140x380-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1140\" \/>\n\t<meta property=\"og:image:height\" content=\"380\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Brian Downey\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Brian Downey\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/?p=8215\",\"url\":\"https:\/\/tsisupport.com\/tsistaging\/?p=8215\",\"name\":\"SQL Server 2005 End of Support Deadline - TSI Support\",\"isPartOf\":{\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/?p=8215#primaryimage\"},\"image\":{\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/?p=8215#primaryimage\"},\"thumbnailUrl\":\"https:\/\/tsisupport.com\/tsistaging\/wp-content\/uploads\/2015\/10\/SQL-Server-1140x380-1.jpg\",\"datePublished\":\"2015-10-22T11:00:37+00:00\",\"dateModified\":\"2020-05-27T08:31:29+00:00\",\"author\":{\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/#\/schema\/person\/5f0cdfe92d0e3dcabd8dd6bad67b9d8c\"},\"breadcrumb\":{\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/?p=8215#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/tsisupport.com\/tsistaging\/?p=8215\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/?p=8215#primaryimage\",\"url\":\"https:\/\/tsisupport.com\/tsistaging\/wp-content\/uploads\/2015\/10\/SQL-Server-1140x380-1.jpg\",\"contentUrl\":\"https:\/\/tsisupport.com\/tsistaging\/wp-content\/uploads\/2015\/10\/SQL-Server-1140x380-1.jpg\",\"width\":1140,\"height\":380},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/?p=8215#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/tsisupport.com\/tsistaging\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2005 End of Support Deadline\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/#website\",\"url\":\"https:\/\/tsisupport.com\/tsistaging\/\",\"name\":\"TSI Support\",\"description\":\"TSI - Technical Support International\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/tsisupport.com\/tsistaging\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/#\/schema\/person\/5f0cdfe92d0e3dcabd8dd6bad67b9d8c\",\"name\":\"Brian Downey\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/tsisupport.com\/tsistaging\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7bc6b8cf711a38beaba894de87689f69?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7bc6b8cf711a38beaba894de87689f69?s=96&d=mm&r=g\",\"caption\":\"Brian Downey\"},\"url\":\"https:\/\/tsisupport.com\/tsistaging\/?author=8\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2005 End of Support Deadline - TSI Support","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"SQL Server 2005 End of Support Deadline - TSI Support","og_description":"Effective April 12, 2016 Microsoft will no longer be supporting SQL Server 2005. This means that as of that date Microsoft will no longer be pushing out security updates or hot fixes and, as a result, your organization could be left facing vulnerabilities such as: &#8211; Impaired function of applications based off of the SQL&hellip;","og_url":"https:\/\/tsisupport.com\/tsistaging\/?p=8215","og_site_name":"TSI Support","article_published_time":"2015-10-22T11:00:37+00:00","article_modified_time":"2020-05-27T08:31:29+00:00","og_image":[{"width":1140,"height":380,"url":"https:\/\/tsisupport.com\/tsistaging\/wp-content\/uploads\/2015\/10\/SQL-Server-1140x380-1.jpg","type":"image\/jpeg"}],"author":"Brian Downey","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Brian Downey","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/tsisupport.com\/tsistaging\/?p=8215","url":"https:\/\/tsisupport.com\/tsistaging\/?p=8215","name":"SQL Server 2005 End of Support Deadline - TSI Support","isPartOf":{"@id":"https:\/\/tsisupport.com\/tsistaging\/#website"},"primaryImageOfPage":{"@id":"https:\/\/tsisupport.com\/tsistaging\/?p=8215#primaryimage"},"image":{"@id":"https:\/\/tsisupport.com\/tsistaging\/?p=8215#primaryimage"},"thumbnailUrl":"https:\/\/tsisupport.com\/tsistaging\/wp-content\/uploads\/2015\/10\/SQL-Server-1140x380-1.jpg","datePublished":"2015-10-22T11:00:37+00:00","dateModified":"2020-05-27T08:31:29+00:00","author":{"@id":"https:\/\/tsisupport.com\/tsistaging\/#\/schema\/person\/5f0cdfe92d0e3dcabd8dd6bad67b9d8c"},"breadcrumb":{"@id":"https:\/\/tsisupport.com\/tsistaging\/?p=8215#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/tsisupport.com\/tsistaging\/?p=8215"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/tsisupport.com\/tsistaging\/?p=8215#primaryimage","url":"https:\/\/tsisupport.com\/tsistaging\/wp-content\/uploads\/2015\/10\/SQL-Server-1140x380-1.jpg","contentUrl":"https:\/\/tsisupport.com\/tsistaging\/wp-content\/uploads\/2015\/10\/SQL-Server-1140x380-1.jpg","width":1140,"height":380},{"@type":"BreadcrumbList","@id":"https:\/\/tsisupport.com\/tsistaging\/?p=8215#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/tsisupport.com\/tsistaging\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2005 End of Support Deadline"}]},{"@type":"WebSite","@id":"https:\/\/tsisupport.com\/tsistaging\/#website","url":"https:\/\/tsisupport.com\/tsistaging\/","name":"TSI Support","description":"TSI - Technical Support International","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/tsisupport.com\/tsistaging\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/tsisupport.com\/tsistaging\/#\/schema\/person\/5f0cdfe92d0e3dcabd8dd6bad67b9d8c","name":"Brian Downey","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/tsisupport.com\/tsistaging\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7bc6b8cf711a38beaba894de87689f69?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7bc6b8cf711a38beaba894de87689f69?s=96&d=mm&r=g","caption":"Brian Downey"},"url":"https:\/\/tsisupport.com\/tsistaging\/?author=8"}]}},"_links":{"self":[{"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=\/wp\/v2\/posts\/8215"}],"collection":[{"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8215"}],"version-history":[{"count":0,"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=\/wp\/v2\/posts\/8215\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=\/wp\/v2\/media\/8330"}],"wp:attachment":[{"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tsisupport.com\/tsistaging\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}