RS and HTTPS: rsaccessdenied

Showing posts with label rsaccessdenied. Show all posts

Monday, March 26, 2012

rsAcessDenied when running the report

I got this error "

The permissions granted to user 'DomainName\UserName' are insufficient for performing this operation. (rsAccessDenied) " when I run the report. Somebody help me.

Manao

Check out the security permissions the folder where the report reisdes in and ensure that the userid or the group the user belongs to has at least browser access.

HTH

rsAccessDenied with Forms Authentication

I have implemented custom forms authentication with Reporting Services and
everything worked fine. I was able able to deploy reports from Visual
Studio 2003, VS would prompt me to enter a valid UserID and Password.
Recently, I have changed workstations and installed a new copy of visual
studio 2003. When I try to deploy a report to the same report server, I get
the following error:
The permissions granted to user '' are insufficient for performing this
operation.
VS does not prompt me to enter a userID and password and simply fails to
authenticate. I am still able to login direcly to report manager and
report server directly without any problems.
I am running:
** Workstation
OS: Windows XP Pro
Visual Studio 2003
** Server:
Windows 2000 Server SP 4
Reporting Services with Service Pack 1
Could someone please give some hints on what went wrong?
Thanks,
- Adil -Was the original install of Visual Studio on the same box as the server?
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
news:eGmMtNKeEHA.3744@.TK2MSFTNGP12.phx.gbl...
> I have implemented custom forms authentication with Reporting Services and
> everything worked fine. I was able able to deploy reports from Visual
> Studio 2003, VS would prompt me to enter a valid UserID and Password.
> Recently, I have changed workstations and installed a new copy of visual
> studio 2003. When I try to deploy a report to the same report server, I
get
> the following error:
> The permissions granted to user '' are insufficient for performing this
> operation.
> VS does not prompt me to enter a userID and password and simply fails to
> authenticate. I am still able to login direcly to report manager and
> report server directly without any problems.
> I am running:
> ** Workstation
> OS: Windows XP Pro
> Visual Studio 2003
> ** Server:
> Windows 2000 Server SP 4
> Reporting Services with Service Pack 1
> Could someone please give some hints on what went wrong?
> Thanks,
> - Adil -
>
>|||Bryan,
No, the original installation of Visual studio was not on the Server. It was
on a Windows 2000 Workstation.
- Adil -
"Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
news:%23Njq%23WjeEHA.1652@.TK2MSFTNGP10.phx.gbl...
> Was the original install of Visual Studio on the same box as the server?
> --
> Bryan Keller
> Developer Documentation
> SQL Server Reporting Services
> A friendly reminder that this posting is provided "AS IS" with no
> warranties, and confers no rights.
>
> "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> news:eGmMtNKeEHA.3744@.TK2MSFTNGP12.phx.gbl...
> > I have implemented custom forms authentication with Reporting Services
and
> > everything worked fine. I was able able to deploy reports from Visual
> > Studio 2003, VS would prompt me to enter a valid UserID and Password.
> > Recently, I have changed workstations and installed a new copy of visual
> > studio 2003. When I try to deploy a report to the same report server, I
> get
> > the following error:
> >
> > The permissions granted to user '' are insufficient for performing this
> > operation.
> >
> > VS does not prompt me to enter a userID and password and simply fails to
> > authenticate. I am still able to login direcly to report manager and
> > report server directly without any problems.
> >
> > I am running:
> > ** Workstation
> > OS: Windows XP Pro
> > Visual Studio 2003
> >
> > ** Server:
> > Windows 2000 Server SP 4
> > Reporting Services with Service Pack 1
> >
> > Could someone please give some hints on what went wrong?
> >
> > Thanks,
> > - Adil -
> >
> >
> >
>|||Okay, VS should prompt for credentials when using Forms auth. You obviously
reinstalled the Designer on the new VS box correct? Are you using a report
project from the old install? If so, try deleting the .user and .suo files
for your project and deploying again.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
news:ew3XA%23yeEHA.1100@.TK2MSFTNGP10.phx.gbl...
> Bryan,
> No, the original installation of Visual studio was not on the Server. It
was
> on a Windows 2000 Workstation.
> - Adil -
> "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
> news:%23Njq%23WjeEHA.1652@.TK2MSFTNGP10.phx.gbl...
> > Was the original install of Visual Studio on the same box as the server?
> >
> > --
> > Bryan Keller
> > Developer Documentation
> > SQL Server Reporting Services
> >
> > A friendly reminder that this posting is provided "AS IS" with no
> > warranties, and confers no rights.
> >
> >
> > "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> > news:eGmMtNKeEHA.3744@.TK2MSFTNGP12.phx.gbl...
> > > I have implemented custom forms authentication with Reporting Services
> and
> > > everything worked fine. I was able able to deploy reports from Visual
> > > Studio 2003, VS would prompt me to enter a valid UserID and Password.
> > > Recently, I have changed workstations and installed a new copy of
visual
> > > studio 2003. When I try to deploy a report to the same report server,
I
> > get
> > > the following error:
> > >
> > > The permissions granted to user '' are insufficient for performing
this
> > > operation.
> > >
> > > VS does not prompt me to enter a userID and password and simply fails
to
> > > authenticate. I am still able to login direcly to report manager and
> > > report server directly without any problems.
> > >
> > > I am running:
> > > ** Workstation
> > > OS: Windows XP Pro
> > > Visual Studio 2003
> > >
> > > ** Server:
> > > Windows 2000 Server SP 4
> > > Reporting Services with Service Pack 1
> > >
> > > Could someone please give some hints on what went wrong?
> > >
> > > Thanks,
> > > - Adil -
> > >
> > >
> > >
> >
> >
>|||Bryan,
Thanks for the help. I found the bug and it was in my code! (<-- Very rare!
:))
Apparently, it seems that when you try to deploy from VS for the first time,
VS sends a blank UserID and Password to ReportServer. This call normally
fails and the Login dialog box is therefore displayed.
In my case, the LogonUser method returned a boolean true for a blank
UserName and Password (<-- Bug in security extension), so VS moved on to the
Authorization phase which failed because no permissions have been assigned
to the blank user. Hence the error message:
"The permissions granted to user '' are insufficient for performing
this operation."
The problem disapeared as soon as I set the LogonUser method of the security
extension to return a "false" when the userName is blank.
- Adil -
"Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
news:OHlkL08eEHA.3028@.TK2MSFTNGP12.phx.gbl...
> Okay, VS should prompt for credentials when using Forms auth. You
obviously
> reinstalled the Designer on the new VS box correct? Are you using a report
> project from the old install? If so, try deleting the .user and .suo files
> for your project and deploying again.
> --
> Bryan Keller
> Developer Documentation
> SQL Server Reporting Services
> A friendly reminder that this posting is provided "AS IS" with no
> warranties, and confers no rights.
>
> "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> news:ew3XA%23yeEHA.1100@.TK2MSFTNGP10.phx.gbl...
> > Bryan,
> >
> > No, the original installation of Visual studio was not on the Server. It
> was
> > on a Windows 2000 Workstation.
> >
> > - Adil -
> >
> > "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
> > news:%23Njq%23WjeEHA.1652@.TK2MSFTNGP10.phx.gbl...
> > > Was the original install of Visual Studio on the same box as the
server?
> > >
> > > --
> > > Bryan Keller
> > > Developer Documentation
> > > SQL Server Reporting Services
> > >
> > > A friendly reminder that this posting is provided "AS IS" with no
> > > warranties, and confers no rights.
> > >
> > >
> > > "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> > > news:eGmMtNKeEHA.3744@.TK2MSFTNGP12.phx.gbl...
> > > > I have implemented custom forms authentication with Reporting
Services
> > and
> > > > everything worked fine. I was able able to deploy reports from
Visual
> > > > Studio 2003, VS would prompt me to enter a valid UserID and
Password.
> > > > Recently, I have changed workstations and installed a new copy of
> visual
> > > > studio 2003. When I try to deploy a report to the same report
server,
> I
> > > get
> > > > the following error:
> > > >
> > > > The permissions granted to user '' are insufficient for performing
> this
> > > > operation.
> > > >
> > > > VS does not prompt me to enter a userID and password and simply
fails
> to
> > > > authenticate. I am still able to login direcly to report manager
and
> > > > report server directly without any problems.
> > > >
> > > > I am running:
> > > > ** Workstation
> > > > OS: Windows XP Pro
> > > > Visual Studio 2003
> > > >
> > > > ** Server:
> > > > Windows 2000 Server SP 4
> > > > Reporting Services with Service Pack 1
> > > >
> > > > Could someone please give some hints on what went wrong?
> > > >
> > > > Thanks,
> > > > - Adil -
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Great news. I'm glad you tracked that down.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
news:ulz671ZfEHA.1048@.tk2msftngp13.phx.gbl...
> Bryan,
> Thanks for the help. I found the bug and it was in my code! (<-- Very
rare!
> :))
> Apparently, it seems that when you try to deploy from VS for the first
time,
> VS sends a blank UserID and Password to ReportServer. This call normally
> fails and the Login dialog box is therefore displayed.
> In my case, the LogonUser method returned a boolean true for a blank
> UserName and Password (<-- Bug in security extension), so VS moved on to
the
> Authorization phase which failed because no permissions have been assigned
> to the blank user. Hence the error message:
> "The permissions granted to user '' are insufficient for
performing
> this operation."
> The problem disapeared as soon as I set the LogonUser method of the
security
> extension to return a "false" when the userName is blank.
> - Adil -
> "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
> news:OHlkL08eEHA.3028@.TK2MSFTNGP12.phx.gbl...
> > Okay, VS should prompt for credentials when using Forms auth. You
> obviously
> > reinstalled the Designer on the new VS box correct? Are you using a
report
> > project from the old install? If so, try deleting the .user and .suo
files
> > for your project and deploying again.
> > --
> > Bryan Keller
> > Developer Documentation
> > SQL Server Reporting Services
> >
> > A friendly reminder that this posting is provided "AS IS" with no
> > warranties, and confers no rights.
> >
> >
> > "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> > news:ew3XA%23yeEHA.1100@.TK2MSFTNGP10.phx.gbl...
> > > Bryan,
> > >
> > > No, the original installation of Visual studio was not on the Server.
It
> > was
> > > on a Windows 2000 Workstation.
> > >
> > > - Adil -
> > >
> > > "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
> > > news:%23Njq%23WjeEHA.1652@.TK2MSFTNGP10.phx.gbl...
> > > > Was the original install of Visual Studio on the same box as the
> server?
> > > >
> > > > --
> > > > Bryan Keller
> > > > Developer Documentation
> > > > SQL Server Reporting Services
> > > >
> > > > A friendly reminder that this posting is provided "AS IS" with no
> > > > warranties, and confers no rights.
> > > >
> > > >
> > > > "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> > > > news:eGmMtNKeEHA.3744@.TK2MSFTNGP12.phx.gbl...
> > > > > I have implemented custom forms authentication with Reporting
> Services
> > > and
> > > > > everything worked fine. I was able able to deploy reports from
> Visual
> > > > > Studio 2003, VS would prompt me to enter a valid UserID and
> Password.
> > > > > Recently, I have changed workstations and installed a new copy of
> > visual
> > > > > studio 2003. When I try to deploy a report to the same report
> server,
> > I
> > > > get
> > > > > the following error:
> > > > >
> > > > > The permissions granted to user '' are insufficient for
performing
> > this
> > > > > operation.
> > > > >
> > > > > VS does not prompt me to enter a userID and password and simply
> fails
> > to
> > > > > authenticate. I am still able to login direcly to report manager
> and
> > > > > report server directly without any problems.
> > > > >
> > > > > I am running:
> > > > > ** Workstation
> > > > > OS: Windows XP Pro
> > > > > Visual Studio 2003
> > > > >
> > > > > ** Server:
> > > > > Windows 2000 Server SP 4
> > > > > Reporting Services with Service Pack 1
> > > > >
> > > > > Could someone please give some hints on what went wrong?
> > > > >
> > > > > Thanks,
> > > > > - Adil -
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||I too am having this exact problem. I'm trying to publish my reports using
the batch rs method. Where do I set my logon credentials there, I never see
a pop-up.
Thanks,
Gabe
"Bryan Keller [MSFT]" wrote:
> Great news. I'm glad you tracked that down.
> --
> Bryan Keller
> Developer Documentation
> SQL Server Reporting Services
> A friendly reminder that this posting is provided "AS IS" with no
> warranties, and confers no rights.
>
> "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> news:ulz671ZfEHA.1048@.tk2msftngp13.phx.gbl...
> > Bryan,
> > Thanks for the help. I found the bug and it was in my code! (<-- Very
> rare!
> > :))
> > Apparently, it seems that when you try to deploy from VS for the first
> time,
> > VS sends a blank UserID and Password to ReportServer. This call normally
> > fails and the Login dialog box is therefore displayed.
> > In my case, the LogonUser method returned a boolean true for a blank
> > UserName and Password (<-- Bug in security extension), so VS moved on to
> the
> > Authorization phase which failed because no permissions have been assigned
> > to the blank user. Hence the error message:
> > "The permissions granted to user '' are insufficient for
> performing
> > this operation."
> >
> > The problem disapeared as soon as I set the LogonUser method of the
> security
> > extension to return a "false" when the userName is blank.
> >
> > - Adil -
> >
> > "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
> > news:OHlkL08eEHA.3028@.TK2MSFTNGP12.phx.gbl...
> > > Okay, VS should prompt for credentials when using Forms auth. You
> > obviously
> > > reinstalled the Designer on the new VS box correct? Are you using a
> report
> > > project from the old install? If so, try deleting the .user and .suo
> files
> > > for your project and deploying again.
> > > --
> > > Bryan Keller
> > > Developer Documentation
> > > SQL Server Reporting Services
> > >
> > > A friendly reminder that this posting is provided "AS IS" with no
> > > warranties, and confers no rights.
> > >
> > >
> > > "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> > > news:ew3XA%23yeEHA.1100@.TK2MSFTNGP10.phx.gbl...
> > > > Bryan,
> > > >
> > > > No, the original installation of Visual studio was not on the Server.
> It
> > > was
> > > > on a Windows 2000 Workstation.
> > > >
> > > > - Adil -
> > > >
> > > > "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
> > > > news:%23Njq%23WjeEHA.1652@.TK2MSFTNGP10.phx.gbl...
> > > > > Was the original install of Visual Studio on the same box as the
> > server?
> > > > >
> > > > > --
> > > > > Bryan Keller
> > > > > Developer Documentation
> > > > > SQL Server Reporting Services
> > > > >
> > > > > A friendly reminder that this posting is provided "AS IS" with no
> > > > > warranties, and confers no rights.
> > > > >
> > > > >
> > > > > "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> > > > > news:eGmMtNKeEHA.3744@.TK2MSFTNGP12.phx.gbl...
> > > > > > I have implemented custom forms authentication with Reporting
> > Services
> > > > and
> > > > > > everything worked fine. I was able able to deploy reports from
> > Visual
> > > > > > Studio 2003, VS would prompt me to enter a valid UserID and
> > Password.
> > > > > > Recently, I have changed workstations and installed a new copy of
> > > visual
> > > > > > studio 2003. When I try to deploy a report to the same report
> > server,
> > > I
> > > > > get
> > > > > > the following error:
> > > > > >
> > > > > > The permissions granted to user '' are insufficient for
> performing
> > > this
> > > > > > operation.
> > > > > >
> > > > > > VS does not prompt me to enter a userID and password and simply
> > fails
> > > to
> > > > > > authenticate. I am still able to login direcly to report manager
> > and
> > > > > > report server directly without any problems.
> > > > > >
> > > > > > I am running:
> > > > > > ** Workstation
> > > > > > OS: Windows XP Pro
> > > > > > Visual Studio 2003
> > > > > >
> > > > > > ** Server:
> > > > > > Windows 2000 Server SP 4
> > > > > > Reporting Services with Service Pack 1
> > > > > >
> > > > > > Could someone please give some hints on what went wrong?
> > > > > >
> > > > > > Thanks,
> > > > > > - Adil -
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

rsAccessDenied when accessing Report Server

I have SQLServer 2005 with reporting services running on win 2003 server.
I'm trying to configure SSRS with Anonymous access configured on
ReportServer Web Site and verified NTFS security on ReportServer folder
include Iusr and Iwam with read/execute permmisions
Does ReportServer stand on its own or does the ReportManager Web Site also
need Anonymous access?
Are there any config files that need to be updated?
What am I missing?
IE Message when accessing http://<Server>/ReportServer
The permissions granted to user 'VWIN2003SERVER\IUSR_VWIN2003SERVER' are
insufficient for performing this operation. (rsAccessDenied)
ReportServer Log File
w3wp!library!1!02/15/2006-11:54:17:: i INFO: Catalog SQL Server Edition = Developer
w3wp!library!1!02/15/2006-11:54:17:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The
permissions granted to user 'VWIN2003SERVER\IUSR_VWIN2003SERVER' are
insufficient for performing this operation., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The
permissions granted to user 'VWIN2003SERVER\IUSR_VWIN2003SERVER' are
insufficient for performing this operation.
ReportServerService_Main Log File
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
WindowsServiceUseFileShareStorage to 'False' as specified in Configuration
file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
DailyCleanupMinuteOfDay to default value of '120' minutes since midnight
because it was not specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
WatsonDumpOnExceptions to
'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
WatsonDumpExcludeIfContainsExceptions to
'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
WebServiceUseFileShareStorage to 'False' as specified in Configuration
file.
ReportingServicesService!servicecontroller!9!2/15/2006-08:54:31:: Total
Physical memory: 685219840
ReportingServicesService!servicecontroller!4!2/15/2006-08:54:31:: i INFO:
RPC Server started. Endpoint name ='ReportingServices$MSSQL.3'
ReportingServicesService!library!d!2/15/2006-08:57:45:: i INFO: Catalog SQL
Server Edition = Developer
ReportingServicesService!resourceutilities!d!2/15/2006-08:57:45:: i INFO:
Reporting Services starting SKU: Developer
ReportingServicesService!resourceutilities!d!2/15/2006-08:57:45:: i INFO:
Evaluation copy: 0 days left
ReportingServicesService!library!e!2/15/2006-08:57:45:: i INFO: Catalog SQL
Server Edition = Developer
ReportingServicesService!library!f!2/15/2006-08:57:45:: i INFO: Catalog SQL
Server Edition = Developer
ReportingServicesService!crypto!d!2/15/2006-08:57:45:: i INFO: Initializing
crypto as user: NT AUTHORITY\SYSTEM
ReportingServicesService!crypto!d!2/15/2006-08:57:46:: i INFO: Exporting
public key
ReportingServicesService!crypto!d!2/15/2006-08:57:46:: i INFO: Performing
sku validation
ReportingServicesService!crypto!d!2/15/2006-08:57:46:: i INFO: Importing
existing encryption key
Thanks
Marc BumgarnerNo a good idea (anonymous access). As soon as you do this you will find out
that you have lost all admin rights even when you are an administrator on
the box. Why? Because it is anonymous, RS does not know who you are.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Marc Bumgarner" <mbumgarner@.ecomponentstech.com> wrote in message
news:8P6dnaUqm6P1Gm7enZ2dnUVZ_sidnZ2d@.mt.net...
>I have SQLServer 2005 with reporting services running on win 2003 server.
> I'm trying to configure SSRS with Anonymous access configured on
> ReportServer Web Site and verified NTFS security on ReportServer folder
> include Iusr and Iwam with read/execute permmisions
> Does ReportServer stand on its own or does the ReportManager Web Site also
> need Anonymous access?
> Are there any config files that need to be updated?
> What am I missing?
>
> IE Message when accessing http://<Server>/ReportServer
> The permissions granted to user 'VWIN2003SERVER\IUSR_VWIN2003SERVER' are
> insufficient for performing this operation. (rsAccessDenied)
>
> ReportServer Log File
> w3wp!library!1!02/15/2006-11:54:17:: i INFO: Catalog SQL Server Edition => Developer
> w3wp!library!1!02/15/2006-11:54:17:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException:
> The permissions granted to user 'VWIN2003SERVER\IUSR_VWIN2003SERVER' are
> insufficient for performing this operation., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException:
> The permissions granted to user 'VWIN2003SERVER\IUSR_VWIN2003SERVER' are
> insufficient for performing this operation.
>
> ReportServerService_Main Log File
>
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing ConnectionType to '0' as specified in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing IsSchedulingService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing IsNotificationService to 'True' as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing IsEventService to 'True' as specified in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing PollingInterval to '10' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing WindowsServiceUseFileShareStorage to 'False' as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing MemoryLimit to '60' percent as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing RecycleTime to '720' minute(s) as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing MaximumMemoryLimit to '80' percent as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing MaxQueueThreads to '0' thread(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing IsWebServiceEnabled to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing MaxScheduleWait to '5' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing ProcessRecycleOptions to '0' as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing RunningRequestsScavengerCycle to '60' second(s) as specified
> in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing RunningRequestsAge to '30' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing DailyCleanupMinuteOfDay to default value of '120' minutes
> since midnight because it was not specified in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing WatsonFlags to '1064' as specified in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing WatsonDumpOnExceptions to
> 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
> as specified in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing WatsonDumpExcludeIfContainsExceptions to
> 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
> as specified in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing SecureConnectionLevel to '0' as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing DisplayErrorLink to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing WebServiceUseFileShareStorage to 'False' as specified in
> Configuration file.
> ReportingServicesService!servicecontroller!9!2/15/2006-08:54:31:: Total
> Physical memory: 685219840
> ReportingServicesService!servicecontroller!4!2/15/2006-08:54:31:: i INFO:
> RPC Server started. Endpoint name ='ReportingServices$MSSQL.3'
> ReportingServicesService!library!d!2/15/2006-08:57:45:: i INFO: Catalog
> SQL Server Edition = Developer
> ReportingServicesService!resourceutilities!d!2/15/2006-08:57:45:: i INFO:
> Reporting Services starting SKU: Developer
> ReportingServicesService!resourceutilities!d!2/15/2006-08:57:45:: i INFO:
> Evaluation copy: 0 days left
> ReportingServicesService!library!e!2/15/2006-08:57:45:: i INFO: Catalog
> SQL Server Edition = Developer
> ReportingServicesService!library!f!2/15/2006-08:57:45:: i INFO: Catalog
> SQL Server Edition = Developer
> ReportingServicesService!crypto!d!2/15/2006-08:57:45:: i INFO:
> Initializing crypto as user: NT AUTHORITY\SYSTEM
> ReportingServicesService!crypto!d!2/15/2006-08:57:46:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!d!2/15/2006-08:57:46:: i INFO: Performing
> sku validation
> ReportingServicesService!crypto!d!2/15/2006-08:57:46:: i INFO: Importing
> existing encryption key
>
> Thanks
> Marc Bumgarner
>

rsAccessDenied for every non local admin

Hi,
I'm having this strange problem while configuring RS on a Windows 2003
server. The SQL server DB exists on another machine. Whenever I visit the
report manager with the credentials used to install RS (this is also a local
admin account), everything is OK. When I use other credentials, the report
manager only shows the header "SQL Server Reporting Services". There is no
list of folders/reports available (the local admin can see this list), even
though i added the username as a RS system administrator. I think the role
assignment worked fine, because I can add users and grant permissions and
roles to other users with this account. What's even more weird is when i go
to /ReportServer/ I get the message "rsAccessDenied for user ...".
The IUSR account and the current account have permissions on the
\ReportServer folder and the \Reports folder.
Is there something else I missed? I'm testing this now because I need to
deploy some reports using RS in a production environment next week...
Help is much apreciated!
--
AndreasYes, as the local admin, go to the properties tab on the home page of
ReportManager. Here there is a security tab. Generally you want to give
everyone the browser role at this level. You can of course make this more
granular as you see fit.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andreas" <Andreas@.discussions.microsoft.com> wrote in message
news:95C818F5-9E5E-4CAE-8691-47B9724384C6@.microsoft.com...
> Hi,
> I'm having this strange problem while configuring RS on a Windows 2003
> server. The SQL server DB exists on another machine. Whenever I visit the
> report manager with the credentials used to install RS (this is also a
local
> admin account), everything is OK. When I use other credentials, the report
> manager only shows the header "SQL Server Reporting Services". There is no
> list of folders/reports available (the local admin can see this list),
even
> though i added the username as a RS system administrator. I think the role
> assignment worked fine, because I can add users and grant permissions and
> roles to other users with this account. What's even more weird is when i
go
> to /ReportServer/ I get the message "rsAccessDenied for user ...".
> The IUSR account and the current account have permissions on the
> \ReportServer folder and the \Reports folder.
> Is there something else I missed? I'm testing this now because I need to
> deploy some reports using RS in a production environment next week...
> Help is much apreciated!
> --
> Andreas|||I'll try that
thx
"Daniel Reib [MSFT]" wrote:
> Yes, as the local admin, go to the properties tab on the home page of
> ReportManager. Here there is a security tab. Generally you want to give
> everyone the browser role at this level. You can of course make this more
> granular as you see fit.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Andreas" <Andreas@.discussions.microsoft.com> wrote in message
> news:95C818F5-9E5E-4CAE-8691-47B9724384C6@.microsoft.com...
> > Hi,
> >
> > I'm having this strange problem while configuring RS on a Windows 2003
> > server. The SQL server DB exists on another machine. Whenever I visit the
> > report manager with the credentials used to install RS (this is also a
> local
> > admin account), everything is OK. When I use other credentials, the report
> > manager only shows the header "SQL Server Reporting Services". There is no
> > list of folders/reports available (the local admin can see this list),
> even
> > though i added the username as a RS system administrator. I think the role
> > assignment worked fine, because I can add users and grant permissions and
> > roles to other users with this account. What's even more weird is when i
> go
> > to /ReportServer/ I get the message "rsAccessDenied for user ...".
> > The IUSR account and the current account have permissions on the
> > \ReportServer folder and the \Reports folder.
> >
> > Is there something else I missed? I'm testing this now because I need to
> > deploy some reports using RS in a production environment next week...
> >
> > Help is much apreciated!
> >
> > --
> > Andreas
>
>

rsAccessDenied for authorised user.

Hi, as many people in this group, I have the problem that some users
cannot access the report we designed. They receive the message:
The permissions granted to user '{domain}\{userID}' are insufficient
for performing
this operation. (rsAccessDenied)
The strange thing here is that I granted access to a group (Domain
Users) which holds all the users of this domain. I tested with 3 users
who all could access the report. Of course I thought that if these
users could access the report, other users should be able to access the
report too. But, when I tested with a fourth user I got the error as
stated above. I checked the rights for the group on the folders and
reports, but they are ok. So what am I misssing here?
I also tried to sign individual rights to the userId, but no luck
either. Then I tried to use an other userId too (fith userid for the
test) , same result, no access. So in my group "Domain Users" , which
holds all the users of the domain. Three users can access the report
and so far two can not. I didn't test with other accounts except for
these 5, that should be enough, don't you think?
We do not use "Anonymous Access" anywhere.
The server is Standard 2003
MS SQL 2000
Reporting Services 2000
Any help would be appriciatedOk, found out what the problem was. I didn't set the right permissions
on the top-level. So, first I had to set de security permissions in RS
on te "root"-folder, then on the subfolders and so on to the reports.
This solved my problemsql

rsAccessDenied even for the Content Manager role

I have the Content Manager rights on a folder and on a report for my user.
When I try to edit ther report properties I got the error
the permissions granted to user `domain\user` are insufficient for
performing this operation (rsAccessDenied)
I am able to upload, create folders, create data source, upload file, but
not to view the report properties
--
AlexSounds like someone changed the Security for that Particular report, so you
can't mess with it...
All of the things you can do, have perms at the folder level...Report
properties can be set at the report level, so if someone removed
ContentManager Role from the specific report, you'd get the behaviour you are
seeing..
Hope this helps.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
See you at the PASS Conference!
"Alex" wrote:
> I have the Content Manager rights on a folder and on a report for my user.
> When I try to edit ther report properties I got the error
> the permissions granted to user `domain\user` are insufficient for
> performing this operation (rsAccessDenied)
> I am able to upload, create folders, create data source, upload file, but
> not to view the report properties
> --
> Alex|||I just verified it and It has the Content Manager perms
I even created a new folder with the builtin\Administrators Content
Manager and the Server\user Content Manager too.
I checked the report's security tab, and in all the reports in that folder I
have both, the Builtin\Administrators Content Manager and the Server\user
Content Manager permissions.
But Still having the rsAccessDenied Error
I would appreciate very much any help about it
Thanks
--
Alex
"Wayne Snyder" wrote:
> Sounds like someone changed the Security for that Particular report, so you
> can't mess with it...
> All of the things you can do, have perms at the folder level...Report
> properties can be set at the report level, so if someone removed
> ContentManager Role from the specific report, you'd get the behaviour you are
> seeing..
> Hope this helps.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
> See you at the PASS Conference!
>
> "Alex" wrote:
> > I have the Content Manager rights on a folder and on a report for my user.
> >
> > When I try to edit ther report properties I got the error
> > the permissions granted to user `domain\user` are insufficient for
> > performing this operation (rsAccessDenied)
> >
> > I am able to upload, create folders, create data source, upload file, but
> > not to view the report properties
> >
> > --
> > Alex|||I had the same problem you described and fixed it by granting the NT group
the 'Content Manager' permissions at the 'Root' of the Report Server site.
After doing this the permissions were applied correctly to the Folders
underneath this.
Hope this helps.
Diran
"Alex" wrote:
> I just verified it and It has the Content Manager perms
> I even created a new folder with the builtin\Administrators Content
> Manager and the Server\user Content Manager too.
> I checked the report's security tab, and in all the reports in that folder I
> have both, the Builtin\Administrators Content Manager and the Server\user
> Content Manager permissions.
> But Still having the rsAccessDenied Error
> I would appreciate very much any help about it
> Thanks
> --
> Alex
>
> "Wayne Snyder" wrote:
> > Sounds like someone changed the Security for that Particular report, so you
> > can't mess with it...
> >
> > All of the things you can do, have perms at the folder level...Report
> > properties can be set at the report level, so if someone removed
> > ContentManager Role from the specific report, you'd get the behaviour you are
> > seeing..
> >
> > Hope this helps.
> > --
> > Wayne Snyder MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> >
> > I support the Professional Association for SQL Server ( PASS) and it''s
> > community of SQL Professionals.
> > See you at the PASS Conference!
> >
> >
> > "Alex" wrote:
> >
> > > I have the Content Manager rights on a folder and on a report for my user.
> > >
> > > When I try to edit ther report properties I got the error
> > > the permissions granted to user `domain\user` are insufficient for
> > > performing this operation (rsAccessDenied)
> > >
> > > I am able to upload, create folders, create data source, upload file, but
> > > not to view the report properties
> > >
> > > --
> > > Alex|||Thanks Diran,
It worked, I just granted the "My Reports" permissions.
Thanks again!
--
Alex
"Diran" wrote:
> I had the same problem you described and fixed it by granting the NT group
> the 'Content Manager' permissions at the 'Root' of the Report Server site.
> After doing this the permissions were applied correctly to the Folders
> underneath this.
> Hope this helps.
> Diran
>
> "Alex" wrote:
> > I just verified it and It has the Content Manager perms
> >
> > I even created a new folder with the builtin\Administrators Content
> > Manager and the Server\user Content Manager too.
> >
> > I checked the report's security tab, and in all the reports in that folder I
> > have both, the Builtin\Administrators Content Manager and the Server\user
> > Content Manager permissions.
> >
> > But Still having the rsAccessDenied Error
> >
> > I would appreciate very much any help about it
> > Thanks
> >
> > --
> > Alex
> >
> >
> > "Wayne Snyder" wrote:
> >
> > > Sounds like someone changed the Security for that Particular report, so you
> > > can't mess with it...
> > >
> > > All of the things you can do, have perms at the folder level...Report
> > > properties can be set at the report level, so if someone removed
> > > ContentManager Role from the specific report, you'd get the behaviour you are
> > > seeing..
> > >
> > > Hope this helps.
> > > --
> > > Wayne Snyder MCDBA, SQL Server MVP
> > > Mariner, Charlotte, NC
> > >
> > > I support the Professional Association for SQL Server ( PASS) and it''s
> > > community of SQL Professionals.
> > > See you at the PASS Conference!
> > >
> > >
> > > "Alex" wrote:
> > >
> > > > I have the Content Manager rights on a folder and on a report for my user.
> > > >
> > > > When I try to edit ther report properties I got the error
> > > > the permissions granted to user `domain\user` are insufficient for
> > > > performing this operation (rsAccessDenied)
> > > >
> > > > I am able to upload, create folders, create data source, upload file, but
> > > > not to view the report properties
> > > >
> > > > --
> > > > Alex

rsAccessDenied and

I have installed Reporting Services on a production server that host a
website using SQL Express. I have set up RS in the RS configuration manager
and got green button all the way down
Requesting http://www.xx.dk/reports replies:
The request failed with HTTP status 400: Bad Request.
Requesting http://www.xx.dk/reportserver replies:
The permissions granted to user 'TF4\ms' are insufficient for performing
this operation. (rsAccessDenied)
Any idea what the problem might be ?
--
Paul SHello Paul,
Based on my research, please check the following settings:
1. Make sure you disable the Anynomous Access on IIS for the reporting
services virtual directory.
2. Make sure you enable Windows Authentication on IIS
3. Make sure you have use the rsconfig utility to connect to the correct
SQL Instance for the report server.
4. Make sure you are using a correct identity for the application pool the
reporting services using. Please try to use a domain account with local
admin privilage to have a check.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||1)
Anynomous Access is disabled for the reportServer dir. and the reports dir.
but not for the parent dir - the original dir for the website.
2)
Windows Authentication is enabled for the reports and the reportserver dir.
3)
I only have one - it's correct
4)
The application pool for both the ReportServer and the Report manager is
DefaultAppPool
ps. In database setup the credentials type is Service credentials
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hello Paul,
> Based on my research, please check the following settings:
> 1. Make sure you disable the Anynomous Access on IIS for the reporting
> services virtual directory.
> 2. Make sure you enable Windows Authentication on IIS
> 3. Make sure you have use the rsconfig utility to connect to the correct
> SQL Instance for the report server.
> 4. Make sure you are using a correct identity for the application pool the
> reporting services using. Please try to use a domain account with local
> admin privilage to have a check.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Hello Paul,
1. Please run the rsconfig utility to specify a new connection to the sql
server:
rsconfig -c -s <SQLSERVERNAME> -d reportserver -a SQL -u SA -p <SAPASSWORD>
2. Please recreate an application pool for the report server and use a
domain account which have local admin privilage as the identity to have a
try.
Please let me know the result.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Wei Lu
Your suggestions gave the follwing:
1)
No Reporting Services instance found on localhost.
2)
I created a new user with local admin rights and used him when I created a
new app pool for the reports server - the report manager still uses
DefaultAppPool.
Why is it talking about localhost - I'm not using localhost. The values
specifid in the RS Configuration manager for Report Server Virtual Directory
is:
Name: ReportServer, Website xxx
accessing http://www.xxx.dk/reports gives
The request failed with HTTP status 400: Bad Request.
acessing http://www.xxx.dk/reportserver still gives The permissions granted
to user 'TF4\ms' are insufficient for performing this operation.
(rsAccessDenied)|||Hello Paul,
I would like to get the RSWebApplication.config file and
rsreportserver.config file in the report manager and report server folder.
By default, these two folders is located at :C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\
Also, please send me the screenshot for the Configuration Tool. Make sure
you have a default instance installed in the server.
You may zip the folder and send to me directly. I understand the
information may be sensitive to you. To get my real email addresss, please
remove the ONLINE in my display mail.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I've send you the information needed
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Paul,
From your rsreportserver.config file, I did not see the LogonUser
credential is applied. So please use the rsconfig utility to specify the
credential to connect to SQL Server Report Server.
rsconfig -c -s <SQLSERVERNAME> -d reportserver -a SQL -u SA -p <SAPASSWORD>
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
=====================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================.|||Hello Wei
I get an error message saying
'No reporting services instance found on localhost'
when I run the rsconfig utility
I have been going through this
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=143931&SiteID=1
but I have the folders mentioned.
Paul S
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hello Paul,
> From your rsreportserver.config file, I did not see the LogonUser
> credential is applied. So please use the rsconfig utility to specify the
> credential to connect to SQL Server Report Server.
> rsconfig -c -s <SQLSERVERNAME> -d reportserver -a SQL -u SA -p <SAPASSWORD>
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> =====================================================> PLEASE NOTE: The partner managed newsgroups are provided to assist with
> break/fix
> issues and simple how to questions.
> We also love to hear your product feedback!
> Let us know what you think by posting
> - from the web interface: Partner Feedback
> - from your newsreader: microsoft.private.directaccess.partnerfeedback.
> We look forward to hearing from you!
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================.
>|||Hello Paul,
According to your email, I found that you are going to configure your
Express instance in your computer.
Please try the following:
rsconfig -c -s <SQLSERVERNAME>\Express -d reportserver -a SQL -u SA -p
<SAPASSWORD>
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
=====================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Issuing that command was what gave me the
'No reporting services instance found on localhost'
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hello Paul,
> According to your email, I found that you are going to configure your
> Express instance in your computer.
> Please try the following:
> rsconfig -c -s <SQLSERVERNAME>\Express -d reportserver -a SQL -u SA -p
> <SAPASSWORD>
>
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> =====================================================> PLEASE NOTE: The partner managed newsgroups are provided to assist with
> break/fix
> issues and simple how to questions.
> We also love to hear your product feedback!
> Let us know what you think by posting
> - from the web interface: Partner Feedback
> - from your newsreader: microsoft.private.directaccess.partnerfeedback.
> We look forward to hearing from you!
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>|||Hello Paul,
I would like to know how many instances you installed in the machine.
Pleas run the MPS Report .
--
a. Download MPSReport tool from below URL:
<
http://download.microsoft.com/download/b/b/1/bb139fcb-4aac-4fe5-a579-30b0bd9
15706/MPSRPT_SETUPPerf.EXE>
b. Execute the tool on the computer, and if you are prompted "Include the
MSINFO32 report?", please type Y.
c. Please send the result file (CAB file) to me
To reach me, please remove the ONLINE in my display email address.
For detailed information about the MPS Report Tools, please refer to the
following link:
Microsoft Product Support's Reporting Tools
<http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F
-88B7-F9C79B7306C0&displaylang=en>
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi
I have just send you the described CAB file
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>

rsAccessDenied

The permissions granted to user 'localmachine\ASPNET' are insufficient for performing this operation.

am using a report viewer on an aspx page that i call using javascript. the report work if the url have the port number for examplehttp://localhost:4254/adressofthereport but if i put for examplehttp://localmachinename/adressofthereport i get the permission error.

why this happen to me... please help.

i fix this inserting the localmachine\ASPNET user in the reports permissions

BUILTIN\administrator

localmachine\ASPNET

maybe you need to add dbowner o sysad access level to this user.

|||

Thanks.I am having same problem and i found the solution thanks.

rsAccessDenied

I have a reportViewer control on a webform. In my partial class I set the report path, server and parameters in the Page_Load. When I run the report I get this error:

The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)

Here is my code:

Dim u As New UriTypeConverter
Dim ReportParameters(0) As ReportParameter

ReportParameters(0) = New ReportParameter("ProjectKey", 262)
rv.ShowParameterPrompts = False
rv.ServerReport.ReportServerUrl = u.ConvertFromString("http://localhost/ReportServer/")
rv.ServerReport.ReportPath = "/Test/Duplicate_MIU_Report"
rv.ServerReport.SetParameters(ReportParameters)

Have you properly granted permission for your web user? Go to the configuration tool, and look for any red X on the left hand side. Open the "Web service identity" and make sure your web user is 'NT AUTHORITY\NETWORK SERVICE". Then go to "Database Setup" panel. I think you are using "Service Credentials". Reapply the settings may fix your problem.|||

I have NT AUTHORITY\NetworkService as the service account (it is grayed out so it is not possible to change), and I have Service Credentials as the credentials type in the database setup. There are no red X's. Still get the same error.

In addition, I get this DCOM error in the system log:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.

I'm not exactly sure what and how to do in Component Services admin tool.

|||

This thread may help you with the DCOM error:

http://forums.microsoft.com/MSDN/showpost.aspx?postid=258889&siteid=1

|||Netman has both local activation AND execution|||Do you see Network Services part of RSExec role in your report server catalog db and temp db?|||Yes|||Yes, Network Services is RSExec role in report server catalog db and temp db.|||It looks like Network Service account is not allowed to set parameters. I am not sure what is the mininum permission set. Can you try adding the account as a content manager to the home folder?|||If I right-click in design view in VS2005, the report runs fine. It doesn't work when I try to run in a browser and is being served up by my dev IIS server.|||I have added the NetworkService as administrator and still no go.|||That did it. Was confused in the ReportManager. Simple fix. Seems like lots of people having same problem. Thank you for your help|||Sorry--Don't follow what the fix was. What did it?|||

Went into Report Manager and gave NT Authority\NetworkService the necessary role assignments.

|||Thanks--got past that one, now I get to deal with the database access permissions lol...

rsAccessDenied

The permissions granted to user '[user]' are insufficient for performing this operation. (rsAccessDenied) Get Online Help

I have given role (literally every possible role just to see) access in SQL Manager without success. And the permissions on the directory were set to Everyone Full Control (just to try to get it to work).

Any ideas?

Hi,

Which folder are you trying to deploy to? Which OS are you using? Try allocating the Report Manager role to the user and also to the folder.

These links may be helpful

http://technet.microsoft.com/en-us/library/aa337491.aspx

http://msdn2.microsoft.com/en-us/library/aa237755(SQL.80).aspx

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

Search for "Setting Permissions in Reporting Services" or "Using Role-based Security" in SQL Server Books Online.

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

|||

Thanks. But, I've already been through all of that. And, I've searched this group for answers. I see that some found a solution; but those modifications aren't working, in my case.

Do you know if there is a problem with the port? The port is currently set at 8888.

|||

Another thought..

The Report Server machine that I am using is on a DOMAIN. The users are configured on the DOMAIN - not the local machine. The (2 Report Server) roles that are available from the Computer Management screen are not used with the users. However, they are added in SQL Manager (with their DOMAIN credentials) and given the proper roles (RSExecRole, etc). And the roles (2 filesystem) are assigned and given control over the directory for the Report Server configuration.

NT Authentication is being used. Does each network user need to be configured in "Computer Management -> Users/Groups" for some reason? Even though they are DOMAIN users - not LOCAL.

|||

Never Mind. I added a DOMAIN user to the "Computer Management" Report Server roles and I still get the error.

|||

Hi,

I am sure you must have done a lot of searching before asking this question, but at times the smallest of details can be helpful. So let us revisit this. I always follow these steps i noted sometime back and recommended by a mvp called bruce:

1. I hope you have gone through the link which i gave you earlier. That explains the role based security of reporting services. We have to use that to assign permissions. We will try not to give permissions using IIS.

2. Assuming you belong to the Local Admin group, create a local group on the deployment machine and add the domain users to that local group. Then assign this local group the appropriate role to access reporting services.

3. In IIS there are two sites Report Server and reports. Make sure that IIS has not allowed anonymous access for them.

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

|||

1. I hope you have gone through the link which i gave you earlier. That explains the role based security of reporting services. We have to use that to assign permissions. We will try not to give permissions using IIS.

Yep, I had been to that link even before you posted it.

2. Assuming you belong to the Local Admin group, create a local group on the deployment machine and add the domain users to that local group. Then assign this local group the appropriate role to access reporting services.

Yep. I have admin-ability on that machine. I created a group and added users to the group that was then given role access; and I tried giving role access directly to the users. Either way, I get the error.

3. In IIS there are two sites Report Server and reports. Make sure that IIS has not allowed anonymous access for them.

Yep. Using NT Authentication throughout.

Thanks. But, I've already been though all of that.

I have noticed that when going through Localhost (for testing it works), it shows that the Authentication is "NTLM"; but when going through the domain it shows that the Authentication is "Negotiate". I don't know if that makes a difference or not.

BTW.. I tried uninstalling the ReportServer stuff from Add/Remove and got an error (and then more errors) leading to the installer crashing. Now, ReportServer didn't actually uninstall (it is still there - in the GUI anyway); but doesn't work. And installing it again doesn't fix it. I was hoping that a fresh install would fix whatever it was. So, Report Services is completely broken at this point.

sql

rsAccessDenied

I have a reportViewer control on a webform. In my partial class I set the report path, server and parameters in the Page_Load. When I run the report I get this error:

The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)

Here is my code:

Dim u As New UriTypeConverter
Dim ReportParameters(0) As ReportParameter

In addition, I get this DCOM error in the system log:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.

I'm not exactly sure what and how to do in Component Services admin tool.

|||

This thread may help you with the DCOM error:

http://forums.microsoft.com/MSDN/showpost.aspx?postid=258889&siteid=1

Went into Report Manager and gave NT Authority\NetworkService the necessary role assignments.

|||Thanks--got past that one, now I get to deal with the database access permissions lol...

rsAccessDenied

I have a reportViewer control on a webform. In my partial class I set the report path, server and parameters in the Page_Load. When I run the report I get this error:

The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)

Here is my code:

Dim u As New UriTypeConverter
Dim ReportParameters(0) As ReportParameter

In addition, I get this DCOM error in the system log:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.

I'm not exactly sure what and how to do in Component Services admin tool.

|||

This thread may help you with the DCOM error:

http://forums.microsoft.com/MSDN/showpost.aspx?postid=258889&siteid=1

Went into Report Manager and gave NT Authority\NetworkService the necessary role assignments.

|||Thanks--got past that one, now I get to deal with the database access permissions lol...

rsAccessDenied

Hi All,
I have just installed Reporting Services on our production environment.
Everything is set up, the permissions etc and all seems fine until we try to
publish a report
I get the error :
Error rsAccessDenied : The permissions granted to user '[User Name]' are
insufficient for performing this operation.
Deploy complete -- 1 errors, 0 warnings
What have I missed here - on our Dev box I was an Administrator so there
weren't any problems
What permissions does the publisher have to have on the web server to be
able to publish reports?
Thanks
KathrynThe user needs the Manage Reports task. We role this task in a role called
Content Manager (although you could create your own roles with specific
tasks if you want). If you give the user this role then they will be able
to publish reports. To give them permission, go to the folder you want to
give them permission to (in report Manager) and click on the properties tab,
then on the security sub tab. From there you can give them the permissions
you want.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kathy" <joe@.soap.com> wrote in message
news:PvmdnfocNYNSE3_cRVn-vQ@.is.co.za...
> Hi All,
> I have just installed Reporting Services on our production environment.
> Everything is set up, the permissions etc and all seems fine until we try
> to
> publish a report
> I get the error :
> Error rsAccessDenied : The permissions granted to user '[User Name]' are
> insufficient for performing this operation.
> Deploy complete -- 1 errors, 0 warnings
> What have I missed here - on our Dev box I was an Administrator so there
> weren't any problems
> What permissions does the publisher have to have on the web server to be
> able to publish reports?
> Thanks
> Kathryn
>
>|||Thanks Daniel
Turns out this wasn't the problem.
I actually had to give our group permissions on the Report Server and Report
Manager folders.
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:eB%23dH%23z9EHA.3944@.TK2MSFTNGP12.phx.gbl...
> The user needs the Manage Reports task. We role this task in a role
called
> Content Manager (although you could create your own roles with specific
> tasks if you want). If you give the user this role then they will be able
> to publish reports. To give them permission, go to the folder you want to
> give them permission to (in report Manager) and click on the properties
tab,
> then on the security sub tab. From there you can give them the
permissions
> you want.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Kathy" <joe@.soap.com> wrote in message
> news:PvmdnfocNYNSE3_cRVn-vQ@.is.co.za...
> > Hi All,
> >
> > I have just installed Reporting Services on our production environment.
> > Everything is set up, the permissions etc and all seems fine until we
try
> > to
> > publish a report
> > I get the error :
> > Error rsAccessDenied : The permissions granted to user '[User Name]' are
> > insufficient for performing this operation.
> >
> > Deploy complete -- 1 errors, 0 warnings
> >
> > What have I missed here - on our Dev box I was an Administrator so there
> > weren't any problems
> > What permissions does the publisher have to have on the web server to be
> > able to publish reports?
> >
> > Thanks
> > Kathryn
> >
> >
> >
>

rsAccessDenied

Hi i am having this error when i am running my default1.aspx page in localhost.I am using sql server 2005 reporting services and i have made one report in business intelligence tools reporting service through wizard.And deploy it it is running in report server.I am using one page that is default1.aspx and using report viewer and set the path that is debugging and showing that report but when i am running that in url writehttp://localhost/testdemo/default1.aspx so it is giving error

that error is"The Permission Granted to user "UserName/ASPNET" is insufficient for performing this operation.(rsAccess Denied)

Please help me to solve this problem.

Hiswapnil.malviya ,

See posthttp://forums.asp.net/t/1168322.aspx

Please do not make duplicated posts. Thanks for your cooperatoin. thanks

rsAccessDenied

The permissions granted to user '[user]' are insufficient for performing this operation. (rsAccessDenied) Get Online Help

Any ideas?

Hi,

Which folder are you trying to deploy to? Which OS are you using? Try allocating the Report Manager role to the user and also to the folder.

These links may be helpful

http://technet.microsoft.com/en-us/library/aa337491.aspx

http://msdn2.microsoft.com/en-us/library/aa237755(SQL.80).aspx

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

Search for "Setting Permissions in Reporting Services" or "Using Role-based Security" in SQL Server Books Online.

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

|||

Thanks. But, I've already been through all of that. And, I've searched this group for answers. I see that some found a solution; but those modifications aren't working, in my case.

Do you know if there is a problem with the port? The port is currently set at 8888.

|||

Another thought..

NT Authentication is being used. Does each network user need to be configured in "Computer Management -> Users/Groups" for some reason? Even though they are DOMAIN users - not LOCAL.

|||

Never Mind. I added a DOMAIN user to the "Computer Management" Report Server roles and I still get the error.

|||

Hi,

3. In IIS there are two sites Report Server and reports. Make sure that IIS has not allowed anonymous access for them.

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

|||

1. I hope you have gone through the link which i gave you earlier. That explains the role based security of reporting services. We have to use that to assign permissions. We will try not to give permissions using IIS.

Yep, I had been to that link even before you posted it.

2. Assuming you belong to the Local Admin group, create a local group on the deployment machine and add the domain users to that local group. Then assign this local group the appropriate role to access reporting services.

3. In IIS there are two sites Report Server and reports. Make sure that IIS has not allowed anonymous access for them.

Yep. Using NT Authentication throughout.

Thanks. But, I've already been though all of that.

sql

rsAccessDenied

Hello,

I am new to Reporting Services 2005, so please bare with me. I have set up a new report that runs fine when I run it, but I am the administrator on the server. When I have a user go to the same web page and attempt to run the report, they receive an error that says something along the lines of "User account 'DomainName\UserName' does not have sufficient access to ReportServer... rsAccessDenied." I have seen several threads on the web that point to IIS, and some that point to the "Reporting Services Configuration Manager" under "Windows Service Identity". In my Windows Services Identity, I have the server set up as "Built-in Account = 'Local System'". Everything seems to be running perfect for me, I just can’t seem to get non-admin accounts to run reports from there local workstations. Please let me know what my settings should be on the server. Like I said, the web page comes up fine for all users, but when they click on the hyperlink that runs the report, they receive the Reporting Services error message, but it runs fine for me. Your help would be greatly appreciated.

Thanks,

Stephen Rooker

use the following:

'rs.Credentials = System.Net.CredentialCache.DefaultCredentials

Dim LogonCredentials As System.Net.NetworkCredential

Dim Items As rs.CatalogItem

LogonCredentials = New System.Net.NetworkCredential("username", "password", "domainname")

rs.Credentials = LogonCredentials

rs.PreAuthenticate = True

|||

Thanks for your help. Here's what I did to fix this issue. I'll enter detail for any other developers out there that may come across this issue and need help.

In your internet browser address bar, enter http://ServerName/Reports . I did this from the server, but you may be able to do this from anywhere on the network as long as you have permissions. Select the Properties tab, and then click on New Role Assignment. Add network User Name or add your network Group in the text box. I recommend using network groups due to maintenance. I just entered the group name I wanted to allow access, and then I checked the Browser role check box only. The Browser role is basically run reports only. You may want to review what the other check boxes allow, but I only added my users to the Browser role and it worked for them. When finished, click the Apply button at the bottom of the page. The domain name was added for me automatically after I clicked Apply, so make sure you see your domain name in front of the user name or group after you click Apply.

Now go back to the Contents tab, select Data Sources, and then select your data source name. The data source that you used for your reports. In there, make sure all of the settings are correct. I needed to make sure the user name and password are correct so a successful data connection is made. Click Apply at the bottom of the page when finished.

Doing this fixed my issues with rsAccessDenied error message.

Thanks,

Stephen Rooker

|||Cheers mate you helped me fix my issue.

rsAccessDenied

Hello,

Thanks,

Stephen Rooker

use the following:

'rs.Credentials = System.Net.CredentialCache.DefaultCredentials

Dim LogonCredentials As System.Net.NetworkCredential

Dim Items As rs.CatalogItem

LogonCredentials = New System.Net.NetworkCredential("username", "password", "domainname")

rs.Credentials = LogonCredentials

rs.PreAuthenticate = True

|||

Thanks for your help. Here's what I did to fix this issue. I'll enter detail for any other developers out there that may come across this issue and need help.

Doing this fixed my issues with rsAccessDenied error message.

Thanks,

Stephen Rooker

|||Cheers mate you helped me fix my issue.

Monday, March 26, 2012

rsAcessDenied when running the report

rsAccessDenied with Forms Authentication

rsAccessDenied when accessing Report Server

rsAccessDenied for every non local admin

rsAccessDenied for authorised user.

rsAccessDenied even for the Content Manager role

rsAccessDenied and

rsAccessDenied

rsAccessDenied

rsAccessDenied

rsAccessDenied

rsAccessDenied

rsAccessDenied

rsAccessDenied

rsAccessDenied

rsAccessDenied

rsAccessDenied

RS and HTTPS

Blog Archive

About Me