<div>
DantheDBA,As it turned out I had to update to SQL 2005 for the requirements of the accounting package. &nbsp;The free standing copy of SQL 2005 for Workgroups was $1499, but the upgrade to SBS R2 was only $699. &nbsp;Obviously I chose the SBS R2 upgrade. &nbsp;Thanks for your comments.<br />
<br />
Jon<br />

</div>


DantheDBA,As it turned out I had to update to SQL 2005 for the requirements of the accounting package.  The free standing copy of SQL 2005 for Workgroups was $1499, but the upgrade to SBS R2 was only $699.  Obviously I chose the SBS R2 upgrade.  Thanks for your comments.

Jon


<div>
<div class="content wysiwyg-content">
I have a client that is upgrading an accounting package that is currently installed on Windows 2003 SBS Premium and is using SQL 2000. The new accounting upgrade supposedly works in SQL 2000 or 2005. &nbsp;Would there be any advantage or reason to upgrade to SQL 2005? &nbsp;Would that be done by adding SQL 2005 to the SBS or would we just upgrade to SBS R2?<br />
Thanks
</div>
</div>


I have a client that is upgrading an accounting package that is currently installed on Windows 2003 SBS Premium and is using SQL 2000. The new accounting upgrade supposedly works in SQL 2000 or 2005.  Would there be any advantage or reason to upgrade to SQL 2005?  Would that be done by adding SQL 2005 to the SBS or would we just upgrade to SBS R2?
Thanks

Upgrade to SQL 2005?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Small Business Server (SBS) is a line of server operating systems targeted at small businesses by bundling the operating system with a number of other Microsoft products that would normally need to be purchased or licensed separately. The most notable inclusions are Exchange, SQL Server, SharePoint and ISA/TMG (Microsoft's firewall and proxy server).