rsInternalError on Reporting Services

hello,
i have created a webform to call the reports in the report
server. When i click submit in the webform, it will redirect to the
selected report.
This works fine for the first few times. However, after sometime
i would be getting the following error :
"An internal error occurred on the report server. See the error log for
more details. (rsInternalError) Get Online Help
Timeout expired. The timeout period elapsed prior to obtaining a connection
from the pool. This may have occurred because all pooled connections were
in use and max pool size was reached. "
Once this happen, i could not even open my local report server
in the browser.
Could some one please help me......... it's urgent.. thanks
...
--
Message posted via http://www.sqlmonster.comtry setting the timeout to infinite,
rs.Timeout = -1

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

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

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

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...

RS2005 insufficient permissions

So when I run the report in the Report Manager, everything is all good. When
I run it in a webform using report viewer for vs.net 2005 the view reports
this error.
"The permissions granted to the user 'NT AUTHORITY\NETWORK SERVICE' are
insufficient for performing this operation(rsAccessDenied)"
What interesting when RS2005 install on XP Professional setting for
webservice identity shows ASPNET and reports work on that machine in report
viewer control. But when running on Windows 2003 Server, it uses default pool
and NETWORK SERVICE ACCOUNT by default which I think is the problem. Any idea
or anyone run into this.Curious if anyone now the bare minimum to run 2005 report in a webform.aspx
using report viewer. ASPNET was enough on XP Pro runnng RS2005 locally. But
it's different on a Server. This is obviously a good thing, wondered how I
can find the bare minimum without assigning Everyone as I discovered fixed
the problem below:
Well thought post the hack on this one. So what I ended testing and showed
success, in report manager I temporarily aded new role, "Everyone" with
browse only rights on the Home directory security roles in report manager,
now the report loads.
----
I would like to let people now, we where in a crunch to get it working, but
would love to hear how RS2005 has maybe been change to use forms
authentication or some solution for people that now danger running ASPNET
identity to access sensitive data, but have their surround website secured.
---
So my next step:
1) revert securty at Home level on report manager to only Administrator role.
2) add folder for reports and deploy the reports to the new folder on the
report server
3) use seperate permissions on folder then the home root. For newbie, you do
this by clicking on the folder in report manager, click properties and
security. Then use new role and choose yes to warning that you want these
roles seperate from home security. This allows the report to run in our
webform.aspx as the website is protect with form authentications.
"Rob G" wrote:
> So when I run the report in the Report Manager, everything is all good. When
> I run it in a webform using report viewer for vs.net 2005 the view reports
> this error.
> "The permissions granted to the user 'NT AUTHORITY\NETWORK SERVICE' are
> insufficient for performing this operation(rsAccessDenied)"
> What interesting when RS2005 install on XP Professional setting for
> webservice identity shows ASPNET and reports work on that machine in report
> viewer control. But when running on Windows 2003 Server, it uses default pool
> and NETWORK SERVICE ACCOUNT by default which I think is the problem. Any idea
> or anyone run into this.
>|||When you were developing before (everything on one machine) you were the
administrator on the machine and that is why everything worked. What I do is
have a local group, I add domain users and groups to that (for instance add
a group called Reports). Give them browse rights at home. The other folders
will inherit. In most cases all the users have rights to all the folders. If
not, change for the specific folder.
You definitely do not want to do anonymous.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rob G" <RobG@.discussions.microsoft.com> wrote in message
news:2C5D679B-E5CD-4ECF-8F44-00E47F5DAB3E@.microsoft.com...
> Curious if anyone now the bare minimum to run 2005 report in a
> webform.aspx
> using report viewer. ASPNET was enough on XP Pro runnng RS2005 locally.
> But
> it's different on a Server. This is obviously a good thing, wondered how I
> can find the bare minimum without assigning Everyone as I discovered fixed
> the problem below:
> Well thought post the hack on this one. So what I ended testing and showed
> success, in report manager I temporarily aded new role, "Everyone" with
> browse only rights on the Home directory security roles in report manager,
> now the report loads.
> ----
> I would like to let people now, we where in a crunch to get it working,
> but
> would love to hear how RS2005 has maybe been change to use forms
> authentication or some solution for people that now danger running ASPNET
> identity to access sensitive data, but have their surround website
> secured.
> ---
> So my next step:
> 1) revert securty at Home level on report manager to only Administrator
> role.
> 2) add folder for reports and deploy the reports to the new folder on the
> report server
> 3) use seperate permissions on folder then the home root. For newbie, you
> do
> this by clicking on the folder in report manager, click properties and
> security. Then use new role and choose yes to warning that you want these
> roles seperate from home security. This allows the report to run in our
> webform.aspx as the website is protect with form authentications.
>
>
> "Rob G" wrote:
>> So when I run the report in the Report Manager, everything is all good.
>> When
>> I run it in a webform using report viewer for vs.net 2005 the view
>> reports
>> this error.
>> "The permissions granted to the user 'NT AUTHORITY\NETWORK SERVICE' are
>> insufficient for performing this operation(rsAccessDenied)"
>> What interesting when RS2005 install on XP Professional setting for
>> webservice identity shows ASPNET and reports work on that machine in
>> report
>> viewer control. But when running on Windows 2003 Server, it uses default
>> pool
>> and NETWORK SERVICE ACCOUNT by default which I think is the problem. Any
>> idea
>> or anyone run into this.
>>