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


Top 5 Contributors of the Month
SP
satyapriyanayak
Subhransu Sekhar Jena
abhays
DotnetUser
Post New Web Links

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

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

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?




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

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


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.


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.

you do not have permission to do this operation. Whenever I try to edit a page in sharepoint designe

  

Hi There,

I keep getting the error message "you do not have permission to do this operation" in  sharepoint designer 2007 (WSS 3.0), whenever I try to edit a page in Sharepoint Designer.

I am a farm admin, site collection admin and site admin, after the error message I can click OK and enter the Administrator password which has the same priviliges as me and it thinks about it for 5 minutes then returns the same error, eventually after several hours it will allow me to save changes but it's about a 1 in 20 chance.

As it does save sometimes it would appear to me that somehow it is losing the connection or temporarily losing the credentials. Does anybody have a clue where I can start to find out a solution to this problem. I get the feeling that something is corrupted somewhere but I don't what to look for and where.

Any help, tips, ideas gratefully received.

Thanks in advance.

 


SQL User Permission (No answer found by searching)

  
Hello all!   I'm hoping someone will be able to answer my simple question!   Previously, I've run the below script to give one user access to their db in SQL management studio but nothing else. use [someDB] -- use the real db name go sp_changedbowner 'theUser' -- use the new username go 4. Next, deny the new user "public" access to ALL databases: use master go deny VIEW any DATABASE to theUser go   However I now need to add an additional user with view on permissions to the database and can't figure out how to do it. I'm sure it's simple but my SQL knowledge is at a low level.   Many thanks, Lee.

Restored copy of DB gives bizarre DENY permission to a dbo user

  
We took a backup of our PROD database and restored it in our Integration testing environment, and ran a script to alter the schema from the current PROD schema to the new schema we wanted to test in Integration testing. This same script has worked fine in two other environments and exhibited no issues. However, on our SQL cluster in the Integration testing environment, the script (which is hundreds of lines long and performs numerous things that require you to be dbo to do) fails on one line, a basic UPDATE statement on a single table.  The table has no deny permissions, and only has explicit grant permissions for the Application Role that accesses it.  Other users who are dbo can UPDATE the table.  I can UPDATE all other tables and do everything else a dbo should be able to do.  On every other SQL instance we have tried this on, it works. For some reason, this error only occurs specifically on this one instance of SQL, with my specific user, and this specific table.  I am baffled as to what could be going on, but need to get this repaired to bring our Integration testing environment back on line. What could be causing this?The Pragmatic TSQL Programmer

WCF Tracing Error: An operation was attempted on a nonexistent network connection

  
I setup WCF service tracing because 1 client out of about 30 wasn't able to finish the connection to the server. After setting up test case on that client, the WCF trace report gave me these exceptions:     An operation was attempted on a nonexistent network connection and then     The I/O operation has been aborted because of either a thread exit or an application request I found this MSDN question and solution that applies to Windows 2000 Server and Terminal Services and offers a hotfix to fix the issue. I'm using Windows 2003 Server, so the hotfix doesn't apply to me. Does anyone know what is happening to this 1 client while the other 29 connect just fine? The client returns this exception when trying to open the connection to the server:     An error occurred while receiving the HTTP response to http://endpointaddress/. This could be due to the service endpoint binding not using the HTTP protocol. This could also be due to an HTTP request context being aborted by the server (possibly due to the service shutting down). See server logs for more details.

user permission in granula level in SharePoint version 2

  
Hi, everyone:   I am administrator of a SharePoint v2 site. I found that I can either give "view item" or "view item, insert item, remove item and update item" permission to users, no middle. However, I do wish to give some users "view, edit" permission, but no "insert and remove item" permission.   So, does SharePoint v2 support this in out of box feature? if yes, how to make it, if no how can we achieve in easiest way?   Thank u MySTfrom Finland :D

Errors attempting to process SSAS Cube. I get Either user does not have permission to create a new o

  
Hi All, One of my production server deployed cubes i am not able to process the cube.When i tried to process the cubes i will get an Error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Either the 'NA\gsad478' user does not have permission to create a new object in 'JNJAUSYSVR01', or the object does not exist.  (Microsoft.AnalysisServices)   Over the source server i do have sysadmin access and also  i have added read only role of particular cube. I right click on the database and tried to create new database of SSAS that also thrown with same error. Please help me in this regard.   Thanks, Gangadhar

limitate user permission to edit other users documents

  
i have a list where everybody uploads documents, but i want that only the user that uploaded the document can edit it or delete it, is there a simple way without workflows or code? thanks!

User permission error

  
I have a VS 2010 website that is reading and writing to a SQL Server 2008 filestream. By filestream, I mean that I have a table in a SQL Server 2008 database that is configured for filestreaming (ie - the table has a RowGuid column and a varbinary(MAX) column that is filestream enabled). The website is able to read and write to the filestream just fine and has been doing so for months now. However, there is one minor detail about using the filestream that has plagued me since the beginning, and were it not for a hack - at least I consider it to be one - then my filestreaming would not work. The problem is that for some reason when my website makes a connection to the filestream (via the .NET SqlFileStream class) it always attempts to authenticate with the name of the webserver.For example, I have a brand new web server called WebSrvPrd01 that I just placed my website on (the one that is using the filestream). When I try to do anything that uses the filestream (either writing or reading to) it throws the following exception:Login failed for user 'SUPER-NT\WebSrvPrd01$'.At this point, I then have to go into SQL Server and add the domain and user SUPER-NT\WebSrvPrd01$ to the database and give them access rights accordingly. After having done so the website will have no problems and the filestream works wonderfully. However, I don't like this solution! It presents a bit

User Profile Synchronization Connection disappeared

  
So I had finally got User Profile Synchronization working by going down the path of using the Domain Admin Active Directory account for everything (SQL service account, SharePoint Farm account, Setup account) and the User Profiles worked based on the walk through I created on SharePointAdminWiki.com.  But now, the User Profile Synchronization Connection has disappeared from the list...and if I click Create to try and recreate it I get this error: "Cannot navigate to the requested page while User Profile Synchronization is running. Please wait for the current Synchronization run to finish." There are no jobs running, and I've left it for a while and still no joy. I even tried restarting the server and still nothing! I've tried this with a Windows Server 2008 SP1 build server AND a Windows Server 2008 R2 server. I have read @jiel's and David Pae's advice on this. Are User Profiles just well and truly broken in the Public Beta? SharePoint Solution Architect, Perth Australia - MCTS WSS Dev, WSS Adm, MOSS Dev, MOSS Adm - Readify - http://wss.made4the.net/- http://www.sharepointdevwiki.com/

User Profile Service Synchronization Connection: Client Timout

  
Hi, I have scenario on configuring User Profile Synchronization service on customer site as below. Window AD Server 2003 Domain NetBIOS: foo FDQN: foo.bar.com  User Account to connect: foo\ad-connect This account already set permission as describe in http://technet.microsoft.com/en-us/library/ee721049.aspx  when I try to create connection, system took long time to process then return error as "Client Timeout". I try to check FIM and it's seems to work fine (no error return and can get users data). So could anyone told me what's wrong? Since I've didn't have much knowledge on Network and AD, please advice.Theeraphat.P SharePoint Information Worker
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