SSRS report - Login failed for user

mark goldin 691 Reputation points
2022-03-17T19:14:03.897+00:00

I am getting "Login failed for user". I am running my report in ReportViewer with no SSRS server.
If I use Windows

184226-image.png

Then I get System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'domainname\username$'.

But I use:
184170-image.png

With SQL user credentials then I get: System.Data.SqlClient.SqlException (0x80131904): Login failed for user ''.

Please help.

Thanks

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,799 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Isabellaz-1451 3,616 Reputation points
    2022-03-18T02:06:02.827+00:00

    Hi @mark goldin

    I think It means you don‘t have access to the database， maybe your account is not the system adminstrator so you can’t use the windows authentication，and your sql user account has no login access . You can test by using SSMS connect the sql engine to see if it works.

    Best Regards,
    Isabella

    If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Isabellaz-1451 3,616 Reputation points
    2022-03-18T08:09:10.1+00:00

    Hi @mark goldin

    go to Sql Server Configuration management->SQL Server network config->protocols for 'servername' and check named pipes is enabled.

    I referred to this thread,you can take a look :https://stackoverflow.com/questions/26135346/sql-connection-error-system-data-sqlclient-sqlexception-0x80131904#:~:text=System.Data.SqlClient.SqlException%20%280x80131904%29%3A%20A%20network-related%20or%20instance-specific%20error%20occurred,server%20was%20not%20found%20or%20was%20not%20accessible.

    also please make sure you have the Mixed-Mode authentication enabled：
    http://csharp.net-informations.com/data-providers/failed.htm#:~:text=Login%20failed%20for%20User%20is%20a%20general%20sql,and%20this%20message%20is%20returned%20to%20the%20client.
    Best Regards,
    Isabella

    If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments