UDA Error Messages

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

You did not specify a valid username

"You did not specify a valid username" errors are generated by the OpenLink Request Broker, based on the active Session Rulebook. They may occur when you attempt to query Microsoft SQL Server, and do not pass a username. This behavior is an added OpenLink security feature, intended to compensate for an authentication bug in SQL Server. If you want to disable this security feature, take the following action:

1. Use a text editor to open the oplrqb.ini file which you find in the /bin/ sub-directory of your OpenLink server components installation.
   
2. Locate the [Domain Aliases] section of the Rulebook.
   
3. Determine how your client's "Domain" or "ServerType" value is aliased. For instance:
   
   

   
   SQLServer 7 = sql7
   

   
   
4. Locate the [Mapping Rules] section of the Rulebook.
   
5. Find the rule associated with your alias and the error. For example:
   
   

   
   sql7:*:blank:*:*:*:* = reject You did not specify a valid username
   

   
   
6. Place a semicolon in front of the rule. For example:
   
   

   
   ;sql7:*:blank:*:*:*:* = reject You did not specify a valid username
   

   
   
7. Insure that a rule exists which accepts the alias. For example:
   
   

   
   sql7:*:*:*:*:*:* = accept generic_sql6
   

   
   
8. Restart or reinitialize your Request Broker to register your changes.
   
9. Test.

Evidence

• Request Broker Session Rulebook
  
• Request Broker Log