Category: SharePoint Tools

Getting authentication prompt again and again while trying to access #SharePoint 2010 Rest Interface

While trying to access to ListData.svc service in a SharePoint 2010 sub site I was getting authentication prompt to enter credentials again and again. I was using a SharePoint Farm administrator account so was sure that permission is not the cause of this problem. So I started SharePoint Manager, browsed to the sub site and saw that there was a problem in a feature

SharePoint Manager Site Feature List

Afterwards I checked in the list nodes of the same site to see which lists were included in this missing feature, after clicking on one of the lists I got the following error which hinted that this list was the one included in the feature.

SharePoint Orphaned list exception

Further in the properties window there was an error message in the content type field

SharePoint Manager List Properties

I deleted this orphaned lists and the service worked fine then.

I hope you found this post helpful. Thanks


Why AutoSPInstaller?

Let’s assume we’ve to create a new SharePoint 2010 server so we install SharePoint 2010 and then start the configuration wizard. After we’re through with the configuration wizard, most probably when we’ll start SQL Server Management Studio we’ll see something like the following

SharePoint Databases with Guids

This type of inconsistent naming can be very unpleasant and might not be very handy for our DBAs, wouldn’t it be better if we’d something like

So what we do. We can run some powershell scripts to manually configure our Farm and install services (For more details, please visit

Another good alternate is that we use AutoSPInstaller which can automate the process of installing (including downloading and installation of pre- requisites) and configuring SharePoint 2010 based on inputs we provide in an xml file. There is an editor available to edit scripts for AutoSPInstaller as well called AutoSPInstallerGUI

For detailed instructions on how to use AutoSPInstaller, please visit

Thanks for reading. I hope you found this post useful. Please don’t forget to share this post. Cheers

ULS Viewer – A very useful tool to view SharePoint 2010 logs in realtime

The ULSViewer tool performs various actions against the data from ULS log files in order to better analyze it. ULSViewer allows the user to:

  • Highlight data of importance to the user on the fly
  • Bookmark log entries
  • Append logs to other logs in order to track trends
  • Hide unimportant data
  • Only view critical log entries by sorting data by severity
  • Write rules to prompt the user when certain events occur
  • View your data in a spreadsheet instead of the text file ULS generates
  • Monitor remote machines logs that are running ULS services
  • Open multiple logs at the same time in order to compare log files.
  • Open logs files from multiple machines at the same time.

For more details and to download this tool, please visit