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


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Asad Ali
Fauzul Azmi
Post New Web Links

Database Permissions

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :C#
 

Hello All,

I have a two server MOSS 2007 SP2 Farm; version 12.0.0.6545 (Aug 2010 Cumulative). The OS is Windows Server 2003 R2 SP2 64-bit Enterprise. I am also running Forefront for SharePoint.

The Farm is deployed in a least priviledged configuration using individual service accounts for just about everything. I also have two Shared Service Providers.

Every morning around 1:59 AM I am receiving errors like the one below (I actually receive two identical ones around the same time which I'm pretty sure has to do with having two SSPs in the environment.)

In this paticular case the stored procedure is 'proc_SecAddUser'. What I've had to do to resolve similar problems is to add the Server1$, Server2$ accounts to the SharePoint_Content and SharePoint_Admin databases, add those accounts to the WSS_Content_Application_Pools roles for each database and then apply Grant rights to that role for the given SP.

This clears up the problem for the given stored procedure in the error but the next day, at the same time, I'll get more errors telling me there are more stored procedures that cannot be executed.

Rather than doing this every day until the errors stop, I'd like to determine what process/job is responsible for the error and why there are any processes accessing the database as '


View Complete Post


More Related Resource Links

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?


Sharepoint 2010 Error "You do not have permissions to access a database"

  

Hi,

When I click a button in a form (designed by Infopath 2010,custom code included,full trust security,deployed and activated by our sharepoint admin)

An error pops out saying:

"You do not have permissions to access a database that contains data required for this form to function correctly.
An entry has been added to the Windows event log of the server.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Log ID:5566

Correlation ID:9161ac7c-7b8f-4164-907a-14426c54b24f"

How

Sharepoint 2010 Error "You do not have permissions to access a database"

  

Hi,

When I click a button in a form (designed by Infopath 2010,custom code included,full trust security,deployed and activated by our sharepoint admin)

An error pops out saying:

"You do not have permissions to access a database that contains data required for this form to function correctly.
An entry has been added to the Windows event log of the server.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Log ID:5566

Correlation ID:9161ac7c-7b8f-4164-907a-14426c54b24f"

How

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? 


Permissions on stored procedures in SharePoint_Config database getting revoked

  

Hi,

 

We are getting frequent errors in event viewer for SharePoint server. It occurs in every 1 minute interval.

 

The exact error text is as follows:

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

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

 

The steps which we have f

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

cannot open adventureworks database do not have sufficient permissions

  

i can open adventureworks on one computer but not the other i am using visual web developer

 


Database permissions required for Smo.Server.NetName

  

Hi all,

who can explain why when i use this code:

  ServerConnection conn = ServerConnection(serverName);

  var server = new Server(conn);
  string testInstance = server.NetName

next exception is thrown:

"Caught exception in SQL Product Configuration wizard. Exception: Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: xp_regread() returned error 5, 'Access is denied.'
xp_regread() returned error 5, 'Access is denied.'
xp_regread() returned error 5, 'Access is denied.'"

user can connect using SQL management studio.

It will only work if i give user "SysAdmin" permission. Obviously it is too high of a permission to read server and db properties

Any help is much appreciated,

Serg


Database Permissions for Data Driven Web Sites

  
I currently manage SQL Servers for ecommerce web sites.  I am doing a migration to 6 (2node) clusters and want to start off with everything perfect and to the best practice.  Currently the devlopers all want the sql user for the site to have dbo on each database needed to run the site (about 4).  I want to tighten it up but without effectin the sites operation whenever uploads are requested.  I was told that Role based will work but everytime a sproc is altered i will have to redefine the role.  So  considering i do 12-20 uploads a week that will be to much to have to grant specific permissions everytime the sproc are changed.  I was also told to create a new schema on the database and grant permissions to the user for that schema.  I cant find anything that specificly talks about the best way to grant permissions to sql users for data driven web sites.  Was hoping someone here could tell me how i can achive this without taking down the site because a permission wasnt redefined after an upload.  I also need to encypt the credit card  column, currently using xp_crypt, but was thinking about removing the dependency and relying on sql; to do the encryptrion but not sure what is the best way to achive a security without slowing down the database dramaticlly becasue of the encrypt/decrypt

Multiple database support with Entity Framework

  
One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

Export Visio Database Table Names to Excel

  
If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

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.

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

Adding Rows in GridView without using a Database

  
This article describes on how to add rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in the TextBox on Button Click and retain the GridView data on post back.

Adding Multiple Columns and Rows in GridView without using a Database

  
This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

ASP.NET Database Tutorial

  
This tutorial will show you how to display data using the .NET GridView Control, ASP.NET 2.0 and VB.NET

The GridView control is a powerful tool and is simple to implement.

First, you will need to import the System.Data.SqlClient namespace.

Connestion string create any database server

  
This links important to how to create connection string to any data base sever.
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