CRM Watcher

CRM Watcher is the source for the latest Microsoft Dynamics CRM News and Downloads.

Saturday, August 19, 2006

Vista: SQL 2005 Required (CRM uses SQL 2000)

When the Windows Vista client finally ships, VARs will have to make sure database customers are running the latest-and-greatest SQL Server bits as well.
Though it's not widely known, Vista and the even more distant "Longhorn" Windows Server will support SQL Server 2005 Service Pack 2 and later. SP2 is due to ship soon after Vista to ensure compatibility. Microsoft maintains that Vista remains on course for general availability early next year.

Microsoft in its latest earnings call said its database business grew 35 percent year over year, which indicates that there's a lot of the new database out there. But VARs say there are many applications still running on older SQL Server 2000 and earlier releases of the database.
It's likely that many of those users wouldn't necessarily rush into an operating system upgrade. But if they are, they will need to take several factors into account.

SQL Server 2005 shipped in November 2005, and SP1 was released in April. One consideration for cutting off support for older SQL Server 2000 SKUs, including the MSDE (Microsoft CRM 1.2 client and Microsoft CRM 3.0 laptop editon), is that those versions don't support Windows Update Services and can't be patched automatically, as the successor database can. And in SQL Server 2005, MSDE has been supplanted by SQL Server Express.

Users wanting to continue with SQL Server 2000--presumably running on older operating systems--can do so under standard support until November 2007. Extended support, which carries an additional charge, continues for 10 years.
Customers running SQL Server 2000 on Windows 2000 or Windows Server 2003 who want to update are advised to run trial versions of SQL Server 2005 and Windows Vista Beta 2 to test applications. Then they would need to upgrade their databases to SQL Server 2005 SP1 and then upgrade to Vista.

Read more