BUG: Service Pack 1 Setup Requires Default Named-Pipe Name

ID: Q237487

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 35418 (SQLBUG_70)

SYMPTOMS

When you attempt to install SQL Server 7.0 Service Pack 1 (SP1) on SQL Server 7.0 that is using an alternate pipe name, you will receive the following error message when attempting to log on using SQL Server authentication or NT Server authentication:

Setup was unable to validate your password. Press Retry to re-enter your password or press Cancel to exit out of setup.

-and-

This error message when using Windows NT authentication:

Setup was unable to validate the logged on user. Press Retry to enter another option, or Cancel to exit setup.

WORKAROUND

To work around this problem, use the Server Network Utility, shipped with SQL Server 7.0, to reset the pipe name back to its default, \\.\PIPE\SQL\QUERY if the connection is through named pipes. Or, use the Client Network Utility shipped with SQL Server 7.0 to reset the default network library into named pipes if the SQL Server does not listen to default TCP/IP port number.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words:

Keywords : kbSQLServ700
Version : winnt:7.0
Platform : winnt
Issue type : kbbug