Showing posts with label settings. Show all posts
Showing posts with label settings. Show all posts

Friday, March 30, 2012

Lose Security options in Report manager

I have installed RS on a machine and have deployed several reports. Now when
I go into Report Manager, there is no security settings on the properties tab
- This means I am not allowed to add/edit roles or any security functions at
all. Under the properties tab, i only see a general settings which lists
modified date, modified by, creation date, and created by information for the
report. The security functions used to be there - how do i get them back?
I used the RS.EXE tool to deploy my reports to the server - Could this have
caused my problem somehow? Any help would be appreciated!If you log on from the local machine as a local machine admin you should
always have permission to set security. It is hard to say why you lost your
security, perhaps somebody else came and removed them? Does you script
attempt to modify security?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"PCL" <PCL@.discussions.microsoft.com> wrote in message
news:BD224DBC-8998-45D9-A85A-4A73097C5D2C@.microsoft.com...
>I have installed RS on a machine and have deployed several reports. Now
>when
> I go into Report Manager, there is no security settings on the properties
> tab
> - This means I am not allowed to add/edit roles or any security functions
> at
> all. Under the properties tab, i only see a general settings which lists
> modified date, modified by, creation date, and created by information for
> the
> report. The security functions used to be there - how do i get them back?
> I used the RS.EXE tool to deploy my reports to the server - Could this
> have
> caused my problem somehow? Any help would be appreciated!|||Even when i loginto the local machine as Administrator, the security tabs are
missing. I dont think the RSS file does anything with security - It is a
modified version of the sample scripts that come with RS - we just used them
to deploy our reports.
"Daniel Reib [MSFT]" wrote:
> If you log on from the local machine as a local machine admin you should
> always have permission to set security. It is hard to say why you lost your
> security, perhaps somebody else came and removed them? Does you script
> attempt to modify security?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "PCL" <PCL@.discussions.microsoft.com> wrote in message
> news:BD224DBC-8998-45D9-A85A-4A73097C5D2C@.microsoft.com...
> >I have installed RS on a machine and have deployed several reports. Now
> >when
> > I go into Report Manager, there is no security settings on the properties
> > tab
> > - This means I am not allowed to add/edit roles or any security functions
> > at
> > all. Under the properties tab, i only see a general settings which lists
> > modified date, modified by, creation date, and created by information for
> > the
> > report. The security functions used to be there - how do i get them back?
> >
> > I used the RS.EXE tool to deploy my reports to the server - Could this
> > have
> > caused my problem somehow? Any help would be appreciated!
>
>|||Well if anyone is interested, I got all the security functionality back by
uninstalling and reinstalling reporting services. I tried rerunning my RSS
script and cannot get it to duplicate the problem i was having - Wierd, but i
guess it is fixed...
"PCL" wrote:
> I have installed RS on a machine and have deployed several reports. Now when
> I go into Report Manager, there is no security settings on the properties tab
> - This means I am not allowed to add/edit roles or any security functions at
> all. Under the properties tab, i only see a general settings which lists
> modified date, modified by, creation date, and created by information for the
> report. The security functions used to be there - how do i get them back?
> I used the RS.EXE tool to deploy my reports to the server - Could this have
> caused my problem somehow? Any help would be appreciated!|||Did you tweak the security on the IIS virtual server? If you use anonymous
authentication, you can't publish since it's not authenticating.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"PCL" <PCL@.discussions.microsoft.com> wrote in message
news:BD224DBC-8998-45D9-A85A-4A73097C5D2C@.microsoft.com...
>I have installed RS on a machine and have deployed several reports. Now
>when
> I go into Report Manager, there is no security settings on the properties
> tab
> - This means I am not allowed to add/edit roles or any security functions
> at
> all. Under the properties tab, i only see a general settings which lists
> modified date, modified by, creation date, and created by information for
> the
> report. The security functions used to be there - how do i get them back?
> I used the RS.EXE tool to deploy my reports to the server - Could this
> have
> caused my problem somehow? Any help would be appreciated!

Saturday, February 25, 2012

Looking for information

I'm looking for books or information on command line configuration of settings for things like activating Remote Connections under the Service Area Configuration and setting a port for that connection.

What books would be good to get or where can I download papers on this?

Any help would be appreciated.

I'd say the best place to start would be SQL Books Online, http://msdn2.microsoft.com, or you can download them from the Microsoft Download Center, http://www.microsoft.com/downloads.

You can run command line configuration through the SACUtility, check out the BOL topic at http://msdn2.microsoft.com/en-us/library/ms162800.aspx.

I don't have any personal recomendations for books you can read, but a quick search gave me Microsoft SQL Server 2005 Administrator's Pocket Consultant from MS Press (http://www.microsoft.com/MSPress/books/6794.asp). Probably a bunch of interesting things in there. It mentions having a section on Install, configure and tune SQL Server.

Hope this helps.

Mike Wachal
SQL Express team