Tuesday, April 17, 2007

Messing up SQL RS

SQL Reporting services is great, but it is actually quite common to mess up the installation due to the steps taken in installation. Always make sure you do not install either sharepoint or CRM on the same website as CRM. (It is possible to get it to work but not recommended).

What can happen is the following:
1. Installing SQL 2005, in the process installing SQL RS on port 80 = http://localhost/reports and http://localhost/reportmanager.
2. Installing either CRM or a SharePoint site on port 80 of the same computer.

= SQL Reporting Services doesn't work anymore...

So, what to do.

First, if you want your CRM or SharePoint site to be located on port 80, don't install SQL RS on port 80. Create some other webapplication using host headers or TCP-ports and install SQL RS to that website instead. Then install CRM or SharePoint to port 80. No conflict = no problems.

If you happen to mess it up anyway, or is asked to fix a messed up installation, you can do magic with the tool RSConfigTool which resides in the SQL Binn-directory (usually: C:\Program Files\Microsoft SQL Server\90\Tools\Binn). Start it, and reconfigure it properly.

Have fun reporting!

Gustaf Westerlund
CRM and SharePoint Consultant

Humandata AB
www.humandata.se

6 comments:

  1. Hi

    Your blog is the only place where I got the exact error which I ma having. I am having fine CRM running on windows 2003 R2 Server. I wanted to have sharepoint on the same server and I am looking to install it very quickly. but I could never get it working as when I install the sharepoint SRS stops working. Can you help me what options should I use to get the SRS working again with sharepoint.

    PLease email or write in you blog only.
    email piyushmittal8@yahoo.com

    Thanks and Regards,

    Piyush

    ReplyDelete
  2. The reason SRS stops working is usually that it is installed on the default website on port 80. When SharePoint is installed it is not uncommon to overwrite or deactive the default website. In the case that the virtual directories still exist, you can tell SharePoint to not manage those paths.

    The quickest way to do this is:
    Uninstall SharePoint and SQL.

    Install SQL 2005 again. Default install SRS (to default website on port 80)

    Install SharePoint to some other website (not default port 80) for instance a host headed website.

    This should make it work. If you are using host headers, make sure to configure the internal DNS correctly.

    Hope it helps,

    ReplyDelete
  3. I have had the same issue (that the CRM website disappears after installing Sharepoint Services). However, when I installed Sharepoint it didn't seem to give me options to install it to another website - how can this be done? And can it still be on that server?

    Kind regards,

    Neil

    ReplyDelete
  4. Which version of SharePoint are you installing?

    When installing v3 of SharePoint, the version you should be installing, make sure to choose advanced options, to be able to set up all sites correctly. However, you should install SQL RS to some OTHER site than default port 80 since you'll probably want this for you SharePoint. As I wrote, that is very hard to do (I don't know how anyway) in SQL 2000, so I would suggest using SQL 2005 which is a lot easier.

    Gustaf

    ReplyDelete
  5. Is there any more solution? I have the same problem!

    ReplyDelete
  6. Hi,
    If you have this problem you have to reconfigure Reporting Services. Use the RSConfig-tool to do it. Recreate all virtual directories in websites that really exist, and make sure you have working application pools. Things might be wrong even if all lights are green, so go through all steps and make sure everything is ok.

    Gustaf

    ReplyDelete