Microsoft KB Archive/216812

= INF: Small Business Server 4.5 SQL Server 7.0 Limitations =

Article ID: 216812

Article Last Modified on 8/15/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q216812



SUMMARY
This article describes the differences between the version of Microsoft SQL Server included with the Microsoft BackOffice Small Business Server (SBS) 4.5 and the retail version of SQL Server 7.0.

The version of SQL Server included with Small Business Server 4.5 is very similar to the retail version of Microsoft SQL Server 7.0. The areas where it differs are discussed in this article.



MORE INFORMATION
'Setup'

The SBS edition of SQL Server uses an unattended installation script. There is no user interface and all default values are selected.

'Total Disk Capacity'

The SBS edition of SQL Server supports up to 10 gigabyte (GB) of total data space per database. The total size of a user database can not exceed 10 GB. However, this does not include the log space allocated for each database.

Furthermore, space allocated for tempdb database is not restricted to 10 GB size limit, as mentioned above.

Attempts to allocate space for a new or existing database exceeding the 10 GB limit fail with the following message:

SQL DMO

Error 1827: CREATE/ALTER DATABASE failed because resulting cumulative database size would exceed your licensed limit of 10240 megabytes per database.

'Client Utilities Installation'

SQL Server Setup on the Small Business Server computer automatically installs the client utilities on the server.

Unlike the earlier SBS version of SQL Server, in this version one can install the client utilities on client computers by executing sql70\setup.exe available in the CD (2 out of 3). On the Setup Type screen, choose Custom. On the Select Components screen, choose; Management Tools, Client Connectivity, and Books Online. Do not choose Server Components.

'Upgrading SBS components to Full Retail Edition'

It is possible to upgrade the individual components of the Small Business Server to full retail editions without upgrading the entire suite of products.

If you upgrade SBS edition of Windows NT server to the full retail version of Windows NT server, and continue to use the SBS edition of SQL Server, then the limitations outlined in this article for the SBS edition of SQL Server will continue to apply. Therefore, only 50 licensed clients will be able to access SQL Server simultaneously.

If you upgrade the SBS edition of SQL Server to a full retail version of SQL Server (running on the SBS edition of Microsoft Windows NT server), then SQL Server has none of the SBS edition limitations, whereas the SBS edition of Windows NT server will continue to be restricted on the maximum number of client licenses, which is 50.

You can not install the SBS edition of SQL Server on a full retail version of Microsoft Windows NT Server.

'Additional Information'

The performance of the Small Business Server Edition is limited to the throughput typical of 50 concurrent users, although individual SBS installations may be licensed for fewer than 50 users.

SQL Server will accept a maximum of 32767 user connections. This limit is not related to the performance throughput limitation or licensing, it refers only to the number of physical connections made to SQL Server. A single client computer can open multiple simultaneous connections and will only be counted as one license. The performance throughput is simply based upon server load. Once the load reaches the throughput typical of 50 concurrent users, performance will be degraded, regardless of how many user connections or licensed users it takes to reach this threshold. SQL Server will continue to accept new connections and process requests, however response time will be delayed in an amount relative to how much the throughput limit has been exceeded.

'Other Limitations'

The Small Business Server Version of SQL Server 7.0 does not support the following features:
 * Extended memory support
 * Failover support

Also, on SMP computers, Small Business Server Version of SQL Server 7.0 supports a maximum of 4 processors.

Small Business Server 4.5 SQL Server 7.0 Limitations

Additional query words: SBS 4.5, Small Business Server SQL 7.0, Limitations

Keywords: kbinfo KB216812

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.