Category Archives: SharePoint

SharePoint 2010 Service Pack 1 (You aren’t done yet)

The engineers here at AIS have a love hate relationship with patch management. When it works, life is wonderful… when it does not work… well…

Which leads us to SharePoint 2010’s Service Pack 1 (available to download at this link). When downloaded and executed against your server, this service pack updates the binaries NOT the database. How will you know? You will notice several errors in your event log similar to this one:

The mount operation for the gatherer application [Guid goes here] has failed because the schema version of the search administration database is less then the minimum backwards compatibility schema version support for this gatherer application. The database might not have been upgraded.

So, what is happening here?
The service pack has updated the SharePoint 2010 binaries (I.E. the software is up-to-date). The service pack, however, does not run the Configuration Wizard. This means the SQL database has not yet had the necessary scripts executed to update the database schema. It seems the update is really a two step process.

So, how do I really know I need to perform additional steps
Ask SharePoint Smile

  1. Launch the SharePoint Management Shell
    Start Menu: All Programs –> Microsoft SharePoint 2010 Products –> SharePoint 2010 Management Shell
  2. Enter the following command
    (get-spserver $env:computername).NeedsUpgrade
  3. If the response is True, you server requires additional upgrade steps to be completed

So, how do I fix it?

  1. Launch the SharePoint Management Shell
    Start Menu: All Programs –> Microsoft SharePoint 2010 Products –> SharePoint 2010 Management Shell
    Important! Remember to run the management shell as an administrator
  2. Enter the following command
    psconfig -cmd upgrade -inplace b2b -wait
    NOTE: This command *must* be entered on every server in your SharePoint farm

It is recommended to run IISRESET or (our personal favorite) reboot the server.

Creating SharePoint 2010 Themes: The Quick and Painless Guide

 

SharePoint 2010 Standard and Enterprise editions support changing themes directly from the SharePoint administration pages.  These theme pages are a very powerful tool which supports updating any theme color as well as previewing your changes directly from the browser.

SharePoint 2010 Foundation edition users, however, do not have the ability to change themes directly from the browser.  While the lack of a theme editor in the Foundation edition is painful, all is not lost.  If you have PowerPoint 2010, you still have the ability to customize your portal’s themes.
NOTE: The techniques discussed in this blog entry are targeted for SharePoint 2010 Foundation users, but will work equally as well with Standard and Enterprise editions.

Prerequisites

  1. SharePoint 2010 (any edition)
  2. PowerPoint 2010
  3. You must be a site administrator within SharePoint 2010
  4. 10 minutes of your time

We suggest starting with an existing SharePoint 2010 theme rather than using one of the provided PowerPoint themes.

Step#1: Download an existing SharePoint 2010 theme for editing
NOTE: If you are creating a new theme from scratch or wish to use the PowerPoint built-in themes, please skip to Step#2: Edit the theme.

All of these steps take place within SharePoint

  1. Navigate: Site Actions –> Site Settings
    This will open the Site Settings page
  2. Locate the Site Collections Administration section within the Site Settings page.
    If you see the option “Go to top level site settings”, click it now!
  3. Now locate the Galleries section within the Site Settings page
  4. Click the Themes link to open the Theme Gallery (See image below)
    image
  5. Locate the theme you wish to use as your base theme.  Click the checkbox (I.E. check the box) located to the left of the theme you have selected.  This will open the SharePoint ribbon
  6. Click the Edit Document button within the SharePoint ribbon
  7. PowerPoint 2010 will open with the SharePoint 2010 theme loaded
    NOTE: PowerPoint can take several seconds to open

Step#2: Edit the theme

All of these steps take place within PowerPoint

  1. Click Design on the PowerPoint ribbon menu
  2. Locate and click Colors within the design ribbon
    The colors drop-down is located to the far right on the ribbon (see image below)
    image
  3. Select Create New Theme Colors (see image above)
  4. Using the Create New Theme Colors dialog, change the color palette to meet your style and branding needs
  5. Change the name to reflect the updated custom color palette
  6. Click Save on the Create New Theme Colors dialog to save the updated color palette
  7. Click File on the PowerPoint ribbon menu
  8. Select Save As
  9. Change the Save as type to “Office Theme” and save your updated theme (see image below).
    image

Step#3: Upload the theme to SharePoint

All of these steps take place within SharePoint

  1. Open the Theme Gallery. 
    (See steps 1 – 4 in Step#1: Download an existing…)
  2. Click Add new item located at the bottom of the list
  3. Browse to the theme file you created and saved from PowerPoint
  4. Complete the upload of the theme into SharePoint

 

Additional Tips
You can also update existing themes be saving your newly updated themes as the same name as an existing theme.  This will overwrite the existing theme’s colors with your new color palette.

SharePoint Alerts, External Users, and Exchange Relay

 

One of SharePoint’s nicer features is a rich alert system which supports change driven e-mail based alerts.  Configuring SharePoint and Exchange Server 2007 to e-mail alerts is relatively straight forward for internal e-mail clients (I.E. those e-mail clients which are actually hosted by your Exchange Server).  Configuration becomes much more difficult if you are attempting to alert SharePoint users at e-mail addresses which are NOT hosted on your Exchange Server.  To accomplish this feat, you must relay the e-mail.

This is where the fun begins!

The Scenario
Your e-mail address is internal@yourcompany.com.  Your SharePoint install at http://portal.yourcompany.com is setup to alert you of any changes to your document libraries.  All is well in the world!

A new user is introduced to your SharePoint user list with an e-mail address of external@hotmail.com.  This new user reports he is not receiving any alerts from SharePoint.

A quick review of the logs reveals the following error:

#160009: The e-mail address ‘external@hotmail.com’ is unknown.

Root Problem
Your exchange server is setup to disallow relaying.  Under the hood, SharePoint is receiving the following error from Exchange:

550 5.7.1 Unable to relay

Solution
Enable relaying for your SharePoint server.  Easy huh? Well… sort of.

STEP#1
Open Exchange Management Console and navigate to Server Configuration –> Hub Transport.  Find the Receive Connectors tab.  You should see something similar to the image below:

image

STEP#2
Open the Receive connector and note all of the settings on each screen.  Take good notes as you will need the settings later.
They will look similar to the images below:

imageimageimageimage
SCREEN#1              SCREEN#2              SCREEN#3               SCREEN#4

STEP#3
Remove the receive connector by right clicking on the connector and selecting Remove.
Why do we do this?  Because Exchange Server 2007 appears to process the receive connectors in the order they were created.  In the standard install, the default Receive Connector is configured to receive e-mail from ALL IP addresses.  If you add the Relay Receive Connector AFTER the default connector, it will never be processed.  You want your Relay to process first.

STEP#4
Create the relay connector

  1. Click New Receive Connector on the Action Bar located at the right of the Exchange Management Console.
  2. Name the connector, click Next.
  3. On the Local Network settings screen, modify as necessary.
    NOTE: These will normally be the same as SCREEN#2 in STEP#2 above
    Click Next
  4. On the Remote Network settings screen, remove the default settings by click the red “X”.
  5. Add in the IP address of your internal SharePoint sever.
    NOTE: If your SharePoint server is hosted on the same physical box as the Exchange Server, be sure to enter in the loop back IP address (IPv4 127.0.0.1, IPv6 ::1) as well as the actual IP address of the server.�
    Click Next
  6. Click New to create the Receive Connector, then click FinishBut wait, you are not done just yet!
  7. Right click on the newly created Received Connector and click Properties to edit the Receive Connector
  8. Select the Permission Groups tab
  9. Check the Exchange Server check box
  10. Select the Authentication tab
  11. Check the Externally Secured check box
    Make sure all other check boxes are NOT checked.
  12. Click apply to save your changes

Your new relay connector should look similar to the screenshots below
(Double click to enlarge)

imageimageimageimage
SCREEN#5                  SCREEN#6               SCREEN#7                SCREEN#8

STEP#5
Recreate the original Receive Connector using the settings noted in Step#2
Your receive connector list should now look like the following:

image

STEP#6
Validate functionality

  1. Verify you can still send e-mail.
  2. Verify you can still receive e-mail.
  3. Verify SharePoint is now sending alerts to the external e-mail.
  4. Verify you have no open relays.  This can be completed via any of the available open relay tests on the internet.