Showing posts with label library. Show all posts
Showing posts with label library. 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 7, 2012

Good Book on Datawarehousing with SqlServer?

Can anyone recommend a good book on designing and implementing a data
warehouse using sql server specifically? Not just one in your library, but
one that stands-out?
Thanks,
Michael
The Good Books that can be refered are
1)OLAP Analysis services 2000 By WROX Press
2)MDX solutions with Microsoft SQL server Analysis Services By George
spofford -Wiley press
3)Microsoft OLAP solutions by George spofford ,Erik Thomsen & Dick chase
-Wiley Press
Regards,
SriniPeela
"Snake" wrote:

> Can anyone recommend a good book on designing and implementing a data
> warehouse using sql server specifically? Not just one in your library, but
> one that stands-out?
> Thanks,
> Michael