Wow. Just read this morning that Microsoft has announced they won't have backwards compatibility with SQL 2000/MSDE in the much awaited, much delayed Longhorn/Vista operating systems. They announced this back on July 20, but I hadn't read it anywhere until this morning. Here's what Microsoft has to say:
In an effort to provide customers with more secure products, Microsoft
Windows Server "Longhorn" and Microsoft Windows Vista will only support the
follow on release to SQL Server 2005 Service Pack 1 (SP1) or later. 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.
For those of you who like to be early adopters of new OS's and want to get the supposed security advantages of Longhorn/Vista, this may put a wrinkle into your plans. You may need to plan a SQL Server and iMIS upgrade before you can do the OS upgrade. Vista is supposed to be released in "early 2007" and Longhorn sometime in 2007.
For iMIS users upgrading to SQL 2005 means you must be on at least iMIS 10.6 and you run your iMIS database in the compatibility mode of SQL 2000 (8).
For those on MSDE, what does it mean? Not clear to me. ASI has not, to my knowledge, made any official announcements regarding SQL Express support but the NiUG Discovery Conference is less than a month away.