Microsoft KB Archive/104785

FIX: RPC Uses Case Sensitive Passwords

PSS ID Number: Q104785 Article last modified on 10-31-1994

4.20

OS/2

BUG# OS/2: 1730 (4.2)

= SYMPTOMS =

When trying to initiate a Remote Procedure Call (RPC) from one untrusted server to another, you get error message:

7221, Login to site server2 failed.

Other logins on the same server, however, can use the same RPC with no problems.

= CAUSE =

When SQL Server initiates an RPC between two servers who are not in a trusted relationship, the password that the user logged on with will be compared to the password for that id on the remote machine. The comparison of the two passwords will be a character for character comparison. Even if the two servers have been installed with a case insensitive sort order, the comparison of the passwords during the RPC call will be case sensitive.

= WORKAROUND =

Ensure that the passwords on each server are the same case, even though the servers may be case insensitive. When logging in, ensure that your password is entered in the same case as the password on the server.

= STATUS =

Microsoft has confirmed this to be a problem in SQL Server version 4.2 for OS/2. This problem was corrected in SQL Server version 4.2aK11. For more information, contact your primary support provider.

Additional reference words: 4.20 connection KBCategory: kbother kberrmsg KBSubcategory: SSrvServer

=
================================================================

Copyright Microsoft Corporation 1994.