Solved

Sharepoint 2013 and SQL 2012 Database Permissions Issue

Posted on 2013-11-13
1
3,857 Views
Last Modified: 2013-11-17
I am new to sharepoint and sql 2012.  Can someone provide detailed steps to resolve this event?

Insufficient SQL database permissions for user 'Name: domain\spSearch SID: S-1-5-21-1227117664-790312197-621696214-18376 ImpersonationLevel: None' in database 'SharePoint_Config' on SQL Server instance 'sp2013\sharepointsql'. Additional error information from SQL Server is included below.

The EXECUTE permission was denied on the object 'proc_GetTimerRunningJobs', database 'SharePoint_Config', schema 'dbo'.
0
Comment
Question by:ohmErnie
1 Comment
 
LVL 13

Accepted Solution

by:
Yagya Shree earned 500 total points
ID: 39647229
Check these posts

EXECUTE permission denied on SharePoint Config DB
http://adammcewen.wordpress.com/2013/03/01/execute-permission-denied-on-sharepoint-config-db/

Insufficient SQL Server database permissions - Event 5214 (SharePoint 2010 Products)
http://technet.microsoft.com/en-us/library/ee513067(v=office.14).aspx
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now