question

erlokeshsharma08 avatar image
erlokeshsharma08 asked

what happens after extended support 2005 ends

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?
sql server 2005
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
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.
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks Magnus. I am going to put forward this point to my onsite boss and lets see what decisions they take.
0 Likes 0 ·
ramansharma95 avatar image
ramansharma95 answered
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
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks raman That is what I want to know, client says they dont want to upgrade to sql2008 and sql2012 due to cost reasons. So if the support ends, I know the packages and reports will keep on running as it is, however would it have any impact in coming years or not. Regards Lokesh
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.