I am using a URL string to access a Reporting Services 2008 report from an ASP .NET/VB 2005 Intranet Web Page. I have Built-in Admin. rights on the SQL Server and when using my IE browser I HAVE NO PROBLEM accessing the report. When a user with LESS privileges tries to access the report with their IE Browser they receive a LOGIN prompt. When a specific user tested, I was present and we were able to access the report typing in my WORKGROUP/DOMAIN username and password for the Login Prompt.
I am a user/admin. on all of the Servers, which are in a WORKGROUP, but I also use this same username to access the DOMAIN which is on the same network. Coincidentally, all the Servers (Web & Db) are in a WORKGROUP on the same Network but 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 username for the majority of our Intranet Web pages/SQL Server and are not prompted for username and password.
I have added the NetUser account to the SQL Server Db and SQL Server Reporting Services.
I have also added the NetUser using the Reporting Services Console and granted BROWSER privileges. The user is still prompted for a password.
The Intranet Web ASP .NET application accesses this Report Server from other ASP .NET pages without difficulty when running NON-Reporting Services SQL Server related reports. Also, the Network Services account was utilized when configuring the Reporting Services 2008. 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,