Hi Folks Namaste!! Curious to know what happens when extended support for sql 2005 ends from clients point of view. We are using sql 2005 as back end in one of our bi solutions(ssis, ssrs and ssas). What are major effects (if any) on normal functioning of the systems after it ends. Thanks Lokesh -------------------------------------------------- Just want to reopen this question for more discussion, the client still does not seem interested to upgrade from sql server 2005. Can it have a major impact going in future?
There's really no way of telling what will happen to the systems running SQL Server 2005 after extended support ends. There may or may not come patches to the operating system which in some way breaks SQL Server 2005. New security holes may or may not be found in SQL Server 2005 and if they are found, they probably won't be fixed in any CU or patch. If getting support from Microsoft on any errors and problems, you are likely to get the responce that you should upgrade your system to SQL Server 2012 or later. One could argue that SQL Server 2005 has been around for so long, and if it works it works. But from time to time, hackers and Microsoft themselves find out about weaknesses in their systems (being either on the operating system or in SQL Server). If I was running SQL Server 2005, I would be very careful about testing before patching the Windows system There's a risk you'll end up with a patch on the Windows system which you would want to install, but which you dare not installing because you're not sure if and how it would effect SQL Server 2005. In the end, for the customer, it's a risk assessment: Cost of upgrading to a supported version of SQL Server and possible cost of business interruption.
Extended support ends mean you will get the support about sql2005 but it will not make any impact on your current packages, so if you need the support then either upgrade to SQL2008 or Sql2012 or check if you can get the support on 2005. Raman