.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

Insufficient SQL database permissions for user '' Event ID 5214

Posted By:      Posted Date: October 01, 2010    Points: 0   Category :SharePoint
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?

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?


After DB Content upgrade/attach of a content database, user permissions are not retained


Hello, we are working on an upgrade to Sharepoint 2010 using the new farm and dbattach method for migrating the content dbs.  We have just finished successfully moving/migrating the SSP and user profiles from 2007 to 2010 and have started on the content databases. The sites upgrade and move over okay and accept the visual upgrade okay. But users do not have the permissions they should have. If you look in the People and Groups area, everyone is listed there as they are supposed to be, but they are not able to add documents for example even if they are in the owners group. 

Is there something else you have to do to get the permissions to move over correctly to the new farm? 

Insufficient SQL database permissions


Insufficient SQL database permissions for user 'Name: \spservice SID: S-1-5-21-2034437564-512043800-329795256-22165 ImpersonationLevel: None' in database 'SharePoint_Config' on SQL Server instance 'spprod'. Additional error information from SQL Server is included below.

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

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

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

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

Thanks, Sam

MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

Linq - add data to database then email user the details


Hi all

I'm not sure how to structure the code for this but what I want to do is be able to add data to a database, and once this has completed successfully, then email the user to say the details have been added successfully to the database.

I need to:

1. Check that the relevant data has been added into the database then

2. Email the details of the relevant data when completed. 


Thanks in advance for your help,




update user status in database when ever user logoff


actually i came across this senario for new project where userstatus must change to log off when ever he do fallowing activity.I have maintain user status when he log in to web based system.

Activities are


1.user click log off

2.or user click browser close button or close brwoser tab.

3.or Fource fully shut down his Pc

I am able to get first 2 but not the last one.I googled it but not get any satified ans for that.

I m looking for guidens for this. Any help is grate help for me as i want it.And also other suggesstion also welcomed.

thanks in advance


Knowing the event occured in user control in current page




      My web application has user control which uses third party controls called Devexpress controls. The user control is a menu  and is part of the Master page. It is placed there because this needs to be available in all the pages. My user controls raises a even on item clicked. Now, My question is that Is there any way to know that the event has occurred in page_load of the current page in which I am in?

want to launch modal Popup from created User Event handler




I have a create user wizard on my page and in the event handler (Created User) I get extra information from the user

via textboxes within the aspx etc.


I then do a response.redirect to another page.

What I want to happen is this


When the CreatedUser Event is fired, I  want a Modal Popup to show up with a message Processing your registration.

once the registration code is processed it will close and the users get redirected.


On my ASPX I have the Modal PopUp and a Panel.

In the code behind in the handler I put ModalPop.show()


but this does not work.


thanks for any suggestions



file upload in Create User Wizard Created User event with UpdatePanel Tag wont work?



In my Create User Wizard1 Created User Wizard Event, I am collecting extra information from text boxes and allowing

the user to uplad a file.



I have put the Submit button within an Update Panel Tag but since I have done this it does not work.

Is there a way round it. In this situation would you use a trigger.?


<br />

  <asp:UpdatePanel ID="UpdatePanel2" runat="server">

  <asp:Button ID="StepNextButton" runat="server"  CommandName="MoveNext"  align="middle"
                                            Text="Submit my Profile" />

How to fill out a form as another user , while using profiles database


I have created an InfoPath 2007 form. It works great.. I have 5 data connections to sharepoint lists and profile's database. The form displays public data (profile database) about the user, such as name, manager.. etc.

What I would like to do is have an option on the form that says " If you are not this person , click here" , manually type the persons last name , and bring up their information.

Basically , there are some people who will have someone else fill the form out for them. But I don't want them to be giving out their username and password to the system.

I want the ability to fill out a form as another user without logging off sharepoint. 

=User!UserID from windows authentication using table from another database



i'm using sql server 2005, sql server business intelligence development studio for my reports and deploy them in my wss3.0 site.

what i'm trying to do is i'm trying to restrict wich users can see specific data within a report.

now, the thing is. the report gets the data out of my DB1 database and my windows authenticated user are in the WSS_content database.

when i deploy my report in my wss3 site. it gets the user that is loged in. but of course it does not display any data because the tables are not in the same database.

does someone knows how to do this?

How to write an event to manage permissions on a document while uploading, depending on custom field



I am trying to find a solution to manage permissions on a document, while uploading it into a document library. This event has to be fired if a custom field is populated (it's a check box field).

How to write an event for this, i tried writing ItemAdded event, but this is getting fired as soon as a document is uploaded, before coming to the page, where we populate all the fields and hit check in.

can i capture Check-in event.

Please advise.


Create user is creating aspxxxx.mdf database in my app_data folder


I had already setup roles for my pages and requirements call for ability to manage and create users.

So i was looking at code that allows you to do so using membership, even though i got the page to work, it was creating a database in my app_data folder.. i already have SQLExpress setup with the asp schema, but cant figure out how to get my application to use that instead of creating the db in the folder?

What am i missing or doing wrong?

I have the following setup in my web.config file..

		<authentication mode="Windows"/>
			<deny users="?"/>
        <add name="SqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

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.

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
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