Dec 15 2009

How to Install, Configure, and Use SQL Server 2008 Reporting Services and SharePoint 2007

Category: amilsark @ 18:33

I recently published a new series of blog posts on Fpweb.net’s blog about getting started with SSRS 08 and SharePoint 2007.  Once you have setup the infrastructure for the Reporting Services and SharePoint integration, it is quite easy to build tables and bar graphs on your data in SQL using Report Builder 2.0, and display it through your SharePoint 2007 portal.  These posts are based on my first experiences with this reporting solution.  I’m also excited about the next version of SQL 2008 R2 Reporting Services and SharePoint 2010.  SQL 2008 R2 has new spatial data types which allow you to store data like latitude and longitude within SQL.  Then you can use Report Builder 3.0 and Reporting Services to build a map view of the data.  This would be useful in a number of scenarios and extends the vast amount of solutions you can build on top of SharePoint.


Please visit my articles on the Fpweb.net blog:

Series – Surfacing Company Data with SharePoint and SSRS

Part 1 – It’s Time to Work Your SharePoint Ninja Magic

Part 2 – Configuring the Report Server

Part 3 – Configuring SSRS Add-In on the SharePoint Web Servers

Part 4 – Building a SQL Server Report Using Report Builder 2.0

 

Thank you for following!

Tags: , , , ,

Oct 20 2009

SharePoint 2010 Service Applications (Shared Services) Overview

Category: amilsark @ 17:04

In the new service infrastructure powering SharePoint 2010, there are some significant changes and additions.

For starters these services are now called Service Applications and there is no Shared Services Provider (SSP).  Certain service instances can now be used across farms!

 

Configuration Flexibility

Web applications can be configured to only use a subset of the deployed services.

You can deploy multiple instances of the same service in a farm by giving the new service instances unique names.

You can share services across multiple web applications in a farm.

Services Can Even Be Shared Across Farms

Certain services that support sharing instances across farms can be run on a central farm in your company’s WAN and allow you to manage that service in one place.  A good example of this might be the User Profile Import service.  If your LOB system is located in one regional office you can run a specific instance of the Business Connectivity service for communication with that system locally and consume that data from other locations.

Service Application Architecture

These applications are deployed to IIS in a single web site (“SharePoint" Web Services”).  It is recommended to run this web site under one application pool for optimal performance.

Deploying Services

There are 3 ways to deploy services:

1. Selecting services when running the configuration wizard

2. Adding services through the Manage Service Applications page in Central Administration

3. Use power shell (replaces STSADM command line)

Service Descriptions

Service App Description Data Store Cross Farm SharePoint Foundation 2010 SharePoint Server 2010 Standard SharePoint Server 2010 Enterprise
Access Services View/Edit/Interact with Access 2010 DB’s in the browser Cache       X
Business Data Connectivity Access LOB data DB x x x x
Excel Services View/Edit/Interact with Excel 2010 files Cache       X
Managed Metadata Service Access managed taxonomy hierarchies, keywords, and social tagging infrastructure as well as Content Type publishing across site collections DB x   x x
PerformancePoint Provides the capabilities of PerformancePoint Services Cache       x
PowerPoint View/Edit/Broadcast PowerPoint presentations in a web browser Cache       x
Search Crawls content, produces index partitions, serves search queries DB x   x x
Secure Store Services Provides single sign-on authentication to access multiple applications or services DB x   x x
State Service Provides Temporary Storage of user session data for SharePoint Server components DB     x x
Usage and Health Data Collection Collects farm wide usage and health data and provides the ability to view various reports DB   x x x
User Profile Adds support for My Sites, Profile pages, Social Tagging, and other social computing features DB x   x x
Visio Graphics Service Viewing and refreshing of Visio diagrams in the browser BLOB cache       x
Web Analytics Provides Web Service interfaces   x      
Word Automation Services Performs automated bulk document conversions Cache       x
Microsoft SharePoint Foundation Subscription Settings Service Tracks subscription ID’s and settings for services that are deployed in partitioned mode.  Windows Powershell only DB   x x x
Office Web Apps (Separate SKU)            
Word 2010 Viewing, PowerPoint 2010, Excel Services in SharePoint Server 2010, OneNote 2010 Allows you to create and collaborate with Office documents through the browser.   These documents are no different than creating them in the client applications.          

 

One question i have:  Is there still search functionality in SharePoint Foundation 2010?  I’m assuming the Search Service above refers to the MOSS Indexing style with crawl schedules and such.

Tags: , ,

Oct 19 2009

New SharePoint 2010 Documentation Released!

Category: amilsark @ 19:45

Today with the kickoff to SharePoint Conference 2009, Microsoft has released a lot of new documentation.

There are many exciting features and improvements with this release!

Also exciting is that a public beta will be available in November!

 

MSDN: http://msdn.microsoft.com/en-us/library/dd776256.aspx

Microsoft Download Center: http://www.microsoft.com/downloads/en/results.aspx?pocId=&freetext=sharepoint%202010&DisplayLang=en

 

I will be blogging about my experiences with SharePoint 2010 in the coming months.

Tags: , , ,

Aug 21 2009

SharePoint Search and the DisableLoopbackCheck Workaround

Category: amilsark @ 16:10

Problem

If you are seeing 401.1 unauthorized event log entries by the SharePoint Gatherer in your event log, this article may be what you've been googling for.

Are you able to browse to your sharepoint site from the server logged in as the search crawling account?  No luck?  Keep reading.

Reason

With the Windows Server 2003 SP1 ( or possibly just the .Net Framework 3.5 SP1), Microsoft introduced a new security feature that checks for loopbacks (making calls to web applications locally from thet server).  If your search service is running on the same server that is hosting your web applications (which is best practice for indexing speed), you'll most likely recieve this unauthorized error.  You may also see this error for any custom applications which use the SharePiont web services locally. This security fix is meant to block malicious applications from infultrating your web sites from within, which is a good fix in my opinion.

How to I get around this 401 unauthorized then?

Microsoft recommends two fixes.  Both of them are registry modifications.

One turns off the Loopback check altogether which shouldn't be done on external facing production servers for obvious reasons.  The other is to specify the sites that allow loopback from the server.

Here's the instructions for the registry modifications required for both methods:

MS KB Article 896861

Tags: , , ,

Aug 21 2009

WSS 3.0 SharePoint Search Troubleshooting - Common issues

Category: amilsark @ 15:30

Microsoft SharePoint (WSS 3.0) search is probably one of the most common points of failure and source of support tickets for our customers.

Here are some of the major points to check when troubleshooting this service.

1. Make sure the content database is assigned an indexer.

      Open SharePoint Central Administration > Application Management > Content Databases

      Select your web application if it is not already selected.

      Click on the content database. 

      Make sure that the Search Server dropdown has the servername selected which is running the WSS Search Service.

 

2. Make sure you have implemented the DisableLoopbackCheck registry entry.

     Check out this blog post.

3. Make sure your search service is running as a domain account and that the account credentials were entered correctly (with DOMAIN\serviceaccount) in Central Administration.

4. Make sure your alternate access mappings in the default zone are accessible from the server.

5. If using forms authentication, use windows authentication in the default zone, and then extend the web application to the internet zone which uses forms. 

6. If pdf files are not being indexed correctly on 64bit systems, there may be a registry entry that you are missing.

    Note there is an extra registry GUID change for the 64bit Adobe I filter.  Here'a a link to a well written post : Here

7. After all these are verified and\or changed to the correct configurations, run an stsadm full crawl.

    This is performed by opening a command promt  on the server running the Windows SharePoint Services Search Service then:

    Type cd C:\program files\common files\microsoft shared\web server extensions\12\bin

    Hit Enter

    Type stsadm -o spsearch -action fullcrawlstart

    Hit Enter

    Your content should begin the indexing process

    Check the event lot to see if the 401 unauthorized messages have gone away.

 

I hope this helps you guys out there in the field.

 

 

Tags: , ,

Aug 12 2009

SharePoint Advertising For Your Site!

Category: amilsark @ 06:10

Have you noticed the SharePoint targeted advertising (look to the right) available now thanks to SharePointAds.com?

According to their site the payout for pay-per-click is $2.8!  If this is really two dollars and eighty cents, that is an amazing figure!   If this is indeed the case that figure absolutely destroys google adsense.   Their FAQ says that they pay their affiliate publishers 70% of the revenue they collect from advertisers.   High profile SharePoint blogs (SharePointJoel.com), community sites (SharePiontBuzz.com), and online editorials (SharePointReviews.com) have adopted this advertising.

The performance graphs and data visualizations are pretty impressive in your affiliate control panel.  The control panel includes quick stats, trend rports, data on each individual rotating add including click through rate and commision pending and paid out.

Targeted Advertising for SharePoint is an excellent opportunity not only for blog authors, but also for companies whose business is based around SharePoint.  Now your company has an easy and cost effective way of getting advertising space on these high profile, high traffic sites which are  SharePoint resource heaven for most IT professionals working with SharePoint.

If you are interested in generating some targeted advertising revenue from your SharePoint site or SharePoint blogs just fill out the form below.  SharePointAds.com will review your information and send you a confirmation ID  and temporary password.

 

Personal Info


Additional info









 

Happy SharePointing!

Tags: , ,

Aug 11 2009

Office SharePoint Server 2007 SP2 License Issue fixed

Category: amilsark @ 06:00

Microsost has released an updated Office Sharepoint Server 2007 SP2 patch where the "license isssue" is now fixed.

For those of you who may not realize the problem in the first releae of Service Pack 2, it essentially places your SharePoint installation into a trial mode until you re-enter your software key in Central Administration.

You can download the updated Service Pack from the following links:

x86: http://download.microsoft.com/download/2/F/5/2F51AB71-1325-49D2-9CB9-18DEC4780E99/office2007-kb971620-fullfile-x86-glb.exe

x64: http://download.microsoft.com/download/5/B/B/5BBD34A9-C528-42B0-8A5F-9A8997B25C32/office2007-kb971620-fullfile-x64-glb.exe

The recommended installation procedure is to install the WSS 3.0 SP2 first, don't run the configuration wizard, then install the Office Sharepoint Server 2007 SP2 and now run the configuration wizard.

 

Tags: , ,

Jan 30 2009

WSS 3.0 error - Cannot open "tsa.en-US.resx": no such file or folder.

Category: amilsark @ 01:59

The fabulous 40 site templates are a set of Sharepoint site templates released by Microsoft that provide enhanced functionality to sharepoint without developing custom sites and lists. 

Some examples of sites that come in this package: 

Absence Request and Vacation Schedule Management, Help Desk, Budgeting and Tracking Multiple Projects, Inventory Tracking, Bug Database, IT Team Workspace, Call Center

We have encountered an issue on our server farms that have these templates deployed.  It seems as though the deployment package does not deploy some of the US English resource files to the sharepoint resources directory (C:\program files\common files\Microsoft shared\web server extensions\12\resources).

If you see errors in the Sharepoint logs like: "Cannot open tsa.en-US.resx: no such file or folder" I can help you out.

To resolve this issue, you'll need to deploy the resource files  to their required location.

It turns out that the English resource files are actually deployed, but they are named incorrectly.  From my Sharepoint development background in multi-language software, it is a common mistake to  to leave your default English .resx file named xxxx.resx.  Sharepoint requires xxxx.en-US.resx to load the English resource strings for English regional settings in its applications.

So enough background, let's fix this thing!

Open up the command prompt WSS 3.0 or MOSS Web Front End server:

Start > run > cmd

Change the directory to the sharepoint resources folder

cd /d "C:\program files\common files\microsoft shared\web server extensions\12\resources"

Then make copies of the resources files with the copy named with a xxxx.en-US.resx

copy avm.resx avm.en-US.resx
copy compproc.resx compproc.en-US.resx
copy ep.resx ep.en-US.resx
copy er.resx er.en-US.resx
copy hlpdsk.resx hlpdsk.en-US.resx
copy itteam.resx itteam.en-US.resx
copy proj.resx proj.en-US.resx
copy pws.resx pws.en-US.resx
copy rer.resx rer.en-US.resx
copy tsa.resx tsa.en-US.resx

 And there you have it, you should have all the required English resource files in their required location.

Also note that you can create a batch file with the above commands if you have multiple web front end servers to speed up the fix.

I hope this helps someone!

Tags: , , , ,