sharepointking

Just another WordPress.com site

Monthly Archives: June 2010

Restrict or Lock down sharepoint webservice file ( _vti_bin), _layouts and other important files

I would like to share some idea specially for internet facing – anonymous public site. It is very very important to restrict anonymous user to restrict to access web service of your site and access files located at _layouts. Also it is important to keep open few of the files from _layouts e.g. _layouts/accessdenied.aspx, _layouts/error.aspx

Solution: You can add required configuration tags into web.config file
example:

Cheer!!. Keep safe your internet facing anonymous site.

Access Denied after converting classic web application to claim based web application

I have convert classic web application to claim based web application using powershell following command

$w = Get-SPWebApplication “http://{sitename:port}/”
$w.UseClaimsAuthentication = “True”;
$w.Update()

$w.ProvisionGlobally()

then after i have tried to access my site and site started sending error “Access Denied” message
when i tried to access web site

Solution:

1. go to central admin
2. Central Administration — Application Management — change site collection administrator
now try to access your site. it should work.

Excel Services in SharePoint 2010 REST API

embedd live “chart” into your webpage especially into sharepoint webpage using REST concept.

Assume that you have one excel sheet where you have 1 chart and that chart object name is “Chart 3”. Now if you want to use this live chat out of excel sheet into sharepoint then you can prepare following URL:
note: string in following URL marked with {} needs to replace with appropriate value
http://{servername}/_vti_bin/ExcelRest.aspx/{library name}/{excel sheet with extension}/Model/Charts(‘{chart object name from excel sheet”}’)

e.g. http://sharepointking/_vti_bin/ExcelRest.aspx/Report%20Sheet/myquarterlysales.xlsx/Model/Charts(‘3’)