August 29, 2007 at 3:00 pm
I would think this would be a simple task, but its proving to not be so simple. Maybe I'm overlooking something.
I have an sql 2005 server, on that same server and same instance I'm running a report server.
I have an asp.net server that pulls data from this database and displays it on its web page. I'm trying to get a webpage to display report a report from my SQL Report Services.
I'm coming across an issue with user permissions.
I'm thinking that since I already have a user login for that db, I should be able to grant it permissions or something along those lines, but I'm not really sure.
I'm also wondering if i need to be uploading the reports to the SRS or if I can store them as part of the Website project.
Kris
August 30, 2007 at 9:35 am
Hi Kris,
Couldnt understand at what point you encountred the User permission issue. Are you trying to display the report in report viewer? And are you using localized reports or reports deployed on server.
If reports are deployed on the Report server then to the specific folder in report server you can assign the credetentials. :- Sameer
August 30, 2007 at 12:47 pm
After doing some testing, maybe I'm going about this the wrong way.
I have a asp.net web site, I need to provide reports to my users concerning the data they've entered into the site that's stored in the SQL Server.
Now I started on the path of using SQL Reporting services and saw it as a mechanism for creating reports that could be in turn displayed through the web pages of my website.
If this is the best way over doing this, it would seem that I need to make some sort of connection string and set up a user within the reporting services that will have browser access on the report server. (For now the same reports will be available to everyone on the site so I don't think I need to set up form authentication, but maybe I'm wrong on that too)
Thanks for your time, any assistance would be very helpful.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply