Patrick\’s Bytes

27, November 2007

SQL Server 2005 Reporting Services and MOSS 2007

Filed under: Sharepoint,SQL Server — patrickyong @ 3:27 am

Managed to get Reporting Services integrated with MOSS yesterday. Phew… took me a morning to do that and this is my 2nd try on a VPC environment.  The first thing I do it on a Windows 2003 VPC with Domain Controller, SQL Server, MOSS together. Apearantly later when I setup everything and go back to grant database access in Central Administration web site it returns me some funny message. After spending sometime on the web, I realize there is some problem when you have DC on the same machine.

So in my 2nd try I setup 2 VPCs, the 1st one hosting the DC and Cert server while the 2nd one have SQL Server and MOSS installed. Then I got it right this time. There is a word of cautious though, if you use a domain account to start the SQL Server services (such as domain\sqlservice) then you will have problem starting up the reporting Services Web Service at http://domain.com/reportserver. This is because the web service in IIS 6.0 uses Network Service account in the application pool, so all you need is go into IIS and change the App Pool identity (in the case will be the ReportServer app pool) to your SQL Server service account.

Below are some links which help me get started in all this.

Configure the Report Server Integration Feature in SharePoint Central Administration
http://technet.microsoft.com/en-us/library/bb326213.aspx

Report Server How-to Topics
http://technet.microsoft.com/en-us/library/bb283321.aspx

Advertisements

2 Comments »

  1. Hi,

    I am implementing a similar architecture. It is a website purely for delivering reports for clients with various roles and security. Is it good to create our own website using ASP.NET 2.0 membership functionality or is it good to go with MOSS 2007. Your expert advice is very much appreciated.

    Regards,
    Jagadish.

    Comment by Jagadish — 27, May 2008 @ 11:32 am | Reply

  2. Hi Jagadish,

    It depends how you architect your SSRS project. If you got a custom application based purely on ASP.NET and you want to integrate some controls inside your ASPX pages, hosting the report server individually might be a better solution.

    Hosting SSRS inside SharePoint provides users with a single login facility to all their documents, list inside SharePoint on top of their reports from SSRS. SSRS can be integrated even with the free version of SharePoint know as Windows SharePoint Services.

    Comment by patrickyong — 27, May 2008 @ 9:29 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: