.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

What do I have to do to allow users read access to the cube?

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :Sql Server

(SQL 2005)

I'll try asking this again since I'm still not able to access my data cube. 

I've developed a BI solution with SSIS, SSRS and SSAS.  The account I've used for development has had Domain Administrator permissions and I've never had a problem running an SSRS report that reads the cube.  When I use an account with less than Domain Admin permissions and try to run a SSRS report that runs a query against a SSAS cube the query fails.

I've set up a Domain User group and given it read access to the data sources in Report Manager.  I've given the group datareader role in ReportServer and ReportServerTempDB as well as the DataReader role in the SSAS cube.

Why can't I read any data from the cube???

View Complete Post

More Related Resource Links

TreeView in Web Part required webctrl_client folder to have atlease read access for all users


HI All

I am using the TreeView control from the Microsoft.Web.UI.WebControls Namespace to render a treeview in a SharePoint web part. The tree nodes images do not appear (text is rendered) properly until i grant atleast read permissions to Authenticated Users on the webctrl_client folder which has to be places in the web application's virtual directory.

Is there some way I can avoid granting the read permission on that folder to all authenticated users.

If i go ahead with the approach of giving the authenticated users rad permission, will a user loggedin via FBA get the read permission

Thanks in Advance

Broken Images for Users with Read access



we just have moved our existing sharepoint team site to an extranet site and ran into a strange issue with images. Two of the images on our extranet site does not show up for users with Read access .They see little red "x" instead.  It only happens for two images not for all.

All images were added in Publishingimages or images folder and the library does inherit permissions from the main site.

any thoughts

Isha kapoor My SharePoint Blog Follow me

Hide documents from being access by unauthorized users.


Hi experts,

I would like to know how to hide certain documents (eg. Word, Excel, PPT, PDF) in a document libraries from unauthorized users? I tried implement Target Audience, but it doesn't work. If anyone know, i really appreciate for the guidance.

p/s: If my posting is not relevnt to the thread, please kindly move it to the appropriate places. Thanks!

"Read Only" Access Error when checking in documents from outlook



We are accessing our sharepoint services 3.0 document library through outlook 2007.

We can open the files in word/excel etc, but when we go to check-in the document the application tells us that we only have read access to the document, and cant check the document back in to the server.

It works fine via the browser, the read only problem is only when checking out through outlook.

I have given all users full access and design access to the doc library.

Any help would be greatly appreciated.






Access denied to folder in ASP.NET project either though I have granted all users full permissions !



i have made a very simple file upload app, that i want users to be able to upload images to a folder on my server, well localhost for the time being Stick out tongue

here is the simple upload code...

        protected void ButtonRegisterDetails_Click(object sender, EventArgs e) 
            // display properties of the uploaded file 

ASP.NET Allow Admin Users Access Basic Users Accounts


We have an ASP.Net web application currently released to the public, that uses Membership and Provider features and have our users assign to a "Basic" role.  What we are working on doing is developing an administrative site, so that administrators (presumably to be assigned an "Admin" role), are able to login to the administrative site, where they will have access to a list of users in the "Basic" role.
From the admin site, we want to allow the administrators to click on any of the "Basic" users and effectively be logged into there account (loading the user's profile information in the process, as is the case when a "Basic" user logs in), while still remaining lo

How to restrict folder access to users and theirs only


Hi. I created a web application using "Forms Authentication". 

There is a folder name "uploads", and it creates subfolders as username when they register. Web application stores users' files and images under their folder ("uploads/username")

I tried to find a way to restrict users to download and upload files to their folder only and couldn't find a good one. 

Then I came up with this idea that stores "web.config" file each time user registers and the web.config should look like below. Username will be changed dynamically according to username.

This method actually works but I am little worried if this is a good practice as far as performance wise. Because it'll create web.config files as many as users and there might be other holes that I don't recognize. 

I appreciate any advice or better suggestion for this problem.

--------web.config in "/Root/uploads/username directory"--------------

<location path="HRpages">

Merge Replication: How to give read access on snapshot share to a sql account

Hello All, I want to give read access to an sql account(not windows account). Can it be given or not. Someone please tell. Thanks saandii777

Task assignment to user without read access in 2007 results in no email to assignee, no warning to a

It appears (from observation and searching) that SP 2007 will not send a task assignment email when the assignee does not have read access for the assigned task and there is no warning when assigning a task to someone who will be unable to read it. I have not been able to find any mentions of attempting to address this quirk by either an item event listener or a workflow that would either prevent the assignment or task the originating user to fix the issue by either changing the assignment or having them added to the appropriate group.  I could see one done badly causing a cascade of tasks. The approaches that I've thought about are: Attempt to block assignment by hooking ItemAdding and ItemUpdating on the task content type.  In ItemUpdating, you could use SPListItem.DoesUserHavePermissions since the SPListItem should be there, but you'd may have check the list since I don't think SPListItem is available at that time.  I could see this causing problems when the assignment is via workflow or something that doesn't like other code interfering with its task creation. Hooking ItemAdded and ItemUpdated to assign a new task to the assigning user to either change the assignment or have the assignee added to the users with access to the site. Define a workflow which could be enabled for a list that would check if any new or modified task is assigned to users with

"Only their own" allows users to edit, then shows access denied page

I am managing a WSS 3.0 portal.  I have created custom lists where a group has contribute permissions.  Under List Settings|Advanced Settings, when I set Edit Access to "Only their own" or "None", my test users can see the Edit Icon and the Edit Item menu option, and bring up the Edit Form.  When they click "OK", they get the Access Denied page.  My experience in that past is that they should not even been shown the option to edit, and they should get Access Denied if they somehow navigate to the EditForm.aspx page.  I even tested this on a brand new site, with three Links lists, each with different Edit Access Levels (All, None, Only their own).  I added one user with contribute permissions.  He had the same result: He could get all the way to EditForm.aspx, but got "Access Denied" when he submitted his changes.  What can I do to fix this?Christopher W. Douglas

MDX to read members from "restricted access" role

Is it possible to read list of members from "restricted access" roles? I want an MDX so we can create an exception report for maintance purposes to match this list with some other list. I only need to list what I see when I open "resticted access" role - domains with user names. thank you!

All Users (Including Site Collection Admins) receiving Access Denied from one Site Collection

I usually spend my time in the forums answering questions.  But this time I need the help. I’ve got a client who somehow has succeeded in locking EVERYONE out of one of their Site Collections.  Users can authenticate to the site, but get an accessdenied page when you try to access anything in the site collection, including pages served from the _Layouts virtual directory.  The AccessDenied page shows that they are authenticated, but not authorized.  This is true for Site Collection admins and user’s who have been given Grant Full Control via a Web Application Permission Policy.  Central Admin and one other site collection are behaving normally.  I've already checked for database permissions - the service account can access the database fine. I've also checked for a locked database or overextended quota.  It's not that either. The accessdenied page url references the users list in the root of the site collection as the offending list denying access.   Does anyone have any ideas?Paul Stork SharePoint Server MVP

Authentication for External Users to Access MOSS 2007 Resources

Our MOSS 2007 supports users from two domains that authenticate using windows.  Our clients WindowsXP in domain#1 and WindowsVista in domain#2 (which has presented problems authenticating to MOSS 2007.  I would like to give access to external users outside of those two domains.  However, our management does not want to establish trusts between domains.  What would be the best practice to accomplish this?  Additionally, will MOSS 2010 or Forefront resolve these issues?

How to know all the users on Sharepoint 2010 and what access do they have ?

Hello,   I'm using SharePoint 2010 , and i was wondering if there is a way to "extract" the user's list that are using Sharepoint and what do they have access to in the sharePoint? if there is a way using the central Administration or if there is a PowerShell command line to use... thnx alot.

Allowing internal users access to Sharepoint site externally

Good afternoon.   This may be a simple answer (I hope so actually) but I haven't been able to figure this out. What I need: I have internal users who can access my Sharepoint site easily while logged onto my network, and external users who I have added to our Active Directory system who can access the site using our external URL.  Both work fine. What I am having problems with:  One of my users (internal) is on a different AD (he is on our European network) and he can not access the site either from the VPN (when he is in the US) nor from the external site (it will take him to the logon screen, but since he doesn't have an account on our AD, it won't let him in). I understood from our European IS department that all we had to do was give him both internal and external access to the Sharepoint site, and he would be able to connect from anywhere. So, how do I do that (give him both)?  Do I need to have our IS team turn on MOSS2007 to do this (it is not turned on today). Many thanks, I am still a newb at Sharepoint, but trying to learn quickly. Thanks, Jim  

# users connected to a olap cube?

How do I know how many end users are connected to a cube at certain time? Most of them use excel pivotal tables to connect to the cube.   Thanks, Alex

SharePoint sites users have access to

Hi All, Is there any way that I can check what SharePoint sites users have access to? Thanks!  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend