Microsoft KB Archive/288128

= PRB: Application Center 2000 Installation Hangs While Attempting to Start SQL Personal Edition =

Article ID: 288128

Article Last Modified on 11/2/2007

-

APPLIES TO


 * Microsoft Application Center 2000 Standard Edition

-



This article was previously published under Q288128



SYMPTOMS
If you have more that 47 IP addresses assigned to a single network interface card (NIC), Application Center 2000 installation may &quot;hang&quot; while trying to start Microsoft SQL Server 2000 Personal Edition. If you stop the installation, it will roll back to an uninstalled state.



CAUSE
Application Center 2000 installs an instance of SQL Server 2000 Personal Edition named MSSQL$MSAC. This instance must be started in order for Application Center 2000 installation to complete. SQL Server 2000 has a known issue that prevents it from starting if it listens on a NIC that has more than 47 IP addresses assigned.



RESOLUTION
To resolve this problem, you can temporarily reduce the number of IP addresses to 47 or less on the NIC and then reinstall Application Center 2000. After the installation completes, apply the SQL hotfix described in the following Microsoft Knowledge Base article:

282455 FIX: SQL Server Fails to Start When Computer Binds 48 or More Socket Addresses

After you have applied the hotfix, you can add the removed IP addresses back onto the NIC.

If you must preserve all the IP addresses on the NIC during Application Center 2000 installation, however, then you must preinstall the hotfix. You can either:
 * Copy the Application Center 2000 Installation CD-ROM to your local computer or network drive, and then replace the version of Ssnetlib.dll that is in the Application Center 2000 X86\Binn folder with the version that is included in the hotfix. You can then install from the modified copy. -or-


 * You can create the \Microsoft SQL Server\MSSQL$MSAC\Binn folders under the Program Files folder on the computer on which you want to install Application Center 2000. Place the version of Ssnetlib.dll that is included in the hotfix described earlier in this section into the Binn folder. You can then install Application Center 2000. You can run the batch file described in the &quot;More Information&quot; section of this article to create the required folders.



MORE INFORMATION
You can run the following cmd file to create the necessary folders for use in the method described at the end of the &quot;Resolution&quot; section: IF NOT EXIST &quot;\Program Files&quot; ECHO You must run the CMD on the drive where program files exists IF EXIST &quot;\Program Files\Microsoft SQL Server&quot; GOTO NEXT1 CD &quot;Program Files&quot; MD &quot;Microsoft SQL Server&quot;
 * NEXT1

IF EXIST &quot;\Program Files\Microsoft SQL Server\MSSQL$MSAC&quot; GOTO NEXT2 CD &quot;\Program Files\Microsoft SQL Server&quot; MD MSSQL$MSAC
 * NEXT2

IF EXIST &quot;\Program Files\Microsoft SQL Server\MSSQL$MSAC\Binn&quot; GOTO EXIT CD &quot;\Program Files\Microsoft SQL Server\MSSQL$MSAC&quot; MD Binn
 * EXIT

NOTE: If you add IP addresses after a successful installation of Application Center 2000 and exceed 47 IP addresses, SQL Personal Edition may fail to start. For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

288127 PRB: MSSQL$MSAC Service Fails to Start If There are More Than 47 IP Addresses on a NIC

