Thursday, November 17, 2016

List of SharePoint 2013 System Pages that you shold take care when you are going to public

There are list of SharePoint System Pages which inheriting view permision by default. If you are going to make public sharepoint site , you might not want to access these pages by anonimous users or by FormBased Authentication User.
There are may ways to restrict the users access to these pages that I will explain later in a different post.
Below Im listing down pages ; those are available in each site unter layout mapping.

Site Collection and Site Level Recycle Bin Urls

/_layouts/15/AdminRecycleBin.aspx
image
/_layouts/15/RecycleBin.aspx
 image

User , User Info , Site Permision related Urls

_layouts/15/permsetup.aspx
This is used to create default groups in SharePoint such as visitors , members and owners.
image
/_layouts/15/people.aspx?MembershipGroupId=0
All People Url , This can be even used to delete users from the site collection
image

User Information Hidden List Urls

/_catalogs/users/detail.aspx
/_catalogs/users/simple.aspx
image

These lists are actually available from previous version of sharepoints. These are hidden lists avaialble in the sharepoint containing user infomation.
/_layouts/15/userdisp.aspx?id={UserID}&Force=True
This is used to view user information in the same page without redirecting to my site.
 image

/_layouts/quiklnch.aspx
This is used to manage quick launch items in sharepoint.

image


/_layouts/15/AreaNavigationSettings.aspx
This is used to modify navigation setting in the site colletion.
image



Workflow history hidden list


/Lists/Workflow%20History/AllItems.aspx
This is hidden list for manage and view  workflow  history items.
image


Site usage page

/_layouts/15/usage.aspx
This is used to view the usage information. but nothing harmfull.
image


Site content and structure pages

/_layouts/15/sitemanager.aspx
This will bring you site management page which is available from sharepoint 2007.
image

/_layouts/vsubwebs.aspx
List of heirachy pages
image

/_layouts/15/settings.aspx
This is the site setting page that contains all administrative links.
image

/_layouts/15/viewlsts.aspx
This is used to view all site contents. List’s visibility if this page can be hidden using shareopint designer.
image
Site and Site Collection feature management links
/_layouts/15/ManageFeatures.aspx
/_layouts/15/ManageFeatures.aspx?Scope=Site
These links are used activate and deavtivate features in site and site collection.
image

SharePoint designer Settings


/_layouts/15/SharePointDesignerSettings.aspx
This is used to enable and dissable sharepoint designer settings.
image



Look and Feel Urls

/_layouts/ChangeSiteMasterPage.aspx
This is used to change site collection master pages.
 image

/_Layouts/AreaTemplateSettings.aspx
This is where user can change Page Layouts ,Site Templates and other related settings.
image

/_catalogs/masterpage/Forms/AllItems.aspx
This is main document library for update and maintain related files and master pages

 image

Sunday, October 30, 2016

SharePoint 2013 Automatically Redirects to another Mapping

 

There are multiple reason for this behavior of your sharepoint farm. exclusing all other DNS mapping and firewall and proxy configurations there might be a problem in SharePoint Access mapping that will cause the this behaviour.

Furthur descrbing the issue…

when you type http://abc.company.ae it may redirect to http://d.company .ae ; the second address also you wanted and imagine its in AAM.

This behaviour is tottaly because of Aulternate Acess mapping , where you have put abc.company.ae and d.company.ae in same default zone in Alternate Access Mapping.

so just delete one entry from Default Zone and put it to another Zone.

Monday, May 30, 2016

System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object ‘xp_sqlagent_notify’, database ‘mssqlsystemresource’, schema ‘sys’.

 

This error occured to me when im trying to access the Manage Processing Oprions in SharePoint SSRS.

image

An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. —> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. —> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object ‘xp_sqlagent_notify’, database ‘mssqlsystemresource’, schema ‘sys’.”

Cause is configurations isses and provisioning issues of Reporting Server User on Related Databases (Master , SSRS)

You can resolve the issue by re run the script on your database server.

For that you can downlod the report from the Central Admin by

Application Management  ->  Manage service applications

image

Then go to Reporting server service application

image

and clisk and download the script and execute in the database server.

image

Thursday, May 26, 2016

System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

 

This error occured to me when i triyng to connect to a SQL database from SharePoint App which is use Entity Framework.

This is a timeout issue when app is trying to connect to a SQL database and connection was expired before execution.

I simply connected it adding a Coonection Timeout to the connection string.

<add name="dbtemponeEntities" connectionString="metadata=res://*/DataModels.dbtempone.csdl|res://*/DataModels.dbtempone.ssdl|res://*/DataModels.dbtempone.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=ASQL;initial catalog=dbtempone;persist security info=True;Connection Timeout=120;user id=SQLAdmin;password=*****$so;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />