Administrator access Lost

Hello,

I seem to have lost the ability to access the site settings as well as any security tabs and modify the properties under the directories etc...somehow i have lost administrator access , how do i get this back? I am still local administrator of the server reporting services is running on...only thing i can think off that could of done this is i installed Sharepoint onto the same machine and created a sharepoint site...are there things i can check in IIS or RS or etc to get this admin access back

thanks

A couple points come to mind. If you haven't already, run the Report Services Configuration application and try resetting (or creating new) the Report Server Virtual Directory. The configuration tool should remove any conflicts with SharePoint. In addition, in IIS make sure that anonymous access is disabled for the ReportServer virtual directory (on the Direcory Security tab of the ReportServer Properties dialog). It may be that, even though you are logged on as user, it is the IUSR_ account that is authenticating to the report server instead of the administrator.

This is assuming you're not yet attempting to integrate Reporting Services with SharePoint.

Administrator access Lost

Hello,

I seem to have lost the ability to access the site settings as well as any security tabs and modify the properties under the directories etc...somehow i have lost administrator access , how do i get this back? I am still local administrator of the server reporting services is running on...only thing i can think off that could of done this is i installed Sharepoint onto the same machine and created a sharepoint site...are there things i can check in IIS or RS or etc to get this admin access back

thanks

A couple points come to mind. If you haven't already, run the Report Services Configuration application and try resetting (or creating new) the Report Server Virtual Directory. The configuration tool should remove any conflicts with SharePoint. In addition, in IIS make sure that anonymous access is disabled for the ReportServer virtual directory (on the Direcory Security tab of the ReportServer Properties dialog). It may be that, even though you are logged on as user, it is the IUSR_ account that is authenticating to the report server instead of the administrator.

This is assuming you're not yet attempting to integrate Reporting Services with SharePoint.

administering jobs and targetserversrole

Hi all,
Hoping that someone else has tried to allow non sa people the ability to
administer jobs on a server. My situation is this:
My goal is to allow my developers to create and modify jobs on our
development server. To this end, I have put the developers (who are dbo in
their respective db), in an nt group and put them in the targetserversrole
in msdb on the server. In addition, by changing the role and granting
execute to the add,delete,and update job stored procedure groups and the job
start and stop stored procedures I am able to allow the group to add and
modify jobs, except for one item in the job and that is to set up job
notifications. I have tried granting the add,update and delete notification
group but that doesn't do it as the check boxes are still disabled for the
developers when they look at that part of the job. Does anyone know what I
am missing in this plan? Thanks in advance for any help solving this.
>
> Hi all,
> Hoping that someone else has tried to allow non sa people the ability to
> administer jobs on a server. My situation is this:
> My goal is to allow my developers to create and modify jobs on our
> development server. To this end, I have put the developers (who are dbo
in
> their respective db), in an nt group and put them in the targetserversrole
> in msdb on the server. In addition, by changing the role and granting
> execute to the add,delete,and update job stored procedure groups and the
job
> start and stop stored procedures I am able to allow the group to add and
> modify jobs, except for one item in the job and that is to set up job
> notifications. I have tried granting the add,update and delete
notification
> group but that doesn't do it as the check boxes are still disabled for the
> developers when they look at that part of the job. Does anyone know what
I
> am missing in this plan? Thanks in advance for any help solving this.
>
With SQL Server 2000, you need to be a sysadmin to be able to FULLY
ADMINISTER SQL Agent jobs.
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

administering jobs and targetserversrole

Hi all,
Hoping that someone else has tried to allow non sa people the ability to
administer jobs on a server. My situation is this:
My goal is to allow my developers to create and modify jobs on our
development server. To this end, I have put the developers (who are dbo in
their respective db), in an nt group and put them in the targetserversrole
in msdb on the server. In addition, by changing the role and granting
execute to the add,delete,and update job stored procedure groups and the job
start and stop stored procedures I am able to allow the group to add and
modify jobs, except for one item in the job and that is to set up job
notifications. I have tried granting the add,update and delete notification
group but that doesn't do it as the check boxes are still disabled for the
developers when they look at that part of the job. Does anyone know what I
am missing in this plan? Thanks in advance for any help solving this.>
> Hi all,
> Hoping that someone else has tried to allow non sa people the ability to
> administer jobs on a server. My situation is this:
> My goal is to allow my developers to create and modify jobs on our
> development server. To this end, I have put the developers (who are dbo
in
> their respective db), in an nt group and put them in the targetserversrole
> in msdb on the server. In addition, by changing the role and granting
> execute to the add,delete,and update job stored procedure groups and the
job
> start and stop stored procedures I am able to allow the group to add and
> modify jobs, except for one item in the job and that is to set up job
> notifications. I have tried granting the add,update and delete
notification
> group but that doesn't do it as the check boxes are still disabled for the
> developers when they look at that part of the job. Does anyone know what
I
> am missing in this plan? Thanks in advance for any help solving this.
>
--
With SQL Server 2000, you need to be a sysadmin to be able to FULLY
ADMINISTER SQL Agent jobs.
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

administering jobs and targetserversrole

Hi all,
Hoping that someone else has tried to allow non sa people the ability to
administer jobs on a server. My situation is this:
My goal is to allow my developers to create and modify jobs on our
development server. To this end, I have put the developers (who are dbo in
their respective db), in an nt group and put them in the targetserversrole
in msdb on the server. In addition, by changing the role and granting
execute to the add,delete,and update job stored procedure groups and the job
start and stop stored procedures I am able to allow the group to add and
modify jobs, except for one item in the job and that is to set up job
notifications. I have tried granting the add,update and delete notification
group but that doesn't do it as the check boxes are still disabled for the
developers when they look at that part of the job. Does anyone know what I
am missing in this plan? Thanks in advance for any help solving this.>
> Hi all,
> Hoping that someone else has tried to allow non sa people the ability to
> administer jobs on a server. My situation is this:
> My goal is to allow my developers to create and modify jobs on our
> development server. To this end, I have put the developers (who are dbo
in
> their respective db), in an nt group and put them in the targetserversrole
> in msdb on the server. In addition, by changing the role and granting
> execute to the add,delete,and update job stored procedure groups and the
job
> start and stop stored procedures I am able to allow the group to add and
> modify jobs, except for one item in the job and that is to set up job
> notifications. I have tried granting the add,update and delete
notification
> group but that doesn't do it as the check boxes are still disabled for the
> developers when they look at that part of the job. Does anyone know what
I
> am missing in this plan? Thanks in advance for any help solving this.
>
--
With SQL Server 2000, you need to be a sysadmin to be able to FULLY
ADMINISTER SQL Agent jobs.
Hope this helps,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.