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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

The permissions granted to user 'AD\myusername' are insufficient for performing this operation. (r

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Sql Server
 

The admin of the reporting server added me to ALL roles except the My Reports role for a folder.  I am connecting to the server with different login credentials than the one on my desktop (different domain - domains not trusted). Once connected using the RS's domain and the account I have in that domain, I can view the reports just fine but get the above error when trying to see the properties of a report.

Any ideas why it's only letting me browse and view reports and nothing else?

Thanks




View Complete Post


More Related Resource Links

The permissions granted to user 'Domain\user' are insufficient for performing this operation. (rsA

  

Hi, I've scoured the forums and tried just about every answer to this problem without any success.   What I have is SQL Server 2005 installed on a single machine, and trying to deploy reports to the same machine for testing purposes.  When I try to deploy the report I receive the permissions error. Here's what I've gotten to at this point:

  •   I can get to the reports URL (http://machine/Reports)
  •  I can login to Reporting Services via SQL Server Management Studio as the administrator.  (Windows Authentication) 
  • I have added my login to the Home Folder-->Permissions in SQL Server Management Studio, and all reports are set to inherit the home folder's permissions 
  • In Reporting Service Configuration Manager the Windows Service Identity is set to Local System, and for web service identity - ASP.NET Service Account is set to NT Authority\NetworkService; Report Server and Report Manager are set to DefaultAppPool.
  • In IIS I tried enabling Anonymous Authentication
  • Current Application pools are set to "Classic" for Managed Pipeline mode (I did this to actually be able to login to Reporting Services via SQL Server management stu

permission granted to user are insufficient for performing this operation - test connection

  

I (think) i migrated a 2000 reporting service database over to 2008. I say i think because i'm getting some weird behavior. I have a folder where i place all the datasources. On most of them, if i click manage, and then test connection, i get an error of:

The permissions granted to user <my login> are insufficient for performing this operation. (rsAccessDenied)

I am listed as the system admin and system user under site settings, security. I tried changing it to just sys admin. That seems to have given me access to test at least some of the data sources.

I compared the security settings on the ones i can test vs the ones i cant, and they are the same. I have no problems running the reports attached to this datasource. 

Is this a permission issue on the source database? Because i tried creating a new datasource to the same source db and got the same error. But wouldn't the test connection button use the credentials supplied if i have NOT selected the otion to use windows credentials? Although one of the databases that i CAN use the test connection button on, i do not have permission to connect to using my windows login.

So i really have no clue why i seem to be unable to 'test connection' on some of the datasources. Any suggestions?


Insufficient SQL database permissions for user '' Event ID 5214

  
I am getting the Database Error Event ID 5214, with the Source of Windows SharePoint Service 3 on my MOSS 2007 SP2 server - this system has been running for the past year fine & without this error.  The general text of the error in Event Viewer is:

Insufficient SQL database permissions for user '' in database 'SharePoint_Config' on SQL Server instance 'illinois'. Additional error information from SQL Server is included below.

The EXECUTE permission was denied on the object 'proc_getObjectsByClass', database 'SharePoint_Config', schema 'dbo'.

Notice that there IS NO USER listed.  I can only find articles dealing with setting the proper user permissions etc...but nothing about this.  Why would no user be listed here & where do I go to fix this?  Why would this error start occurring?


In reporting services got this error "The permissions granted to user sysname\ASPNET are insufficien

  

hi...

i'm using sql server 2008 with advance services 

the below error is of reporting services..


"The permissions granted to user 'sysname\ASPNET' are insufficient for performing this operation. (rsAccessDenied)"

when i'm trying to host  appliction.. the above error is occured..

it works fine when i try to execute locally.. but when i try to execute through the IIS i.e host application

the above error is displayed.

please help me....


In reporting services got this error "The permissions granted to user sysname\ASPNET are insufficien

  

hi...

i'm using sql server 2008 with advance services 

the below error is of reporting services..


"The permissions granted to user 'sysname\ASPNET' are insufficient for performing this operation. (rsAccessDenied)"

when i'm trying to host  appliction.. the above error is occured..

it works fine when i try to execute locally.. but when i try to execute through the IIS i.e host application

the above error is displayed.

please help me....


How to identify whether a user has granted direct permissions or through a group?

  

Hello

I want to find whether a user in a site has been granted permissions directly or he is inheriting permissions from a group. How can I do that using SharePoint object model?


Regards
NLV
Visit SharePoint User group - India

Error "user does not have permission to perform this operation" with User Instance = True.

  

I setup SQL Server 2005 / SQL Express. All works fine in SQL Server 2005.

I am connecting to a SQL Database from VS 2005,  Tools/Connect to Database. I set the Data Source to "Microsoft SQL Server Database File (SqlClient)" (meaning SQL Server Express) and User Instance = True, and Integrated Security = True.

The above is working successfully on all machines except my Laptop. On my Laptop, I am getting this error "user does not have permission to perform this operation". On my Laptop, if I change User Instance = False, it works fine. Also, If I connect to SQL Server 2005 it works fine only if User Instance = False.

I tried all kind of security changes, nothing worked. For example, I setup Everyone as Full Control for the Folder and the MDF File of SQL Server. I gave my user ID as sysadmin role in SQL Server Express. Also, I enabled creating User Instance form SQL Server Express, Nothing is working.

Appreciate your help.

Tarek.


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

  

 Hello,

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 

How to check effective permissions for a user or group for a SQL server object or whole server?

  
Guys, How do I see effective permissions for a user or group for a SQL server object or whole server? For example, a user is not listed in security/logins, but he is a member of few groups and some of them have assigned permissions on SQL server (again either directly or through membership in other groups) Even when I select an object (a table), check properties/permission – it doesn’t let me select any principal, except those listed on security/logins… Anyway, what is the right way to see effective permissions for a user or group? Sorry for asking such a simple question, I’ve searched but found nothing relevant.

Error "user does not have permission to perform this operation" with User Instance = True.

  
I setup SQL Server 2005 / SQL Express. All works fine in SQL Server 2005. I am connecting to a SQL Database from VS 2005,  Tools/Connect to Database. I set the Data Source to "Microsoft SQL Server Database File (SqlClient)" (meaning SQL Server Express) and User Instance = True, and Integrated Security = True. I am using Windows Authentication mode in SQL Server Express. The above is working successfully on all machines except my Laptop. On my Laptop, I am getting this error "user does not have permission to perform this operation". On my Laptop, if I change User Instance = False, it works fine. Also, If I connect to SQL Server 2005 it works fine only if User Instance = False. I tried all kind of security changes, nothing worked. For example, I setup Everyone as Full Control for the Folder and the MDF File of SQL Server. I gave my user ID as sysadmin role in SQL Server Express. Also, I enabled creating User Instance form SQL Server Express, Nothing is working. I am already added to the Administrator Group locally on my Laptop. Still same problem. Checked this article: http://msdn.microsoft.com/en-us/library/ms254504.aspx, same problem. I enabled User Instances and also tried to Disable User Instances. When I disable user instances, and then try to connect from VS, I get a different error, which is asking to enable user instances.

User Permissions

  
I am in need of some help regarding user permissions. I need users to be able to have read only permissions on all documents except their own, but when i have set this up i notice that the user can still Publish a Major Version. i have 6 department sites, each with their own document library, so i need to create groups for these departments so that i can assign users to, so that they can edit within their own department site but only read in other sites. so how can i set the permissions so that the user is unable to Publish documents and also is unable to delete anything that is not thie own?

User Profile Service account Write to AD Permissions

  
I followed this guide here (http://www.harbar.net/articles/sp2010ups.aspx) to provision the UPS service in sharepoint 2010. I found the guide very helpful and informative. Everything is working correctly except for the write back to AD I've followed the steps and have assigned the listed permissions to the UPS service account, however I still get permissiong errors in the FIM GUI Our AD is running in a 2008 environment but is in 2003 mode, so I made sure to add the UPS account to Pre Windows 2000 Compatible access built in group and restart the server so that the new group settings would take affect. Do I need to reprovision the UPS service or something? Or am I missing something completely. (Hopefully the latter lol!) Thanks RKB

User permissions in SharePoint 2010 act differently in http and https

  
I installed SharePoint 2010, created a site (complete with a document library), and assigned user permissions.  Additionally, I set up certificate authentication for all users.  Two problems occur: 1. As the system administrator, when I access the https site, I no longer have permissions to add/edit users 2. When user's, who have permissions to edit/add a document/folder click on "Add document" or the folder icon to add a new folder, they get an error. Any help is much appreciated.

User permissions do not reflect what the user can actually do

  
I just installed SharePoint 2010, created a site (while in Central Administration), and assigned user permissions in the site (down to the document level in a document library).  However, when a user, who has full control permissions, tries to add/edit a document he/she gets an error: List does not exist. The page you selected contains a list that does not exist.  It may have been deleted by another user.   Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: 6be95e46-8098-48d6-ac89-f0acfa694031 Date and Time: 9/2/2010 8:41:42 AM Any help would be much appreciated.

User Permissions

  
HI I have a problem with user permissions I created a document library and assigned to user("ram"), when other user("kumar") login, able to select "Edit item" and can make chages to document. How do i restrict the user(kumar) from editing document, and allow only user(ram) can change the status/edit the document.  

User Permissions Help

  
I have issue i need some help or may be you can direct me. I am trying to set up User permissions for Report Server using SSMS. http://msdn.microsoft.com/en-us/library/ms156293.aspx Im following the instructions in the above link. What i need to know we have 100 users and each user needs a specific view of the report. Like  analyst1 user might view one report and analyst2 dont need to.Is there a query ? or a code where i would control the permissions. What happens if there are new users added?anyway to automate the assigning of roles? FYI in our DB we have all users tied to a security level.FM

Reports & User Permissions

  
We have SQL SERVER 2008 STD Edition. Im not understanding an issue. We have SQL Agent Job that sends out reports to all users.We have user categorized as Analyst,Sales Rep,Sales Rep Sub & General Users. All the Users have security levels.I created a view which has all the Users.. My question is how do i merge it with the SQL JOB or how can i alter the SQL job query to delivery reports based on security level Analyst have security level 3, so i want groupof reports sent to them. use Pricing go Alter View dbo.User_Access AS select S.SR_name,u.SRID,sr.SRsub_name,u.SRID_SubID,U.Userid,u.username,u.Email,u.SecurityLevel,a.AnalystID from dbo.Users uleft  join tbl_Analyst a on a.AnalystID=u.UserIDleft join tbl_SalesRep s on s.SRID=u.SRIDleft Join tbl_SalesRep_Sub sr on sr.SRID_SubID=u.SRID_SubID
Categories: 
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