Login failed SSRS Domain\Machinename$

Pablo Porras 21 Reputation points
2020-09-01T17:47:43.113+00:00

Hi!

I have a 4-server Reporting Services 2019 farm, connected to a separate database server. The reporting services starts with a domain user and the reporting was properly configured. Currently the service works without problems and the reports are consumed normally. However, a Login Failed error is repeatedly observed in the Database Server Log. The error login is the 'domain\Machinename $'. The error can be observed by each of the 4 reporting services servers and from the moment the reporting services was configured.
Can this error be resolved?
PS: I had a reporting services 2016, but I never saw this problem.
Ex:
Message
Login failed for user 'MyDomain \ ServerSSRS1 $'. Reason: Could not find a login matching the name provided. [CLIENT: 192.168.0.25]

Message
Login failed for user 'MyDomain \ ServerSSRS2 $'. Reason: Could not find a login matching the name provided. [CLIENT: 192.168.0.26]

Sorry my English!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,743 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,805 questions
Accepted answer
  1. m 4,271 Reputation points
    2020-09-02T07:10:44.567+00:00

    Hi @Pablo Porras ，

    In this case, your client program is running using Local system or Network service. The account has been successfully identified on the SQL Server side, but you do not have the permission to log in to the SQL Server. The simplest solution is to add a "domain\machinename$" account to the login of SQL Server. Machinename is the machine name of the client.

    For your case, adding domain\ServerSSRS1,domain\ServerSSRS2 in your logins.

    This case may be helpful: login-failed-for-user-domain-machinename

    If the reply is helped, please do "Accept Answer".
    BR,
    Mia

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Abrams, Dan 86 Reputation points
    2020-09-01T18:31:06.433+00:00

    Hi Pablo,

    I have had similar problems with this error. The report server seemed to work properly, but every few minutes I got this "Login failed for user ... Domain\Server$ ... " message.

    Are you running SCOM? If SCOM is misconfigured, it can cause this error. SCOM (System Center Operations Manager) monitors many things, SSRS being one of them. You must configure SCOM security properly, otherwise this error gets generated.

    If you are running SCOM, check out these two manuals.

    1. https://systemcenter.wiki/ContentLibrary/SQL Server/ENU/SQLServer2016MPGuide.pdf
    2. https://systemcenter.wiki/ContentLibrary/SQL Server Reporting Services/ENU/SSRS2016MPGuide.pdf

    Good luck.

    --Dan

    0 comments
  2. Pablo Porras 21 Reputation points
    2020-09-01T19:15:40.363+00:00

    Thanks for your answers.

    I answer your questions.

    -I do not have any other service installed on the servers. Only the reporting services 2019.

    -The reporting is configured to connect by domain user to the DB, our infrastructure is supported under active directory and domain use and security policies establish the use of domain users to connect to databases.

    -SCOM is not being used at the moment.

    0 comments
  3. DJAdan 671 Reputation points
    2020-09-01T19:42:27.037+00:00

    Hi Pablo,

    • SCOM is not being used at the moment

    Try the following command from SSMS:

    select spid, nt_username, hostname, hostprocess, program_name from sys.sysprocesses where program_name like '%Monitor%' order by spid;

    In my case, it was SCOM, even though I didn't think it was installed.

    --Dan