I have a BIDS report i was finally able to deploy (after 4 weeks of pain) to our MOSS 2007 server. I was even able to succesfully add the report to a site in SharePoint.
The problem is, i can view the report on the page if I am logged in locally to the MOSS WFE server. I have a co-worker that can view the page from his local machine. If I attempt to view the report on my local machine, I recieve a "The request failed
with a HTTP status 401: unauthorized". I'm sure the report works because i can view it from the moss server as I stated. The report is a basic query of a table. I am in the SYSADMIN group on the SQL server.
Authority = NTLM. Service configured using Trusted Account.
Does anyone have any ideas. I've seen many posts on this particular issue however absolutely no resolutions.
View Complete Post