Advancing Productivity and Operational Efficiency through Cloud Services and Apps

Changing SharePoint 2010 Managed Account Passwords with PowerShell

A SharePoint 2010 Managed Account, is essentially a Service Account whose credentials are managed by SharePoint, which can automatically change the password of the account based on a given policy / schedule. Check out the posting “Managed Accounts” in Bill Baer’s Blog for more detailed information.

While most of the configuration of managed accounts will likely take place in Central Administration, at some point you may need (or simply prefer) to change the password via PowerShell. Personally, I ran into the need, as my farm account password had been changed and the Central Administration site would not run.

I used the following PowerShell script to change the Managed Account password.

$ver = $host | select versionif ($ver.Version.Major -gt 1)  {$Host.Runspace.ThreadOptions = ReuseThread"}Add-PsSnapin Microsoft.SharePoint.PowerShellSet-location $home

$inManagedAcct = Read-Host 'Service Account'

$managedAcct = Get-SPManagedAccount $inManagedAcct

$inPass = Read-Host 'Enter Password' -AsSecureString$inPassConfirm = Read-Host'Confirm Password' -AsSecureString

Set-SPManagedAccount -Identity $managedAcct -NewPassword $inPass -ConfirmPassword $inPassConfirm -SetNewPassword

Click here to download the PS1 file. You may need to remove the first few lines that load the SharePoint PowerShell snap-in, if you intend to run the script from the “SharePoint 2010 Management Shell” console.

Outlook 2010 Cool Feature – Notification of Automatic Reply before sending out email

Yet another fantastic feature of Office 2010, more specifically Outlook. If you’ve ever spent any significant amount of time, writing an urgent e-mail to someone in your organization only to find out after hitting the “Send” that the recipient is out via an “Automatic reply”; then you’ll love this new feature.

Outlook will automatically let you know that you will receive an “Automatic reply” from the moment you specify the recipient.


Its these little details that make all the difference.

SharePoint 2010 Business Connectivity Services (BCS) – Breakdown of Authentication Modes and other Security Considerations

The Microsoft Business Connectivity Services Team Blog is quickly becoming one of my favorite SharePoint blogs. Their most recent posting, Authenticating to Your External System,  does an excellent job of breaking down the available authentication modes available.

Security is one of the most important things to consider when connecting to external systems using Business Connectivity Services, and this article is a great place to get started. Check it out at:

Office 2010 – Share / Save to SharePoint Feature

I’ve been using MS Office 2010 as my primary office productivity suite for quite some time now and have been very pleased. It’s very clear that a lot of thought was put into the products; not just focused on added functionality, but making them more intuitive, really improving the user experience. So many features come as second nature, that you don’t even realize that they are new. Until you are stuck with a workstation with a previous version of Office installed.

One such feature is the “Share” menu, with the option to “Save to SharePoint”. The following screenshot is from the MS Word 2010 Menu after creating a brand new file… complete with Recent Locations.


May not seem like much, but try living without it after you’ve had it for quite some time.

True, we’ve had “My SharePoint Sites” within the “Save File” screen in previous versions. But its never quite worked as expected… you had to explicitly be a “Member” of the site (not through an AD group), the profile import had to be working just right, after you were made a “Member” of the site it may not have shown up on your list until the following day, and a slew of other things. You could also say that we had “My Network Places”, but that required a certain level of proactivity that often times you just don’t have.

Nothing in Office 2010 was my idea… but to whoever’s idea this feature was; Thanks for keeping my experience in mind.

SharePoint Saturday Houston, May 1st 2010. Now Open for Registration

The Houston SharePoint User Group (HSPUG) is proud to present the first SharePoint Saturday event for the greater Houston area on May 1, 2010.

This event will be from 8:00 am – 6:00 pm at Norris Conference Center, 803 Town & Country Lane, Houston, TX 77024.  713-590-0950.  We will provide a continental breakfast, break refreshments and hot lunch.  Parking is free in the parking garage (adjacent to Norris and Studio Movie Grill) in the 3rd level and above.  Enter Norris on the third level from the south end of the parking garage.

About SharePoint Saturday:  Whether you are a IT professional, professional, business owner, manager or enthusiast, SharePoint Saturday is an educational, informative & lively day filled with sessions from respected SharePoint professionals & MVPs, covering a wide variety of SharePoint-orientated topics. SharePoint Saturday is FREE, open to the public and is your local chance to immerse yourself in SharePoint!

Seats are limited so, register today!

digg_url = “”;digg_title = “SharePoint Saturday Houston, May 1st 2010. Now Open for Registration”;digg_bgcolor = “#FFFFFF”;digg_skin = “compact”;digg_url = undefined;digg_title = undefined;digg_bgcolor = undefined;digg_skin = undefined;

BCS External List Error – Unable to Display this Web Part; Target Application Not Found.

There is a good chance you’ll run into this error now and again when working with BCS Business Connectivity Services and External Lists:

Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator.

Correlation ID:{correlation GUID}

If after looking for the Correlation ID in your logs you find the following error:

The Microsoft Secure Store Service application Secure Store Service failed to retrieve credentials. The error returned was ‘Target application not found (application id: {SecuredStoreApplicationID}).’

It may be an indication that you’ve not established an association between the Secured Store Service Application and your Web Application.

To check your associations go to Central Administration > Application Management and click on “Manage Service Application Associations”


Look in the “Applications Proxies” Column for your Secured Store Service Application


Keep in mind that you may have configured more than one Secure Store Service Application, and even if one is listed, it may be the wrong one; in which case you’ll need to change the association. You can change the association by changing the default Application Proxy Group, (clicking on the “default” link,) but beware that this would change it for all of the default associations. Alternatively you could create custom associations for your Web Application. But the better alternative (if a “default” Secured Store has already been established) might just be to re-create the Target Application in the “default” Secured Store.

What’s my SharePoint 2010 Content Database ID?

There are several commands that may require you to pass in a SharePoint Content Database ID. PowerShell makes it easy, just use the Get-SPContentDatabase command.

Pass in the WebApplication Parameter to get a list of all of your Content Databases for that Web Application:


Need to know the Content Database of a specific site (web)? Just pass in the site parameter:


For a complete list of SharePoint 2010 Content Database Powershell cmdlets go to

digg_url = “”;digg_title = “What’s my SharePoint 2010 Content Database ID?”;digg_bgcolor = “#FFFFFF”;digg_skin = “compact”;digg_url = undefined;digg_title = undefined;digg_bgcolor = undefined;digg_skin = undefined;

SharePoint 2010 BCS – SharePoint Tech Dive Today at CTREC Hilton

Join us this afternoon March 16th at 6:30 at the C-TREC HILTON IT Academy, where we’ll discuss Business Connectivity Services and the Secured Store Service in SharePoint 2010. Go to for more information.

(BCS) Business Connectivity Services Team Blog

Looking for a good source of technical information on SharePoint 2010 Business Connectivity Services. Check out the Business Connectivity Services Team blog at 

digg_url = “”;digg_title = “(BCS) Business Connectivity Services Team Blog”;digg_bgcolor = “#FFFFFF”;digg_skin = “compact”;digg_url = undefined;digg_title = undefined;digg_bgcolor = undefined;digg_skin = undefined;

Create a free website or blog at

Up ↑

%d bloggers like this: