Microsoft KB Archive/180364

= PRB: Small Business Server and SQL Server Licensing Message 18458 =

Article ID: 180364

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q180364



SYMPTOMS
When attempting to log on to SQL Server on Microsoft Small Business Server, a user may receive the following message:

Msg 18458, Level 14, State 1, Server Microsoft SQL Server, Line 0

Login failed- The maximum simultaneous user count of 5 licenses for this

server has been exceeded. Additional licenses should be obtained and

registered via the Licensing application in the NT Control Panel.



CAUSE
If SQL Server has been upgraded from the Small Business Server version (yet remains on Small Business Server Windows NT) and you subsequently use the client add pack to add Windows NT licenses, SQL Server is not notified of the additional licenses.



WORKAROUND
The licensing application has been removed from the Small Business Server. To allow SQL Server to recognize the additional licenses, run Registry Rebuild for SQL Server from SQL Server setup. To do this, perform the steps below.

NOTE: It is recommended that you make a complete backup of your system before performing the registry rebuild.

 From a command prompt, switch to the Mssql\Binn directory. Type the following command exactly as it appears, including capitalization (note that a space on either side of the equal sign is required):

setup /t RegistryRebuild = On

For more information on the RegistryRebuild option, see the following article in the Microsoft Knowledge Base:

157805 : BUG: RegistryRebuild Option of Setup Is Not Documented

This will bring up SQL Server setup. It will appear as though SQL Server is being reinstalled, but it is just re-writing the registry information. Start SQL Server normally.



MORE INFORMATION
After upgrading SQL Server Small Business version to full SQL Server, you will also need to apply the latest SQL Server service pack.

Additional query words: SBS SAM connections out

Keywords: kbprb KB180364

-

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

© Microsoft Corporation. All rights reserved.