Network Computing is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them. Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Microsoft Delivers SQL Server 2005 Service Pack 2

Microsoft issued an update this week to its SQL Server software that's completely interoperable with Windows Vista and the 2007 Microsoft Office suite. Microsoft also is offering licensing options with the new SQL Server 2005 Service Pack 2 that let companies run unlimited virtual instances of the software on servers in their virtualized environments.

The increasing use of server virtualization and multi-core processors has been creating licensing problems for enterprise IT managers, and these software costs may have been a limiting factor to the adoption of virtualization in some companies. Many software companies still rely on an antiquated, per-processor licensing model and Microsoft's decision to allow multiple virtual instances of SQL server to run on a server is a step in the right direction for fixing this licensing nightmare. We can only hope that other software companies follow suit.
Steven Hill
NWC Technology Editor

SQL Server 2005 Service Pack 2 offers a number of features, including data mining add-ins for the 2007 Microsoft Office suite that allow SQL Server Analysis Services (SSAS) to work within both Excel 2007 and Visio 2007. The software also promises SQL Server Reporting Services (SSRS) compatibility with Microsoft Office SharePoint Server 2007, making it possible for SSRS reports to be used and managed within SharePoint.

  • 1