question

Willieoes avatar image
Willieoes 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.
server
3 comments
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.

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.
2 Likes 2 ·
Thank you very much for all of your answers. I really appreciate it Regards Willie
0 Likes 0 ·
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.
0 Likes 0 ·
erlokeshsharma08 avatar image
erlokeshsharma08 answered
Yes, only if your client says yes and is ready to bear the time and cost of migration.
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
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...
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.

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.