As of April 12, 2016, Microsoft will no longer support Microsoft SQL Server 2005. This means that Microsoft will no longer provide automatic fixes, security updates, or online technical support for this product. Microsoft SQL Server 2005 will still work for your business, but without the proper support, continuing to rely on it will become increasingly risky.
- Who does this affect?
This will affect any organization that uses Microsoft SQL Server 2005, which includes small and medium businesses, but also large businesses and government agencies.
- What are the risks?
As new vulnerabilities will no longer be patched by Microsoft, organizations that continue to use this technology after the end of their lives may be exposed to risks of failure, compliance and security. Hardware and software compatibility issues may also arise when implementing current technologies that may not have been designed for use with Microsoft SQL Server 2005.
- What should you do?
The Canadian Cyber Incident Response Center (CCIRC) strongly encourages owners and operators of Microsoft SQL Server 2005 to update their systems as soon as possible. Migrating to newer versions of SQL Server can present unique challenges and it is essential that organizations running SQL Server 2005 plan and test a migration solution before the deadline.
Applications may have compatibility issues with newer versions of SQL Server. CCIRC recommends that planning for database migration includes the following:
- Have an accurate inventory of SQL Server databases that will need to be migrated.
- Prioritize the databases to migrate.
- Decide on a destination for these databases.
- Choose a version of SQL Server
- Decide whether the databases will be upgraded, migrated, or hosted in the cloud.
Organizations will need to identify all infrastructure, application, and hardware dependencies when planning to migrate the SQL Server database. The Microsoft Assessment and Planning Kit (MAP) can be used to discover SQL Server instances in an organization’s network and assess readiness. The SQL Server Upgrade Advisor has the ability to perform a detailed analysis of SQL Server installations and their respective configurations to identify any known is
Leave A Comment