rsLogonFailed
New: 12 December 2006
Details
Product Name |
SQL Server |
Product Version |
9.0 |
Product Build Number |
9.00.1399 |
Event ID |
rsLogonFailed |
Event Source |
Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings |
Component |
Reporting Services |
Message Text |
Logon failed (rsLogonFailed) Logon failure: unknown user name or bad password. (ReportingServicesLibrary) |
Explanation
This error occurs when the report server attempts to connect to an external computer for the purpose of retrieving data or external image files through an impersonated connection and the connection request is denied. There are several reasons why this error might occur.
- This error will occur if you configure data source properties to use an account that is not valid for the target data source. For example, if you specify Windows integrated security, the domain user account of each user who runs the report must have permissions to log on and retrieve data from the target database.
- This error will occur if you configured the unattended report processing account and either the account or its password is no longer valid. Configuration of the unattended report processing account is optional, but once you configure it you must maintain it by ensuring the account and password settings are kept up to date.
- This error will occur if you configure data source properties to use stored credentials for a Windows domain user account, and either the account or the password is not correct.
- This error will occur if you configure data source properties to use stored credentials for a Windows domain user account, and that account does not have Allow log on locally permissions on the report server computer.
- If you are using custom or forms-based authentication, this error indicates that the authentication request did not succeed.
Action
To configure database permissions, see the product documentation of your database server.
To update the unattended report processing account, start the Reporting Services Configuration tool, open the Execution Account page, verify that Specify an execution account is selected, enter the user account and password, retype the password, and click Apply. If you want to delete the account instead, clear the check box and click Apply.
To grant the Allow log on locally user right to a Windows domain user account that you are using to retrieve data from a report data source, do the following:
- In Administrative Tools, open Local Security Policy.
- Under Security Settings, expand Local Policies, and then click User Rights Assignment.
- In the details pane, right-click Allow log on locally and then right-click Properties.
- Click Add User or Group.
- Click Locations, specify a domain or other location that you want to search, and then click OK.
- Enter the Windows account for which you want to allow interactive login, and then click OK.
- In the Allow log on locally Properties dialog box, click OK.
- Verify that the account you selected does not also have deny permissions:
- Right-click Deny log on locally and then right-click Properties.
- If the account is listed, select it and then click Remove.
See Also
Other Resources
Configuring an Account for Unattended Report Processing
Specifying Credential and Connection Information