INF: Small Business Server 4.5 SQL Server 7.0 Limitations

ID: Q216812

The information in this article applies to:

Microsoft SQL Server version 7.0

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 retain version of SQL Server (running on SBS edition of 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 licensed client connections of 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

OLAP services

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

OLAP Support	No
Clustering Support	No
Extended Memory Support	No
Parallel Query	Yes
Full-text Search	Yes
Replication	All types - yes
Per Seat Licensing	Yes
Per Server Licensing	Yes
Maximum Database Size	10 GB - Excluding Log file
Maximum Client Threads	30 - Maps to about a Max. of 50 concurrent users
Maximum SMP	4 Processors

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

Keywords : kbSQLServ700
Version : winnt:7.0
Platform : winnt
Issue type : kbinfo