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:
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