Monthly Archives: August 2014

Enable SharePoint 2013 Integrated SSRS To Send Email Alerts

SQL Server Reporting Services (SSRS), when integrated into SharePoint 2013 enables reports to be sent to users via email.  From the report click Manage Subscriptions.

SharePointSSRS1On the following screen click Add Subscription.  You can configure the report options and click OK to save.

SharePoint SSRS2

If you’ve not configured SSRS you may receive an error in the Application Event log on the SharePoint server hosting the SSRS service application.  This could take the form:

The Report Server Email extension failed to read its configuration settings from the rsreportserver.config configuration file. The extension is not available to users. (Application: SQL Server Reporting Services Service Application, CorrelationId: …)

The web page may also fail to load, with an error like the one below.

SharePoint SSRS3

If you encounter this error, open the SQL Server Reporting Services Service Application from Central Administration.  Next, open e-mail settings and configure the SMTP server.  Finally, open Provision subscriptions and alerts, enter the appropriate account details and click Ok.

SharePoint SSRS4

SharePoint 2013 Error User Settings Not Initialized

Following a migration to SharePoint 2013, one user had the error whereby every time they loaded SharePoint they were confronted with the error “Error: User Settings Not Initialized”.

UserSettingsError1

In order to fix the error, open the User Profile Service Application from Central Administration.  Next, click on Manage User Profiles and search for the affected user.  Choose Edit My Profile.

UserSettingsError2

Scroll down to the bottom of the profile screen and select Always use my personal settings and select the appropriate locale.  Next, tick Use language and regional settings.  Click save and close.

UserSettingsError3

The error should now have been resolved.  You can go back into the user profile and reset the two options you just changed.

Enable Searching For SharePoint 2013 Asset Library Items Using Keywords

Within SharePoint 2013 you have the ability to create an Asset Library.  This is a special type of SharePoint library, which is optimised for the storing of image, audio, or video files.  If you’re not familiar with this type of library take a look at this TechNet article.

One of the nice features of the Asset Library is the keywords column.  This enables you to assign metadata in the form of keywords, which can help with the discovery of library items using search.  For example, an image of an car could have the keywords transport or vehicle assigned to it.  Then, if a user searched for car, transport, or vehicle they would find the image.

I’m going to show the configuration required to enable searching for items using keywords.  Firstly, open the Asset Library settings and check the name of the keywords column.

AssetLibraryKeywordSearch

Next, navigate to Central Administration and open the Search Service Application from Application Management > Manage service applications.  Open the Search Schema.

AssetLibraryKeywordSearch2

Click on Crawled Properties and enter keywords, then click the green arrow to search.

AssetLibraryKeywordSearch4

Click on the managed property called Keywords.  On the page that loads, tick the Searchable box and click Ok to save the changes.  Now, re-index the Asset Library, open the library settings, then Advanced settings.

AssetLibraryKeywordSearch5

Once the crawl has completed you’ll be able to search for images using keywords.