Showing posts with label home. Show all posts
Showing posts with label home. Show all posts

Wednesday, March 7, 2012

RS Manager how to setup the admins ?

I finally got RS 2005 up and running.

However when I go to my report manager all I see at the top is:

SQL Server Reporting Services
HOME

and at the top right links to HOME | My Subscriptions | Help

But as in 2000 i do not see how to add folders / reports or view
details. Its as if it is missing one piece of security. I need to
tell reporting services manager that I am an admin / developer and to
allow me to do this. Where or how can I do this? As I do not have any
permissions to do it right now in RS Report Manager.

We are running on win2k3, rs 2005, sql server 2k5.

Thanks,
Jon

Hi Jon,

You should be able to connect to RS 2005 using SQL Management Studio, and manage security settings from there.

http://msdn2.microsoft.com/en-us/library/aa337385.aspx

cheers,

Andrew

Saturday, February 25, 2012

RS Configuration

I'm working on a RS 2005 demonstration for my employer. On my equipment at home, the install goes just great. (winxp pro) On the server at work (that I have limited control over), I've managed most of the install successfully using the SQL 2005 Trial Edition, however, when using the RS Configuration Tool, the Web Services Identity won't allow me to enter anything, and when I try to connect to RS through the Management Studio, I get some warning saying that it recieved text/html when it was expecting text/xml or something like that, followed by a bunch of html.

The main difference I can see in these installations is that the one that won't work is on Win2000 Server. So, I guess the one question that springs to mind is: is there something inherently different about the IIS or ASP that I (or IT) needs to configure differently on this server? If not, any other assistance would be greatly appreciated.
ThanksThis is an issue with Windows 2000. Have a look at this thread. I hope the tips listed there will help.