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


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

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

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

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


    View Complete Post


More Related Resource Links

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

  

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


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

How to authenticate local user usin ldap or non domain authentication

  

hiiii

I created one application, and I need to authenticate local user. This user is the user who is login to his/her Personal Computer.. Main thing his that he/she does not in any DOMAIN... I want NON-DOMAIN authentication.. any how.... please help...


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.


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.

Changing user domain

  
Hi, We have our sharepoint 2007 entreprise farm importing users from two different AD. Let's say 'potato' and 'orange'. We have mysite creation activated in our farm. We have to change one user from potato to orange. The user domain is not in the mysite url of the user. We have http:\\...\personal\fLastName. Questions: 1- How can I change potato\fLastName to orange\fLastName?    We wante to disable potato\fLastName AD account and then create orange\fLastName.     Does it impact profile AND mysite? 2- What are the impact on document history?   Will I still be able to see what potato\fLastName changed or it will show orange\fLastName? Thanks.

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?

Cannot create user: server cannot determine if it is member of a domain

  
Hi, An instance of our 2008 SP1 SQL Server is running on a computer that was removed from it's domain and then re-added. Now, when I want to create a new login in Management Studio via the nodes Security/Logins, selecting "New Login", entering DOMAIN_NAME\USER_NAME as login name and then click "Search", I get an error message (in German) "Das Programm kann das erforderliche Dialogfeld nicht öffnen, da nicht ermittelt werden kann, ob Computer "COMPUTER_NAME" einer Domäne zugeordnet ist. Schließen Sie dieses Dialogfeld, und wiederholen Sie den Vorgang". Translation: "The program cannot open the required dialog, as it cannot be determined if computer "COMPUTER_NAME" is assigned to a domain. Close this dialog, and repeat the process." But closing the dialog and repeating as suggested does not help. Even restarting the SQL Server service and re-connecting in Management Studio did not help. I keep getting this message. I found, however, that just entering the domain and user name and then clicking Ok seems to add the user. Anyway, it is irritating to get this error message when clicking "Search". How can I tell the engine that the computer is really member of the domain again? Frank

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.

People Picker gets error when selecting user from a trusted domain(one way forest trust)

  
  Hello all,   Our current setup is SharePoint 2010 Foundation server in one external forest(Trusting forest), and trying to have users in a separate internal forest(Trusted forest) access the site. The external forest's DC and SharePoint server are in a DMZ separated by a firewall with the internal forest's DC and users. A one way transitive forest trust was successfully created and has been validated. On SharePoint, we're ran the sts commands to set the setapppassword as well as the peoplepicker-searchadforests adding the domain that the SharePoint server is in, as well as the trusted forest. An iisreset was issued after running these commands. In SharePoint, we can then search for users from the trusted domain, and select the users in the Select People page, but when hitting the final Ok, an error is received: An unexpected error has occurred in which a correlation ID is provided. Reviewing the SharePoint logs we find the following: <!-- /* Font Definitions */ @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-520092929 1073786111 9 0 415 0;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-520081665 -1073717157 41 0 66047 0;} /* Style Defin
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