INF: How to Disable Domain Authentication Boxes (158108)

SUMMARY

When using the 16-bit Windows Multi-Protocol Net-Library (Dbmsrpc3.dll) to connect to a computer running SQL Server, domain authentication dialog boxes appear that request you to provide the proper domain credentials. This article provides information about how to disable these dialog boxes.

MORE INFORMATION

By default, the 16-bit Windows Multi-Protocol Net-Library assumes integrated security on connection attempts. This causes the domain authentication dialog boxes to appear, requesting domain account information (this behavior is expected). For more information about this behavior, please refer to the following topics in the Administrator's Companion of SQL Server Books Online: Configuration, Configuring Client, Network Connections, and Multi-Protocol Clients.

To prevent the authentication dialog boxes from appearing, you need to disable the encryption feature of the Multi-Protocol Net-Libraries on both the client and the server. To do so, you need to add the following entry in the RPC Net-Library section of the client's Win.ini file:

[RPCnetlib]
Security=none

On the server, you need to do the following:

Run the SQL Server Setup program.
Select Change Network Support.
Go through the Multi-Protocol support.
Disable the encryption by clearing the check from the Enable Multi- Protocol Encryption check box.

Please note that if you only disable the encryption on the client, domain authentication boxes will still appear when connections are attempted. In addition, the authentication dialog box behavior is not affected whether you choose the standard or trusted connection on the client, nor does it depend upon the security mode (standard, mixed or integrated) of the SQL Server.