Microsoft KB Archive/107708
The information in this article applies to:
- Microsoft SQL Server version 4.2x
When running SQL Server Setup program, either during the installation or later, the SQL Server Setup for Windows NT - Options windows has the Change Network Support option disabled or greyed out. This option is used to Install/Uninstall Network support (NWLink IPX/SPX, TCP/IP Sockets and/or User provided) and Named Pipes.
This option is greyed out when you run SQL Server Setup, if one of the following is true:
You have the Desktop version of SQL Server. This version is designed to work only locally. It is for one user 25 connections (non-networked). As a result, it uses named pipes on the SQL Server machine only and does not need the additional network support.
To verify that you have desktop version, check on the SQL Server box and SQL Server disks, which indicate Desktop version on them. Additionally, if you try to connect from SQL Server clients to the Desktop version server, you would get the message on the client:
Configured for local access only
- You have previously turned on the Windows NT Integrated login security mode through SQL Server setup program. This security option is provided for named pipes clients only and you cannot install additional network support if this option is being used.
This is mentioned on page 35 of SQL Server for Windows NT "Configuration Guide". Please refer to it for further information.
Additional query words: 4.20 mixed standard grayed gray Windows NT
Keywords : kbsetup
Issue type :
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2
Last Reviewed: March 19, 1999