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.
