I am using a URL string to access a Reporting Services 2008 report from an ASP .NET/VB 2005 Intranet Web Page. I have Admin. rights and when using my browser I HAVE NO PROBLEM accessing the report. When a user with LESS privileges tries to access the report they receive a LOGIN prompt. When a specific user tested, I was present and able to access the report using my WORKGROUP/DOMAIN username and password. I am a user on all the Servers, which are in a WORKGROUP, but I also use this same username to access a DOMAIN which is on the same network.
Coincidentally, all the Servers (Web & Db) are in a WORKGROUP on the Network that are not part of the domain. We utilize one username (i.e NetUser to access the application and Db) and all users pass this same name for the majority of our Intranet Web pages and are not prompted for username and password. I have added the NetUser using the Reporting Services Console and granted BROWSER privileges. The user is still prompted for a password. The Intranet application accesses this Report Server from other ASP .NET pages without difficulty when running NON-Reporting Services reports. Also, the Network Services account was utilized when configuring the Reporting Services. Does anyone have any suggestions or solutions to this LOGIN prompt problem! Preferably, NetUser will go directly to the Reporting Services report without prompt. THANK YOU IN ADVANCE,
