Hi,

I am using SQL Server 2008 R2 on my server. I have installed the Reporting Server and configured the same. I have developed a report using SSRS and installed the report on my server and added myself with all the roles in SSRS. When I browed/access the report through IE in the same server, I am able to view the report successfully.

But here the problem is, when I was trying to access the same report from my local machine using http://<<servername>>/reports it is asking for the credentials. If I would give the credentials also, it is keep on asking the credentials and displaying nothing on IE.

Can any one help me in resolving the issue ?

Appreciate your help !!

Thanks in advance,

-

navin_reddy

Check to see whether you've set the encryption key

Where is the data that you're reporting off of?  does it exist on the same server where SSRS is installed, or is it on a different server?  What type of credentials did you set up when you created the data source?

Hi navin_reddy,

From your description, the issue is that, while accessing a remote report server, there is a login dialog promptted. After typing 3 or 4 times correct username and password, nothing or 401 error is displayed in the Internet Explorer(IE) page. If I have misunderstood, please don't hesitate to let me know.

This issue is caused by the client's credential is not send to report server correctly. It may happen when the report server is configured to use Kerberos authentication, however, the Service Princip Name(SPN) is not registered correctly.
By default, the Kerberos authentication is enabled for a report server.

So, in this case, please register the SPN for the report server service account to fix the issue. Or, please force the report server to use NTLM authentication, we can do it in this way:

1. Open the rsreportserver.config(By default, it can be found from C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer)
2. Comment the <RSWindowsNegotiate/> under <AuthenticationTypes> element.

For more information about this issue, please see:
http://msdn.microsoft.com/en-us/library/cc281253.aspx#proxyfirewallRSWindowsNegotiate
http://msdn.microsoft.com/en-us/library/ff679930(SQL.100).aspx

If you have any more questions, please feel free to ask.

Thanks,
Jin Chen

Hi Chen,

Thank you very much for your information. I have resolved the issue with your information and now am able to access the reports from my local machine.

Thanks once again.

 

-

Navin Reddy

There is also one important point to add to this discussion:

http://www.bigator.com/2012/06/21/ssrs-report-is-asking-for-username-and-password-while-executing/

Thanks, Khilit

SPN Registration helped me because I have used domain account for SQL Reporting Services

Read doc attached in link.

http://msdn.microsoft.com/en-us/library/ff679930.aspx

Read page no. 13 in word doc

Commands will be

To add SPN with computer name

setspn -A HTTP/contoso domain\rssvcacct

setspn -A HTTP/contoso.domain.corp.company.com domain\rssvcacct

I have configured SQL 2012 Sp1 Reporting for Service Manager 2012 Sp1

http://social.technet.microsoft.com/Forums/systemcenter/en-US/a2a0b898-adc4-4609-9831-818ae97f3889/scsm-2012-reports-not-showi