Showing posts with label aspx. Show all posts
Showing posts with label aspx. Show all posts

Thursday, March 29, 2012

Granting access to an Integration Services server?

I have followed the instructions in this topic: http://msdn2.microsoft.com/en-us/library/aa337083.aspx and I have read Kirk Haselden's blog post on the subject (which contains the same info) and I still CANNOT manage to grant non-administrators the ability to access an IS server. They constantly get the Access is Denied error. Has ANYONE actually gotten this to work? If so, could you please share what you did?Jeff,
Try looking at this and see if this helps:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=701950&SiteID=1|||

Yes, Yes, YES! That contained the missing puzzle piece!

I'll reiterate for posterity:

The MSDN documentation at http://msdn2.microsoft.com:80/en-us/library/aa337083.aspx is incomplete. It mentions setting custom permissions in the Launch and Activation Permissions group but it fails to mention that you must also set custom permissions in the Access Permissions group.

|||

JeffJohnsonMVPVB wrote:

Yes, Yes, YES! That contained the missing puzzle piece!

I'll reiterate for posterity:

The MSDN documentation at http://msdn2.microsoft.com:80/en-us/library/aa337083.aspx is incomplete. It mentions setting custom permissions in the Launch and Activation Permissions group but it fails to mention that you must also set custom permissions in the Access Permissions group.

Be sure that you click on the feedback comment button at the top right of that article.

Wednesday, March 21, 2012

Got to be something wrong... http://myserver/reports REALLY slow

Is anyone experiencing the folder.aspx taking a really long time to render
the list of reports? On our server, all other web sites a very quick, but:
opening http://myserver/reports/Pages/Folder.aspx can take as long as 40
seconds to list a few reports!
Thinking it must be an install or configuration issue... any idea?
All comments appreciated.
ThanksThere was a whole thread awhile back that may help you understand the issue:
http://www.msdn.microsoft.com/newsgroups/managed/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=3031983d-75f9-466c-ad3a-3d76f0bebdc5
--
Adrian M.
MCP
"Rick Matthys" <RickMatthys@.discussions.microsoft.com> wrote in message
news:7B0FF73B-4295-4B3E-AFBA-4B0DF11E9722@.microsoft.com...
> Is anyone experiencing the folder.aspx taking a really long time to render
> the list of reports? On our server, all other web sites a very quick,
> but:
> opening http://myserver/reports/Pages/Folder.aspx can take as long as 40
> seconds to list a few reports!
> Thinking it must be an install or configuration issue... any idea?
> All comments appreciated.
> Thanks|||Try re-starting IIS or ASPNET. I had that problem too, and I
re-started IIS and it helped quite a bit.|||thanks for the response Adrian and John... changed the IIS recycle setting,
restarted IIS, and presto, page comes up a lot faster!
"Adrian M." wrote:
> There was a whole thread awhile back that may help you understand the issue:
> http://www.msdn.microsoft.com/newsgroups/managed/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=3031983d-75f9-466c-ad3a-3d76f0bebdc5
> --
> Adrian M.
> MCP
>
> "Rick Matthys" <RickMatthys@.discussions.microsoft.com> wrote in message
> news:7B0FF73B-4295-4B3E-AFBA-4B0DF11E9722@.microsoft.com...
> > Is anyone experiencing the folder.aspx taking a really long time to render
> > the list of reports? On our server, all other web sites a very quick,
> > but:
> >
> > opening http://myserver/reports/Pages/Folder.aspx can take as long as 40
> > seconds to list a few reports!
> >
> > Thinking it must be an install or configuration issue... any idea?
> >
> > All comments appreciated.
> >
> > Thanks
>
>sql