Running SQL Server on "Microsoft Windows Server Longhorn" or Microsoft Windows Vista
|
In an effort to provide customers with more secure products, Microsoft Windows Server "Longhorn" and Microsoft Windows Vista are supported by SQL Server 2005 Express Edition Service Pack 1 (SP1), and for all other editions will be supported by SQL Server 2005 Service Pack 2 (SP2) or later when it becomes available. Earlier versions of SQL Server, including SQL Server 2000 (all editions including Desktop Engine edition, a.k.a MSDE), SQL Server 7.0, and SQL Server 6.5, will not be supported on Windows Server "Longhorn" or Windows Vista. Customers running applications with these earlier versions of SQL Server should consider evaluating and upgrading to SQL Server 2005, which was designed to take advantage of the upcoming security and performance enhancements in the operating environment.
Guidance for Customers
Identify your deployment scenario to determine the appropriate next steps for upgrading to Windows Server "Longhorn" or Windows Vista.
SQL Server 2005 Express Edition
Upgrade to SQL Server 2005 Express Edition Service Pack 1 or later.
SQL Server 2000 on Windows NT 4.0, Windows 2000, or Windows Server 2003
| • | Obtain trial software for SQL Server 2005 and Windows Vista Beta 2 to evaluate and test your application on SQL Server 2005 and Windows Vista. |
| • | Upgrade to SQL Server 2005 with SP2 when it becomes available. |
| • | Upgrade to Windows Vista. |
SQL Server 7.0 or 6.5 on Windows NT 3.51, Windows NT 4.0, or Windows 2000
| • | Obtain trial software for SQL Server 2005 and Windows Vista Beta 2 to evaluate and test your application on SQL Server 2005 and Windows Vista. |
| • | Upgrade to SQL Server 2005 with SP2 when it becomes available. |
| • | Upgrade to Windows Vista. |
MSDE on Windows NT 3.51, Windows NT 4.0, or Windows 2000
| • | Contact the vendor of the application that ships with MSDE 1.0 and work with the application vendor to upgrade the application to SQL Server 2005 Express Edition (SQL Server Express) SP1. |
| • | Upgrade to Windows Vista. |
Guidance for Vendors
If you are the vendor of an application that uses MSDE, SQL Server 2000, or SQL Server 7.0, identify your deployment scenario to determine the appropriate next steps for upgrading to Windows Vista or Windows Server "Longhorn".
SQL Server 2000 on Windows NT 4.0, Windows 2000, or Windows Server 2003
1. | Evaluate and test your application on SQL Server 2005 with SP2 (when it becomes available) and Windows Vista. |
2. | Advise your customers to upgrade to SQL Server 2005 with SP2 when it becomes available. |
3. | If necessary, provide an update of your application for use with SQL Server 2005 SP2 and Windows Vista. |
SQL Server 7.0 on Windows NT 3.51, Windows NT 4.0, or Windows 2000
1. | Evaluate and test your application on SQL Server 2005 with SP2 (when it becomes available) and Windows Vista. |
2. | Advise your customers to upgrade to SQL Server 2005 with SP2 when it becomes available. |
3. | If necessary, provide an update of your application for use with SQL Server 2005 SP2 and Windows Vista. |
MSDE on Windows NT 3.51, Windows NT 4.0, or Windows 2000
SQL Server Express SP1 will be supported on Windows Vista for Vendors who need an embedded solution prior to the release of SQL Server Express SP2. SQL Server Express SP1 has known issues on Vista related to User Access Control.
1. | Evaluate and test your application on SQL Server Express SP2 when it becomes available and Windows Vista. |
2. | Provide SQL Server Express to your customers to upgrade their MSDE. |
3. | If necessary, provide an update of your application for use with SQL Server Express and Windows Vista. |
Support
To determine the availability and support for your server product, locate your version of SQL Server on the Microsoft Product Support Services (PSS) site.
Forum
If you have any questions about upgrading MSDE to SQL Server Express, you can ask them in the SQL Server Express fourm.
For More Information
To learn more about product availability and support, see:
| • | Read the FAQ for SQL Server 2000 (including MSDE) on Windows Vista |
| • | Upgrade to SQL Server 2005 |
| • | Upgrade MSDE to SQL Server 2005 |
| • | Get Ready for Windows Vista site |