SQL Server Report Server Setup / deploy report

I have SQL Server 2005 and VS 2005 on a Windows 2003 server.

I would like to be able to have users select reports from a web interface that I would provide and NOT have to login to the RS.  

I thought I could do this by setting anonymous security on the report folders, but to my surprise, I cannot see any report folders following deployment.

When I deploy, I specify a url of http://localhost/ReportServer and a folder of NewReport.

If I go into IIS manager, that folder does not exist, but yet I can run the report without a problem (of couse I have to login).

Is what I want to do (users run reports w/o logging in) possible and why isn't a folder created?

Thanks for any help you can give me.
dspaceAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pbocanegraCommented:
please go to RS Reports site:

for your case:

http://localhost/reports

For access for others users:

http://machine_name/reports

where machine_name is the ip or computer name where is RS.
0
dspaceAuthor Commented:
That would take me to the report manager, which is what I don't want to do.  I want to invoke the reports via a url.
0
JestersGrindCommented:
Keep using Windows Authentication.  Make sure your users have rights to the reports.  And add http://servername to their trusted sites in Internet Explorer.  This can be pushed out via group policy if you have a domain.  You could also take it a step further and give the default web site of your server a host header like reports.yourdomain.com, add an entry to your DNS server for it and add that name to your users trusted sites.

Greg

0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

pbocanegraCommented:
There is two ways:
ONE:
With the report Manager , You go to the specific report.
Take the url that appears in the address bar.
close IE

Oper IE
Call the report using this url.

TWO:
Instance a Web Service of Reporting Service into a Web Reference in VB.NET
0
dspaceAuthor Commented:
Thanks for all the suggestions, but all the answers are variations on simply running a report via a URL.  I can do this, but was hoping to be able to do it without having the user login upon invoking the report.  I can't try an alternate authentication scheme because we do not use the enterprise edition of SQL Server.  The report server is on the same box as IIS, so there is no problem with it being a trusted site.

In fact, I have pretty much given up on being able to do this and am trying to accomplish something much simpler.  Just letting the user login.

I have given the group "domain users" the browser role in report manage and even specified a single user with that role, but still get "permissions insufficient" when trying to run the report via a browser.  Does anyone have any suggestions here?

RS seems like a really nice product.  It's a shame I have to spend all my time trying to work around its security setup rather than actually creating reports - my rant for the day.

Thanks.
0
dspaceAuthor Commented:
It looks like the solution to my permissions problem is to assign permissions down to the specific report.  I thought it would be enough to assign permissions to the folder containing the report, but as soon as I went the next step, it finally worked.

0
CetusMODCommented:
PAQed with points refunded (500)

CetusMOD
Community Support Moderator
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.