troubleshooting Question

Report causes 401 unauthorized error message

Avatar of Member_2_3698648
Member_2_3698648Flag for Australia asked on
SSRS
4 Comments1 Solution290 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Member_2_3698648

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros