Thursday, October 24, 2013

Path for the Host File

I posted this very simple, because many times when I work on SharePoint. I forgot the path for Host Entry to check .So, Useful for the Bees who are same like me some times!!!!

Path : C:\Windows\System32\Drivers\etc\hosts

Post Setup(PSConfig)Configuration of SharePoint Products and Technologies failed

While Running PSconfig, Its failed in Any step.

Please follow the below Steps to fix the issue.

 Fix 1:

Copy the web.config file from: C:\ProgramFiles\CommonFiles\MicrosoftShared\WebServer         Extensions\12\CONFIG To: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\LAYOUTS.

  Then run: psconfig -cmd upgrade -inplace b2b –wait  –force 

Upon re-running the configuration wizard via command line, my upgraded succeeded and returned. Run the PSConfig Wizard and check for Success of it.

Note: Delete web.config from C:\ProgramFiles\CommonFiles\MicrosoftShared\WebServer Extensions\12\TEMPLATE\LAYOUTS.

    Fix2 :

Rename the DSN in the registry to DSN.old

Path :HKLM > Software > Microsoft > Shared Tools > Web Server extensions > 12 > Secure > ConfigDB > DSN

Note: The path For SharePoint 2010 is below

Path :HKLM > Software > Microsoft > Shared Tools > Web Server extensions > 14.0 > Secure > ConfigDB > DSN

Once the DSN is renamed, Run the PSCONFIG Wizard again.

Note: Please consider the customizations while running this step in Production.

Execution policy Error Running Scripts Within Windows Power Shell

 Error While Running the Script In Power shell

Cause: The execution policy is determined by execution policies that you set by using Set-ExecutionPolicy and the Group Policy settings for the Windows PowerShell execution policy. The default
value is "Restricted."

Resolution: Run the below command to Run\Execute the command in power shell.

This command gets the current execution policy for the computer.

·  Get-ExecutionPolicy

These commands set a new user preference for the execution policy and then display the effective execution policy

·  Set-ExecutionPolicy RemoteSigned

Unknown Error Trying To Lock File

Unknown Error Trying To Lock File

An error screen while try to edit Office 2007 documents uploaded in SharePoint Document library
Unknown Error Trying To Lock File

This is mostly related to operating system and already been fixed in SP1, though sometimes we have to modify below registry settings.


Locate to the below path in Registry.

On the Edit menu, point to New, and then click Multi-String Value.
Type AuthForwardServerList, and then press ENTER.
On the Edit menu, click Modify.
In the Value date box, type the URL of the server that hosts the Web share, and then click OK.
Exit Registry Editor.

Unable to Select the ZIP files when we select upload multiple documents option

When I work on My Test Lab, I got the issue that not able to select the ZIP files. Thought to share this to someone who is looking for the same.


ZIP files do not appear when we select upload multiple documents option.
For some odd reason, we can’t see our zip files when choose “Upload Multiple Documents”  


Microsoft KB suggests that it is a design behavior with windows vista machines and needs registry modifications to fix it completely.

Fix Suggested:

To fix this problem you need to delete the following registry keys. 


To take a back up of User Profile Service application using SQL Server in SharePoint 2010

Follow the below steps to take the back up of the user profile synchronization.

·         Open SQL Server Management Studio
·         Connect to the database server.
·         Expand Databases.
·         Right-click the database that you want to back up, point to Tasks
·         Then click Back Up.
·         In the Back up Database dialog box,
·         In the Source area, select the backup type that you want to perform
·         User Profile Service application always requires a full backup, so select Full backup
·         In the Backup component area, click Database.
·         Provide the name to the backup
·         We can set an expiration date to make this back up available till desired date.
·         By default its 0, means no expiration date
·         Provide the path where you want to store this back up under Destination
·         That’s it we are done with user profile backup

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

To export a site, list or document library in SharePoint Server 2010

  Follow below steps to export a site, list, or document library by using Central Administration 2010

·          In Central Administration, on the Home page > Backup and Restore.

·          On the Backup and Restore page > Granular Backup > click Export a site or list.

·           On the Site or List Export page,

·            In the Site Collection section, select the site collection from the Site Collection list, and then select the site from the Site list.

·            If you are exporting a list, skip this step, Select the list or document library from the List list.

·            In the File Location section,

·           In the Filename box, type the UNC path of the shared folder and the file to which you want to export the list or document library.

·           The file name must use the .cmp extension.

·            If the file already exists and you want to use this file, select the Overwrite existing files check box.

·           Otherwise, specify a different file name.

·           If you want to export all the security and permissions settings with the list or library, in the Export Full Security section, select the Export full security check box.

·            If you want to specify which version of the list or library to export, select one of the following versions from the Export versions list:

·                     All Versions

·                     Last Major

·                     Current Version

·                     Last Major and Last Minor

·              Click Start Export.

·             You can view the status of all backup jobs at the top of the Granular Backup Job Status page.

·             You can view the status of the current backup job in the Content Export section of the page.

·              The status page updates every 30 seconds automatically.

·             You can manually update the status details by clicking Refresh. Backup and recovery are Timer service jobs. Therefore, it may take several seconds for the backup to start.

Detailed SharePoint Latest AUG CU 2013 Installation Guide


-          Ensure backup is already done to farm and databases.

          Download the Package from the MS path:

        Note: when you download the AUG-CU,there is a CAB file also downloads with this,Both should be in Same location to do AUG CU install.

             Step 1: Stop World Wide Web Publishing Service in all SharePoint Servers

  Perform CU installation in the following orders:
                           Central Admin server
                            Application Servers
                            Web Front End Servers

Installation Steps:

             Ø  Step 2 : Double click on the “ubersrv2010-kb2825949-fullfile-x64-glb” to start the installation.

     Ø  Step 3 : Check the “Click here to accept the Microsoft Software License Terms” and hit “Continue”


      Ø  Step 4 : A window will prompt and wait


                                          Extracting in progress, This take some time

                                 Determine the list to be updated:


                   Step 5 : please wait while the update is installed.

                               Please Click on Yes to reboot the server


                              Click OK to complete the installation.

     Ø  Step 6: 

NOTE: you may check in CA >system settings-> Manage Servers in this farm. You will see the status is now under  “Upgrade Block”

Installation Required : The server still not yet install with the same CU that already installed in other servers.
Upgrade Blocked : The server is blocked from upgrade. Server is install with latest CU and it will remained blocked until all the SP servers in the farm are installed with the same version.

   Ø  Step 7 :  Repeat Step 1 to Step 6 in other SP Servers. (App servers then follow by WFE servers)

                     NOTE: After CU is installed to all servers and rebooted. The status would change to “Upgrade Available”

  Ø  Step 8 : Run the SharePoint 2010 Products Configuration Wizard in CA server.

            Step 9 : Click “Next” to the SharePoint Products Configuration Wizard window.

   Click “Yes” to continue 
   Click “Next to Continue   
   Configuration in progress
                        Upgrade completed, click “Finish” to end.

          Step 10
: Repeat Step 8 to Step 9 other SP Servers. (App servers then follow by WFE servers)

           Step 11: Verify on the installation.
    a.       Check SP version in central admin:
                                                               i.      CA > Under “System Settings” > Select “Manage Servers in this Farms” > Ensure the version has change to “14.0.7106.5002

     b.      Check SP servers control panel:
                                                               i.      Control Panel > Programs and features > at left pane, click on “ View installed Updates” > Ensure “KB2825949” is in the list.

  c.       Check in SP power shell:
                                                               i.      Open the SharePoint 2010 power shell

                                                             ii.      Type the following:
1.       (get-spfarm).buildversion
2.       Ensure it shows something like 14 0 7106 5002

After Upgradation Completed,Check the Central Admin page and websites.                                    

Note:I prepared the steps for FARM,if its a Standalone,Some of the steps can SKIP.