Solved

RDLC Run from application is asking for Windows log in credentials

Posted on 2014-09-22
14
305 Views
Last Modified: 2014-10-11
I have set the unattended access, but when I attempt to run the report remotely I am getting prompted for the Windows log in.   What have I missed?
0
Comment
Question by:rcowen00
  • 7
  • 6
14 Comments
 
LVL 49

Expert Comment

by:Vitor Montalvão
ID: 40338490
From the lack of information I can only guess that you are running with an user without the necessary permissions.
0
 

Author Comment

by:rcowen00
ID: 40340427
What details can I give you that would help you to assist me?  Sorry, I have been turned all around with this problem and have no idea what you need.  Thank you.
0
 
LVL 49

Expert Comment

by:Vitor Montalvão
ID: 40341052
Can you post a screenshot?
And how it's configured the connection to the database?
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:rcowen00
ID: 40342007
The application has a connection string saved in the web.config.  The report uses a shared data source that holds the database connection information.  I call the report from the code behind using this and render it is pdf

 
    Protected Sub btnRun_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnRun.Click

        Response.Redirect("http://xxxxx/ReportServer/Pages/ReportViewer.aspx?%2fPOSReports%2fWeeklyGrossDetail&rs:Command=Render&rs:Format=PDF&Begin=" & txbgn.Text & "&End=" & txend.Text & " ")
    End Sub
   

Open in new window


Up until recently, I was using a report viewer control to view the report in the application to view/print the report.  The report viewer control  used this as the ReportServerUrl="http://localhost:80/reportserver".  Since the report viewer doesn't have all functionality when  used in non IE browsers, we needed a better solution.   When that change was made is when I started being asked for the Windows credentials when running the reports.  Service Accountwebservice-url.PNGReport server databaseExecution Account  

Yesterday I added the following class to push the windows credentials, but I am not sure how to implement, if that is even my problem.

Imports Microsoft.VisualBasic
Imports Microsoft.Reporting.WebForms
Imports System.Net

Public Class ReportServerCredentials

    Implements IReportServerCredentials

    Private _userName As String
    Private _password As String
    Private _domain As String

    Public Sub New(ByVal userName As String, ByVal password As String, ByVal domain As String)
        _userName = userName
        _password = password
        _domain = domain
    End Sub

    Public ReadOnly Property ImpersonationUser() As System.Security.Principal.WindowsIdentity Implements Microsoft.Reporting.WebForms.IReportServerCredentials.ImpersonationUser
        Get
            Return Nothing
        End Get
    End Property

    Public ReadOnly Property NetworkCredentials() As ICredentials Implements Microsoft.Reporting.WebForms.IReportServerCredentials.NetworkCredentials
        Get
            Return New NetworkCredential(_userName, _password, _domain)
        End Get
    End Property

    Public Function GetFormsCredentials(ByRef authCookie As System.Net.Cookie, ByRef userName As String, ByRef password As String, ByRef authority As String) As Boolean Implements Microsoft.Reporting.WebForms.IReportServerCredentials.GetFormsCredentials
        userName = _userName
        password = _password
        authority = _domain
        Return Nothing
    End Function
End Class

Open in new window

0
 
LVL 49

Expert Comment

by:Vitor Montalvão
ID: 40343327
Avoid using Network Service since it has very few privileges. I recommend you to change it to Local System account.
0
 

Author Comment

by:rcowen00
ID: 40350458
I changed to Local System and the users are still being asked for windows login for the server.
0
 
LVL 49

Expert Comment

by:Vitor Montalvão
ID: 40351807
The SQL Server is in the same machine of SSRS?
0
 

Author Comment

by:rcowen00
ID: 40353627
yes
0
 
LVL 49

Expert Comment

by:Vitor Montalvão
ID: 40353979
Then check if Local System has permission on SQL Server.
Also check Windows Event Log and MSSQL logs for errors.
0
 

Author Comment

by:rcowen00
ID: 40361450
If I have the identity impersonate set to true shouldn't the application be running under that identity?  

<identity impersonate="true"  userName="xxxx" password="xxxx"/>
            <httpHandlers>
0
 
LVL 49

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40363158
Theoretically speaking, yes. But I never used that option so I can't help you with that. Maybe something is missing for you can use the impersonation.
0
 

Assisted Solution

by:rcowen00
rcowen00 earned 0 total points
ID: 40365007
I received the following from an acquaintance versed in SSRS deployment and he suggested using crystal reports vs SSRS.  

I’m sorry but so far I couldn’t find a solution to this problem after 2 days of research.
 
SSRS2008  is pretty tight with security and to only allow public anonymous access would be to use 2005.
 
The only way I see around this is to mirror the report view much like the  Contribution report and then allow the franchisees to download via pdf.
 
I’ve tried giving access to /everyone as well as nt authority/anonymous logon in both server and report manager but that didn’t work.
 
Given the time constraint mirroring the contribution report would be the best option.
0
 

Author Closing Comment

by:rcowen00
ID: 40374587
Issue was never resolved, but I gave the reason for that myself.
0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSRS 2013 - Finding Datasets/StoredProcedures 4 32
selective rebuild of SQL Tables in scheduled job 10 37
SQL Select Query help 1 34
Database Owner 3 14
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question