<div>
401 in html occurs when the authorization fails. What login id and password are you typing? Can you validate that?<br />
And just clear the cache in the internet explorer, if it will help.
</div>


401 in html occurs when the authorization fails. What login id and password are you typing? Can you validate that?
And just clear the cache in the internet explorer, if it will help.

<div>
the login and password is the same for other reports which work fine on the report server.<br />
i understand that the 401 is an authorization failure. <br />

</div>


the login and password is the same for other reports which work fine on the report server.
i understand that the 401 is an authorization failure.


<div>
I did the reboot and the report now works.
</div>


I did the reboot and the report now works.

<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
I have a report which I am trying to run in my development environment which fails with a &quot;401 unathorized&quot; error message. the report is a tablix report, and fails after 31 records (irrespective of data set). I cannot understand why this is happening,, I have tried recreating the report, restarting the report server, confirming that the data source is correct.<br />
I came up with the 31 records after placing a TOP clause in my stored proc to restrict records after i found a dataset with 7 records was fine, but 100 records was not.<br />
the tablix is pivoting the information the stored proc returns.<br />
What is more strange is that the report runs fine in production for any dataset.<br />
<br />
Any help or suggestions are very much appreciated<br />

</div>
</div>


Hi Experts

I have a report which I am trying to run in my development environment which fails with a "401 unathorized" error message. the report is a tablix report, and fails after 31 records (irrespective of data set). I cannot understand why this is happening,, I have tried recreating the report, restarting the report server, confirming that the data source is correct.
I came up with the 31 records after placing a TOP clause in my stored proc to restrict records after i found a dataset with 7 records was fine, but 100 records was not.
the tablix is pivoting the information the stored proc returns.
What is more strange is that the report runs fine in production for any dataset.

Any help or suggestions are very much appreciated


Report causes 401 unauthorized error message

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.