asked
I found this configuration in a client, do i need to migrate?
The SQL, it´s a 2005 with the following characteristics: Microsoft SQL Server Management Studio 9.00.4035.00 Herramientas cliente de Microsoft Analysis Services 2005.090.4035.00 Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710) Microsoft MSXML 2.6 3.0 6.0 Microsoft Internet Explorer 7.0.5730.13 Microsoft .NET Framework 2.0.50727.3082 Sistema operativo 5.2.3790 With a Windows Server 2003 Enterprise Edition with SP2.
Why would ask this question online? It is 2005 and current year is 2015 so anyone will tell you yes you should upgrade. However the decision is for the application owner that uses that server.
ASK SQL Server Central runs by you voting. For all helpful answers below, please indicate this by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate this by clicking on the check mark next that answer.
Yes, only if your client says yes and is ready to bear the time and cost of migration.
First of all, you seem to have listed the client software versions, not the server software versions. But you already stated that it's a SQL Server 2005 running on Windows Server 2003. I'd like to elaborate on the previous answers. The support Life cycle for SQL Server 2005 (all editions) is like this: Mainstream support ended at April 12 2011. Extended support will end at April 12 2016. For Windows Server 2003: Mainstream support ended July 13 2010. Extended support will end July 14 2015. When the extended support period has ended, no more security updates or bug fixes will be released. Instead, customers are referred to newer versions of the software. With that in mind, one could always argue about how likely it is that new bugs or security issues are found after end of extended support. I would probably upgrade to the newest versions of Windows and SQL Server. But on the other hand, it's not my own money...
18 People are following this question.
