Microsoft KB Archive/104785

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 17:49, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

FIX: RPC Uses Case Sensitive Passwords

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

4.20

OS/2

The information in this article applies to:
- Microsoft SQL Server version 4.2 for 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.