Archive for December, 2012

How to change the default home page in SharePoint 2007 or 2010

December 31, 2012

Below are four ways to set another page as your home page: (all four work for both 2007 and 2010)

  • From Site Settings (If the publishing features are enabled)
  • From SharePoint Designer
  • From code / API
  • From PowerShell

The first two can be used by Site Owners, the second two can only be used for developers and administrators.

Site Settings (if the publishing features are enabled for a site):

Site Actions, Site Settings, Welcome Page

SharePoint Designer:

Right-click the new page and click “Set as Home Page”.  (For SharePoint 2007 this only appears to work from SharePoint Designer if the file is in the root of the site. I.e. the same place as default.aspx.)


C# and VB developers can use the SPFolder.WelcomePage property. See:


for SharePoint 2010:

$site = Get-SPSite http://yourserver/sites/yoursite

$web = $site.RootWeb   (or $web = $site.OpenWeb(“yoursubsite”)

$folder = $web.RootFolder $folder.WelcomePage = “SitePages/home.aspx”

(or  $folder.WelcomePage = “default.aspx”)

(or  $folder.WelcomePage = “Shared%20Documents/mycustomwebpartpage.aspx”)




for SharePoint 2007 (the first two lines are different):


$site = New-Object Microsoft.SharePoint.SPSite(“http://yourserver/sites/yoursite“)

$web = $site.RootWeb

(or $web = $site.OpenWeb(“yoursubsite”)

$folder = $web.RootFolder $folder.WelcomePage = “SitePages/home.aspx”

(or  $folder.WelcomePage = “default.aspx”)

(or  $folder.WelcomePage = “Shared%20Documents/mycustomwebpartpage.aspx”)


$web.Dispose() $site.Dispose()


CRM 2011 Timeouts and Limits

December 29, 2012



Charts not displaying in CRM 2011 – “There was an error while retreiving the data from Microsoft Dynamics CRM”

December 27, 2012

The limit is 50,000 records and hence the error. You can change this limit at the following locations:

on server – Change the value of AggregateQueryRecordLimit row in DeploymentProperties table in ConfigDB.

on client (offline outlook client) – Change the value of registry key HKCU\Software\Microsoft\MSCRMClient\AggregateQueryRecordLimit

How to change organization and database name in MS Dynamics CRM 4.0 and 2011

December 24, 2012

You can easily change the display name of an CRM 4.0 and 2011 organization by disabling the organization in the Deployment manager and then edit the organization display name property. But changing the display name does not change the server url or database name.

Here’s how to:

  1. From CRM Deployment Manager
    1. Disable the organization.
    2. Select Edit Organization and change the Display name to <NewName>.
    3. Delete the organization.
  2. From SQL Server Management Studio
    1. To prevent the database being locked, take the organization datbase offline (Tasks –> Take offline) then bring it back online (Tasks –> Bring online).
    2. Rename the database to the new name
      1. Newname_MSCRM.
  3. From CRM Deployment Manager
    1. Choose import organization and select the newly renamed database. Follow the wizard and your done!

Error “Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON” how to resolve in SharePoint 2010 BCS

December 20, 2012

Here are the steps to resolve BCS (SharePoint 2010) Error “Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON”:

Open Powershell (Run as Administrator) and type the following lines:

$bdc = Get-SPServiceApplication | where {$_ -match “Business Data Connectivity Service”}

$bdc.RevertToSelfAllowed = $true


Once above is done, Open the External Content Type in SharePoint Designer 2010 and Click on Edit Connection Properties.

Once the Edit Connection Properties dialog opens, ensure that you have selected the “BDC Identity” value for the Authentication Mode property.
Go Back to the External Content Type read screen in your SharePoint site and hold your Ctrl key and click the refresh button on your browser.
The error “Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON” should now get resolved and you should see results displayed from yor Line of Business.

How to change default Organization in MS Dynamics CRM 2011

December 18, 2012

1. Go to SQL Server where MS Dynamics CRM 2011 installed

2. Use MSCRM_CONFIG   Select * from organization   You can find the list of organization in your CRM.

3. Find the User’s Systemuserid

Or   You can also find the user GUID using this query:   Use Your_Organization_MSCRM   Select systemuserid from systemuserbase where domainname = ‘domain\user’   systemuserid = <6893E7A3-62B8-E011-AA60-000C292CBBE1>

4. Find the User’s ID:   Use MSCRM_CONFIG   Select userid from systemuserorganizations where crmuserid = <6893E7A3-62B8-E011-AA60-000C292CBBE1>   User ID <E0437EA7-9B8B-E011-9245-000C292CBBE1>   5. Find the appropriate user in the systemuser table

Select * from systemuser where id = ‘E0437EA7-9B8B-E011-9245-000C292CBBE1’   Update the systemuser table to reflect the desired defaultorganizationid

6. Use MSCRM_CONFIG   Update SystemUser set DefaultOrganizationId = ‘6893E7A3-62B8-E011-AA60-000C292CBBE1’   Where id = ‘E0437EA7-9B8B-E011-9245-000C292CBBE1’

7. Run IISRESET and access the MS Dynamics CRM 2011

Free PowerShell Scripts for SharePoint

December 16, 2012

Simplify SharePoint administration tasks with 15 free scripts to automate daily tasks.

Written by subject matter experts, these scripts for SharePoint will fast forward your PowerShell experience.
  • IMPORT-SPSITE: Imports a site from a backup file
  • ADD-SPUSER: Adds a new user to a group in SharePoint
  • REMOVE-SPSITE: Removes a site from the site collection
  • SET-SPITEM: Modifies a list item
  • DISPLAY-SPLIST: Displays all lists
Plus! This script library includes over 60 additional scripts for SQL Server, Active Directory and Exchange


SharePoint performance monitor v2.5

December 14, 2012

Free and easy Sharepoint performance monitoring

  • NEW!: Watches SharePoint’s disk space and disk operation speed
  • Monitors SharePoint performance in real-time
  • Easy to read graphical console
  • Sends email alerts when issues arise
  • Runs in your system tray


SharePoint admin toolset v3.1

December 12, 2012

Simplify and streamline day-to-day SharePoint administration tasks

  • 7 essential tools for monitoring, securing and administering SharePoint
  • Reduces administrative activities from hours to minutes
  • Performs key tasks without the need for deep SharePoint expertise
  • Dramatically enhances site performance
  • Shows what can be accessed by whom in seconds


PINs, secure passwords manager

December 10, 2012

PINs is a free feature-rich Windows program for safe and comfortable storing of any secure information like passwords, accounts, PINs etc. PINs uses a secure 448 bit Blowfish algorithm to ensure the data are not crackable. The password used for securing access to stored data is not saved anywhere.
PINs does not require installation and does not need any special dlls, drivers or system files which can mess up your system. This means that PINs can run directly from floppy – including data files – without installing anything. This is extremely useful if you wish to easily access your data on other computers as well.

  • Secure 448 bit Blowfish encoding.
  • Unlimited number of entries and data files.
  • A clear tree-like data organization which allows logical grouping of systems and accounts.
  • Automated login into Internet services (SuperPaste).
  • A powerful random passwords generator.
  • Safe files wiping using Gutmann, DoD and custom methods.
  • Embedded hyperlinks launching.
  • Unlimited in size, multi-line descriptions.
  • A flexible data import/export in text format.
  • Multiple user accounts on a single PC.
  • Accounts sorting using any column as a sort criteria.
  • Comfortable accounts adding, editing, and deleting.
  • Compatibility with popular clipboard extenders.
  • Passwords masking.
  • Copy logins and passwords to the Windows clipboard.
  • Find/find next functions.
  • Expired passwords tracking.
  • Running from a floppy without saving settings to registry.
  • Multilingual versions.
  • Full source code available.
  • And more…

v.4.50 as Setup (recommended): site 1, site2 (689 KB)
v.4.50 as ZIP file: site 1, site 2 (689 KB) Be sure to unpack internal “Lang” subfolder!
Up-to-date languages pack:  (174 KB, 25 Mar 2003)