What and Where is report manager? and how can I delete reports? -- sql server reporting services

Jeje
10/28/2007 11:37:42 PM

through the web by default:
http://<server>/reports

using management studio, open a connection to your RS server:
http://server/reportserver

else use the reporting services configuration tool to identify (or create)
the web servers and virtual folders deployments.

Jerome.

[quoted text, click to view]

William Vaughn
10/29/2007 10:33:54 AM

Ah, close. These URLs will work unless you install SQL Server as a named
instance. In this case, each of the Reporting Services URLs need to be
adjusted to point to the specific instance as in:

[quoted text, click to view]
as in
http://betav9v$ss2k5/reports

[quoted text, click to view]

as in
http://server/reportserver$ss2k5

HOWEVER, if you've installed the SP2 SharePoint extensions I expect the
Report Manager has been deactivated...

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]

Bruce L-C [MVP]
10/31/2007 12:00:00 AM

All sites automatically have Report Manager. This is the portal that needs
to be there for managing the RS.

http://yourserver/Reports/Pages/Folder.aspx

Are you in the local administrators group on the server? If not, then
someone who is needs to add you to the local administrators group OR you
need to have someone who know RS add you to the appropriate role in RS
(which they use Report Manager to do).

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

jobs
10/31/2007 9:46:01 AM

The admins did install sp2, not sure about sharepoint extensions?

if I go to http://servername/Reports

I get a page with this and no options for creating folders.

SQL Server Reporting Services
Home

If I attempt to deploy my reports to the new ssrs instance (I got the
report from development and changed deployment information)

Deploying to http://servername/reportserver/
Error rsItemAlreadyExists : The item '/myfolder' already exists.

How do I enable report manager, how do I create a folder for
deployment? This is a brand new sql server, ssrs install on sql server
cluster.

Thanks for any help or information.

jobs
10/31/2007 9:52:40 AM

it's a new sql server install. They did just install sp2.

If i attempt to access the report server site I just get a home page
with no options to create folders etc like i do on development.

If I attempt to deploy my report after changing deployment to point to
the new server (which works from vs.net pointing to the new databases)
I get:

Deploying to http://amsqlxx/reportserver/
Error rsItemAlreadyExists : The item '/Retailer' already exists.
(which does not make sense)

I guess i need to know, how can I create new ssrs folders on the new?
and maybe activate report manager?

jobs
10/31/2007 11:40:06 AM

Thanks. SSRS is on one of two sql server clustered servers.

If I enter,

http://servername/Reports

i get what looks like the report manager page, but no buttons for
creating folders

if I enter

http://ip address/Reports

i'm prompted for user/pass, I have an account that has administrator,
i enter it and it just sits there.

jobs
10/31/2007 11:54:02 AM

Comparing my development server to my production server (which is not
working).

production is one of two servers which are clustered.

Looking at the configure Reporting Services page:

production has a blue exclamation for sharepoint services (that
feature is not available in development), and a grayed checkmark for
initialization (which is green in production), which indicates that
feature is not supported int he current mode.

In production am getting the report manager to come up, but there are
no options available for creating a folder.

Bruce L-C [MVP]
10/31/2007 1:49:37 PM

I'm not familiar with the requirements for installing RS on clustered
servers. My guess is that your problem has to do with that area.

One other thing to try. There is the report server configuration tool (not
sure exact name). Try that and make sure it says everything is good. It is
on the machine that you had it installed on. If possible remote desktop to
it and check out the configuration. Perhaps it will show an error.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Bruce L-C [MVP]
10/31/2007 2:35:34 PM

You have two issues you need to resolve. First, is it installed properly for
a cluster BUT just an important, is it installed properly for having
sharepoint services? I know installing with sharepoint requires some steps.
Until the configuration tool is green you are in trouble.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : What and Where is report manager? and how can I delete reports?