IBM Support

Error=1326 SQL when connecting to Microsoft SQL Server Schema repository

Troubleshooting


Problem

This technote provides a possible solution to the following error that occurs when attempting to connect to the IBM® Rational® ClearQuest® Microsoft® SQL database: [][State =01000][Error=1326][Microsoft][ODBC SQL Server Driver] [SQL Server]"Logon failure: unknown user name or bad password."[]

Cause

Error 1326 means "Logon failure: unknown user name or bad password." This error is raised because the IIS Service does not have any rights to use the named pipe.

In order for a client to gain access to a Windows NT named pipe, the client needs to be validated by the Windows NT server. This is normally accomplished through a Workgroups-style validation method where identical usernames and passwords are created on the client and the server, or the domain method where both the client and server are domain members.

The Internet Information Server (IIS) setup process creates a Windows NT ID called IUSR_machinename (where machine name is the name of the Windows NT server), and adds that user to the Guest local group. The IIS service runs under this Windows NT account name.

If the connection to IIS is anonymous, IIS uses the Windows NT account IUSR_machinename and so any network activity performed by IIS is done under this account ID. If the SQL server resides on the same server as IIS, then named pipes connections work and validation is successful. If the SQL server resides on a separate server from IIS, then the IUSR_machinename account needs to be validated on the Windows NT server that SQL resides on.

Resolving The Problem

This account must be verified by the server hosting Microsoft SQL Server in order for the connection to occur properly. If this account is not verified, then the connection fails and provides only the line number in the script file of the attempted connection opening.

To resolve this problem, you can use one of the following options:

  • Enable the Windows NT ID Guest.
  • Make the Windows NT user, IUSR_MachineName, a member of the domain where SQL server resides.
  • Use the account information from Internet Service Manager to set up a local user account on the Windows NT Server that hosts SQL Server.





[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Database Configuration\/Connectivity - SQL Server","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2002.05.00;2002.05.20;2003.06.00;2003.06.01;2003.06.10;2003.06.12","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Historical Number

11672

Document Information

Modified date:
04 December 2018

UID

swg21134134

Page Feedback