Thursday, November 20, 2014

The permissions in SP_DATA_ACCESS role by default.


The permissions in SP_DATA_ACCESS role by default.

The SP_DATA_ACCESS role replaces the db_owner role in SharePoint 2013.

The SP_DATA_ACCESS role is the default role for database access and should be used for all object model level access to databases.

1.   Grant EXECUTE or SELECT on all SharePoint stored procedures and functions

2.   Grant SELECT on all SharePoint tables

3.   Grant EXECUTE on User-defined type where schema is dbo

4.   Grant INSERT on AllUserDataJunctions table

5.   Grant UPDATE on Sites view

6.   Grant UPDATE on UserData view

7.   Grant UPDATE on AllUserData table

8.   Grant INSERT and DELETE on NameValuePair tables

9.   Grant create table permission 


I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Thursday, November 13, 2014

Install or Uninstall the Reporting Services Add-in for SharePoint



Install or Uninstall the Reporting Services Add-in for SharePoint (SharePoint 2010 and SharePoint 2013)


Run the installation package Microsoft SQL Server Reporting Services Add-in for SharePoint products (rsSharePoint.msi) on SharePoint servers to enable Reporting Services features within a SharePoint deployment. Features include Power View, a Report Viewer Web Part, a URL proxy endpoint, content types, and application pages so that you can create, view, and manage reports, report models, data sources and other report server content on a SharePoint site. The Reporting Services Add-in for SharePoint products is a required component for a report server that runs in SharePoint mode. The add-in can be installed from either the SQL Server 2014 setup wizard or by downloading the rsSharePoint.msi from the SQL Server 2014 feature pack

Very good article from MS.


  http://msdn.microsoft.com/en-us/library/aa905871.aspx


I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Wednesday, November 12, 2014

Restarting IIS



Restarting IIS

we must be a member of the Administrators group on the local computer to perform IIS reset. Restarting or stopping IIS is a severe action. When you restart the Internet service, all sessions connected to your Web server (including Internet, FTP, SMTP, and NNTP) are dropped. Any data Held in Web Applikation is lost

A very good article from MS.
 


I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Tuesday, November 11, 2014

Event ID 6398,6396,7037



Event ID 6398,6396,7037

Issue: The Execute method of job definition %1 (ID %2) threw an exception. More information is included below.

Solution: Check the link Below from MS which provides solution.

6398:

6396:

7037: 

 http://technet.microsoft.com/en-us/library/cc561034%28v=office.12%29.aspx


I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Monday, November 10, 2014

An error occurred in the blob cache. The exception message was: 'The system cannot find the file specified



An error occurred in the blob cache. The exception message was: 'The system cannot find the file specified. (Exception from HRESULT: 0x80070002)'.

Issue: An error occurred in the blob cache. The exception message was: 'The system cannot find the file specified. (Exception from HRESULT: 0x80070002)'. 

Description : several errors related to Blob Caching in the ULS Logs / Event Viewer
Solution : This issue has been fixed as part of December CU for SharePoint 2010. 

KB 2849971 - SharePoint Server 2010 (SharePoint server-package)

This specific issue is described in the article KB 2849989 (which is included in the above SharePoint Server hot fix package)

 

I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

ShareThis

X