Update SharePoint 2010 Farm Credentials Using PowerShell

#Input the Managed Account
#If there is only one managed account, the following line could be written as:
#$inputManagedAcct = Get-SPManagedAccount

$inputManagedAcct = Read-Host "Enter managed account as Domain\User" 
#Input the desired new password 
$inputPasswd = Read-Host "Enter new password for managed account" –AsSecureString 
#Change the password for the managed account to the new value 
Set-SPManagedAccount -Identity $inputManagedAcct -NewPassword $inputPasswd



------------------------------------------------------------------------------------------------------------------------------------------------------------       Update after AD Reset    ----------------------------------------------------------------

#Input the Managed Account
#If there is only one managed account, the following line could be written as:
#$inputManagedAcct = Get-SPManagedAccount

$inputManagedAcct = Read-Host "Enter managed account as Domain\User:" 
#Input the Managed Account 
$inputPasswd = Read-Host "Enter password from Active Directory for managed account:" –AsSecureString 
#Change the password in SharePoint for the managed account to the new value 
Set-SPManagedAccount -Identity $inputManagedAcct -ExistingPassword $inputPasswd –UseExistingPassword $true 

Find Storage Usage of a Site Collection in SharePoint 2010

1) Go to Central Administration --> Application Management --> Configure Quota and Locks

2) View Storage Data (example: 13 MB)

Add a Visual WebPart to a SandBox Solution in SharePoint 2010

When we create a Sandbox solution we can't add Visual Web-parts to it.
But it is mandatory when we create complex scenarios.
So we have a solution powered by Microsoft. --> "Visual Studio 2010 SharePoint Power Tools"

1) First download the small patch

2) Install the package (SPPowerTools_x86)

 

3) It Installs plugin to VS 2010

4) After created a SharePoint project, we can add "Visual WebParts (Sandboxed)" to our project

5) Can program our CODE, add complex logic

6) Can add all web controls to our .ASCX file

7) Then we have, full Web controls enabled WebPart (SANDBOX)

Developer DashBoard In SharePoint 2010

1) Open Normal SharePoint Page, we can t see any dashboard item or ICON

2) Open command prompt and Change path to SharePoint 14 hive and type the command (STSADM)

 

3) OR, Open PowerShell with administrative privileges and run the PowerShell command

4) Open SharePoint page and view ICON in the top Right corner

 

5) View Data in the bottom panel of SharePoint page

*** It displays the time taken to load full page, any WebPart, render time for RIBBON and the execution time.

6) Can switch-off at any time with powershell command

SharePoint Excel file throws unable to process the request when opens

 When we open an excel on browser,

 

We have to enable settings inside Library

Then we have to create Excel Service Application using Central Administration

 

Verify whether the Excel Service Application is configured using central administration

Now we can view Excel sheet through browser

SharePoint 2010 Integration With SSRS

When we have to integrate SharePoint 2010 with SSRS, it is few steps away from the fun.

1) First we have to download and install SSRS plug-in for SharePoint 2010

2) Go to Central Administration --> General Application settings --> Reporting Services

3) Set "Report Server URL" and Account Credentials

 

4)  Verify Status of configuration

5) Go to Site Collection features  --> Activate "Reporting Server Integration Feature"

6) Go to Edit page and insert "WebPart"

7) Configure a SSRS Report and have data

That's all :)

Change FARM account in SharePoint 2010

When we have to change FARM admin account password or change the account,

We can use stsadm command (updatefarmcredentials)

in SharePoint 2010 we have all these options as precautions

Create a SandBox Solution in SharePoint 2010

1. Open VS SharePoint project and Add a WebPart (we can't add a "Visual WebPart" for a SandBox Solution)

2. Add a simple code within "CreateChildControls" method

 

build the solution, then "Package" the solution to create a ".wsp" file

3. Go to "Site Settings" --> "Solutions"

 

4. Upload the "Solution"  (.wsp file)

but "Activate" button is disabled :(

5. So go to Central Administration --> "Services on server"
Start "Microsoft SharePoint Foundation Sandboxed Code Service"

 

6.Now "Activate" the solution

 

7. Verify whether the created item is listed under "WebParts" section (Site settings)

8. Add our WebPart to a page

 
9. Deactivate "Solution" when task is done / no longer needed

10. If any case start "SharePoint 2010 User Code Host" service

If can't find the error, set CALLSTACK =TRUE in related web.config file and click "Activate" button.

SMTP Configuring in SharePoint 2010

When we need to send Emails in SharePoint 2010 environment using gmail account.

Central Administration Configuration