Can Not View Reports (Please Help)

I am running RS on a W2K3 server. I have a report setup with a datasource to
use sql security. When I try to run the report from the server or from a
client I get a login failed for user "userid"
I am not sure what to check and have been toying with this for 3 days now. I
would appreciate any help!
Thank You.Andy,
I have nearly the exaxt same problem.
SQL Server 2000 SP3
SQL Reporting Services SP1 on the server and Report Designer client
W2K3 Server OS.
In Report Manager, I created a new role called View Reports Only which has
View Reports and View Folders permissions. I have assigned authenticated
users to have the View Reports Only role at the Home folder, which propagates
down through all folders and reports. Yet, the users get prompted with a
login / password dialogue when they try to view a report via a url link from
our intranet web page.
So far, the only way a user can run one of the reports is to be a member of
the Local Administrators group on the W2K3 server.
I have not loaded W2K3 Server SP1 yet. I wonder if any fixes for this
situation would be included with it. My company does not want to install
W2K3 Server SP1 on any of our live servers until we have time to do some
testing for any ill side affects.
I also have not loaded Reporting Services SP2 yet until I see fewer negative
posts on here about ill side affects. Unless it gurantees a fix for this
security issue.
Hopefully, someone on here can shed some light on this W2K3 security problem.
I have the exact same setup running on another server without any problems.
The only main difference is the server that behaves correctly is running W2K
Server OS, not W2K3 Server.
--
Owen B
SQL Report Writer
"Andy Jones" wrote:
> I am running RS on a W2K3 server. I have a report setup with a datasource to
> use sql security. When I try to run the report from the server or from a
> client I get a login failed for user "userid"
> I am not sure what to check and have been toying with this for 3 days now. I
> would appreciate any help!
> Thank You.
>
>|||Bump
--
Owen B
SQL Report Writer
"Owen B" wrote:
> Andy,
> I have nearly the exaxt same problem.
> SQL Server 2000 SP3
> SQL Reporting Services SP1 on the server and Report Designer client
> W2K3 Server OS.
>
> In Report Manager, I created a new role called View Reports Only which has
> View Reports and View Folders permissions. I have assigned authenticated
> users to have the View Reports Only role at the Home folder, which propagates
> down through all folders and reports. Yet, the users get prompted with a
> login / password dialogue when they try to view a report via a url link from
> our intranet web page.
> So far, the only way a user can run one of the reports is to be a member of
> the Local Administrators group on the W2K3 server.
> I have not loaded W2K3 Server SP1 yet. I wonder if any fixes for this
> situation would be included with it. My company does not want to install
> W2K3 Server SP1 on any of our live servers until we have time to do some
> testing for any ill side affects.
> I also have not loaded Reporting Services SP2 yet until I see fewer negative
> posts on here about ill side affects. Unless it gurantees a fix for this
> security issue.
> Hopefully, someone on here can shed some light on this W2K3 security problem.
> I have the exact same setup running on another server without any problems.
> The only main difference is the server that behaves correctly is running W2K
> Server OS, not W2K3 Server.
> --
> Owen B
> SQL Report Writer
>
> "Andy Jones" wrote:
> > I am running RS on a W2K3 server. I have a report setup with a datasource to
> > use sql security. When I try to run the report from the server or from a
> > client I get a login failed for user "userid"
> >
> > I am not sure what to check and have been toying with this for 3 days now. I
> > would appreciate any help!
> >
> > Thank You.
> >
> >
> >