Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 288128 - Last Review: November 2, 2007 - Revision: 1.2
PRB: Application Center 2000 Installation Hangs While Attempting to Start SQL Personal 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 "hang" 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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=282455/EN-US/
)
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 "More Information" 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 "Resolution" section:
IF NOT EXIST "\Program Files" ECHO You must run the CMD on the drive where program files exists
IF EXIST "\Program Files\Microsoft SQL Server" GOTO NEXT1
CD "Program Files"
MD "Microsoft SQL Server"
:NEXT1
IF EXIST "\Program Files\Microsoft SQL Server\MSSQL$MSAC" GOTO NEXT2
CD "\Program Files\Microsoft SQL Server"
MD MSSQL$MSAC
:NEXT2
IF EXIST "\Program Files\Microsoft SQL Server\MSSQL$MSAC\Binn" GOTO EXIT
CD "\Program Files\Microsoft SQL Server\MSSQL$MSAC"
MD Binn
:EXIT
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=288127/EN-US/
)
PRB: MSSQL$MSAC Service Fails to Start If There are More Than 47 IP Addresses on a NIC
REFERENCES
For additional information, click the article number below
to view the article in the Microsoft Knowledge Base:
282455Â
(http://kbalertz.com/Feedback.aspx?kbNumber=282455/EN-US/
)
FIX: SQL Server Fails to Start When Computer Binds 48 or More Socket Addresses
APPLIES TO
- Microsoft Application Center 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please