Hi,

I have downloaded the new version of CRM available on the MS website (File
Version - 3.0.5300.9) to install on a recent SBS 2003 R2 server but I am
having issues at the first instance. The install fails to find the Reporting
Services Report Server.

SBS 2003 R2 uses SQL 2005 workgroup edition and we have updated the
SharePoint instance to SQL 2005. The only instance of the Reporting Services
currently installed in on the Default Web site for SharePoint in the virtual
director Reports$SHAREPOINT.

Should I use this instance to install CRM or should I install another
instance of SQL specifically for CRM? If so whould I also set up an new
website for a virtual directory for Report Servoce to be intalled in to.

I have also looked through the documentation at
http://www.microsoft.com/downloads/d...&DisplayLang=e
but this doesn't shed much light either as I have issue with the following
points: -

Point 13 - Selecting the SQL Server
Do I need to install a new instance of SQL 2005 Workgroup on the server
prior to running CRM 3.0 installation?

Point 14 - Connect to existing Report Server
How to I know that the report Serving is going to be? At the moment the only
instance of SQL 2006 that is installed on this machine with Report Services
that shows up on ANY website is for SharePoint installed under the default
website. When browsing this page I get: -
=============================================
localhost/ReportServer$SHAREPOINT - /

Microsoft SQL Server Reporting Services Version 9.00.2047.00

==============================================

But surely I don't want to use this for the CRM install, or do I?

I have installed Reporting Services on the Default Instance of SQL 2005, but
it does not appear to be referenced in any other website.

Anyone got any ideas?

Chris

I did exactly the same - installed a clean SBS 2003 R2 - then CRM 3
SBE. At this point I got an error log message that "It is not possible
to run two different versions of ASP.NET in the same IIS process"

I expanded the default site and right clicked on ReportServer and
Reports and chose Properties and on the tab that comes up changed the
Application pool to "ReportServer" for both.

I'm fairly sure that the ReportServer application pool was created by
the install but must confess that my path to this point was circuitous.
I first made the mistake of upgrading all the SBS websites to ASP.NET
2. Marina over at smallbizserver.net made two laconic statements - do
NOT upgrade those sites and Undo this. To recover from that I
unistalled the dotnet framework 2 and got the SBS sites back to 1.1.
Then I reinstalled the dotnet framework 2, restarted and made sure all
the SBS sites stayed on 1.1 which they did. Finally I assigned the
reports and ReportServer sites to the ReportsServer application pool
and I'm now able to run reports in MS CRM.

RWW, companyweb, sharepoint and WSUS are all working fine and I can run
reports from MS CRM 3

Doug

A few things:

1. Have you install the SQL Server 2005 Workgroup Editon via the SBS 2003 R2
Premium Technology CD1 setup after the initial baseline SBS 2003
installation? Ensure that you install a "default" instanace of SQL Server.
And check all the components of the Database options like "Full-Text Search",
Reporting Service, etc.. This will be ok and not interfare with existing
Sharepoint setup.

2. If the SBS03 and Premium Technology (SQL 2005 WG) are installed properly,
then at the MSCRM SBE installation, reference the following document
"Installing CRM on SBS R2" which you've mentioned
http://www.microsoft.com/downloads/d...DisplayLang=en

3. When CRM prompt you for the database, pick the name of the SBS server
(Point 13). It should be available if Premium Technology portion is
installed.

4. Regarding the Report Server, it will be the following:
"http:\\<sbs_server_name>\reportserver"; This will be available for you
automatically via the step 1. above.


Good luck.




Frank Lee, Microsoft CRM MVP
Workopia, Inc.
http://microsoft-crm.spaces.live.com


"Chris Swinney" wrote:

Many thanks for this.

I have install SQL 2005 after the R2 baseline install. I upgraded Sharepoint
then went back and installed SQL 2005 as the deafult instnace. I initally
install all SQL options in Sharepoint but not the deafult instance but,
however I late went back and changed SQL 2005 and added the rest of the
component to the default instance.

However, I still have some issues. As mentioned above, I don't have a
"Reports" or "ReportServer" virtual directory, just the "Reports$SHAREPOINT"
and "ReportServer$SHAREPOINT" virtual directorys. These two already have
have thier Application Pool set to "RerportServer$SHAREPOINT" - there is no
"ReportServer" application pool. I don't think I should mess with Sharepoint
stuff as this will proably break.

Chris

"Frank Lee" <FrankLee@ditscussions.microsoft.com> wrote in message
news:695C8A04-6905-4199-9575-332456D9110D@microsoft.com...