Share via

Tracing Report name for Failed login - Sql 2008R2

pdsqsql 431 Reputation points
2020-11-19T22:51:33.997+00:00

Hi,
We have Sql 2008R2 and we are running through scheduler to generate report which reporting application is on another server.
So when Reporting application run, it calls Sql 2008 R2 database table but somehow specific report have bad password and it fails so Sql server log generate the message: 

Login failed for user 'userSql'. Reason: Password did not match that for the login provided. [CLIENT: xx.x.x.111]

I tried to trace the login info and found the IP Addreess, machine name, application name, login but not getting exact report name.

Any idea how to get the exact report name?
We have 100+ reports running everyday so manually checking the password it's harder.

Thanks for your help!

SQL Server Other

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sean Gallardy - MSFT 1,901 Reputation points Microsoft Employee
    2020-11-20T01:02:32.317+00:00

    Any idea how to get the exact report name?

    Report names aren't things that a login is going to know about. I'm not sure what reporting software you're using but there should be a data source/connection or some other type of object for it (for example system and application data sources that can be set via Windows). You'll need to investigate those.

    -Sean

  2. m 4,276 Reputation points
    2020-11-20T03:28:32.11+00:00

    Hi @pdsqsql ,

    Login failed for user 'userSql'. Reason: Password did not match that for the login provided. [CLIENT: xx.x.x.111]Any idea how to get the exact report name?

    What Authentication you ues? Windows Or SQL Server?

    Your error is not caused by the table. The messages shows clearly, the password is not match. So please verify whether you use one correct password. Or please create one new user and new password to have a test.

    More information: troubleshooting-error-18456,login-failed-for-user-error-message-when-you-log-on-to-sql-server

    BR,
    Mia

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments
  3. pdsqsql 431 Reputation points
    2020-11-20T18:08:34.407+00:00

    Thanks Mia.
    The login having bad password is Sql login.
    You are right it's not caused by table and error due to incorrect password.
    Only thing we have lots of reports running into morning using same sql login for all the reports and some of of the reports having bad password which throwing an error and i am trying to track what's exact reports having incorrect password out of multiple reports.
    I am able to trace it down which application and host but couldn't get it exact report name having bad password.

    Thanks for your help!

    0 comments
  4. m 4,276 Reputation points
    2020-11-23T02:45:40.363+00:00

    Hi @pdsqsql ,

    You can get the report name from the Report Server's error log:

    In SQL Server Reporting Services 2016 or earlier: C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles

    In SQL Server Reporting Services 2017 later: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles

    BR,
    Mia

    If the answer is helpful, please click "Accept Answer" and upvote it.

  5. m 4,276 Reputation points
    2020-11-24T01:35:15.737+00:00

    Hi @pdsqsql ,

    Is the issue solved?
    Is the reply helpful?

    BR,
    Mia

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.