Improve company productivity with a Business Account.Sign Up


CRM 3.0 Instalation Problem

Posted on 2006-11-22
Medium Priority
Last Modified: 2013-11-24
Hi all,

I am hoping some clever individual can help with a problem I have been trying to solve for the last two days?

I am tring to install MS CRM 3.0 onto my Small Business Server 2003 and I get the following error:

Service mssearch was not found on computer 'SERVER'.
The specified service does not exist as an installed service

I have checked the SQL Server configuration and this service is running and can not find any answers on the net

Please help!!!!

Question by:Cragly
1 Comment
LVL 23

Accepted Solution

rama_krishna580 earned 1500 total points
ID: 17998270

look at the requirements here and see

I’ve been having problems with my CRM 3.0 SBE install on a SBS 2003 Premium install. Based on a lot of different posts in many different newgroups as well as some input form the Microsoft CRM team, I decided to try several installs under better controlled and documented conditions to see if I could understand what was happening. Here is a summary of my experiments

Assumptions: CRM 3.0 SBE is advertised to only work with SBS 2003 Premium and only with SBS SP1 installed. To me this means one of two variations: SBS 2003 with SQL 2000 SP4 and no ISA or SBS SP1 with SQL 2000 SP4 and ISA 2004. I also made a gross assumption that a system patched to SBS 2003 SP1 will act that same as a system installed as SP1 (I know this is probably faulted but I just don’t have time to build out that many different servers.)

As a starting point for both tests I built out an SBS 2003 virtual server image as follows and then enabled UNDO disks so I could go back to this point for the start of each test.

Build out a virtual server image of SBS 2003 SP1 with SQL 2000 SP4 (using MSDN download ISO images) with the following characteristics:
2GB RAM, Single 16GB Hard Drive, Dual NIC
Internal IP Address:
External IP Address: (connected to the Internet through my internal network)
Domain: demo.local
Machine Name: SBS
External domain name: (used for OWA and RWW access) Note that there is no host record for this domain name.
Run the connection wizard to establish connection to the Internet.
Install Virtual Machine Additions.
No additional patching, hot fixes, or updates applied.
Save image and then enable UNDO disks for remaining changes.

Test 1: Install CRM 3.0 SBS on SBS 2003 SP1 with SQL 2000 SP4 (No ISA)

Restart virtual server image from rolled back state.
Load CRM 3.0 SBE form MSDN ISO Images using all default settings.
ERROR: SQL Reporting Services cannot find IP address corresponding to domain name I would have expected SQL Reporting Services to use the machine name of sbs.demo.local rather than the name assigned to the default web site certificate ( In my case there is no way that the domain name would resolve because there is no host record matching this value. However even if it did resolve it would not work because it would resolve to a public IP address and it would likely be blocked.
WORK AROUND: Create a forward lookup zone in the SBS DNS Server for and then create a host record pointing to the IP address assigned to the internal NIC ( Run a  IPCONFIG /flushdns and then retry the failed step.
Note that additional actions will be required after setup completes to remove dependency on this DNS entry.
ERROR: SQL Reporting Services cannot access the Report Server at ReportServer due to a 401 access denied error.
According to KB 896861 this is an issue resulting for Windows 2003 SP1. The KB offers two options to workaround the error. I chose to add the DisableLoopbackCheck DWORD value to the registry.
Completed install without additional errors.
Rebooted after installation completed
Ran through CRM setup wizard.
At this point any time I tried to run a report I was getting challenged for credentials from the report server at If I supplied credentials the report would continue.
In order to remove the reference to I edited the registry value for SQLRSServerURL at HKLM\Software\Microsoft\MSCRM from to https://sbs.demo.local/ReportServer and performed an IISRESET at the command line.
Removed the forward lookup zone for from the SBS DNS server and flushed the DNS cache.
Able to access CRM reports with out additional authentication. All seems to work well

Test 2: Install CRM 3.0 SBS on SBS 2003 SP1 with SQL 2000 SP4 with ISA 2004

Restart virtual server image from rolled back state.
Install ISA 2004 from the SBS Premium Technologies with SP1 using the MSDN ISO image.  
Modified the default web site setup as follows per recommendation from Barry Givens (CRM PM)
Set the port 80 and port 443 IP addresses to use all IP addresses rather than the distinct and the
Set the DisableLoopbackCheck DWORD value per KB 896861 based on experience in first test.
Ran CRM 3.0 SBE install using MSDN ISO images
ERROR: Had an error during the SRS install but error cleared on RETRY.
Install finished with out further error.
Had a service start error on server startup. Microsoft Firewall Service did not start properly. The service did start from a manual start command.
Ran through initial setup wizard
Tested reports without issue.
Ran the SBS Internet connection wizard and verified that the default web site IP address properties were returned to their pre-crm values.
Opened CRM and tested reports. Flawless

It appears that the recommended fixes for installation when ISA 2004 is on the SBS 2003 box work. The issue I had in Test 1 Step 3 is perplexing. Oddly enough when I looked at the HKLM\Software\Microsoft\MSCRM\SQLRSServerURL value from Test 2 (ISA Installed) it was https://publishing.demo.local/ReportServer ( a local domain path) rather then the external domain name that I saw in my install without ISA 2004.



Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Read about achieving the basic levels of HRIS security in the workplace.
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
To export Lotus Notes to Outlook PST or Exchange and Domino Server files to Exchange Server or PST files with ease, go for Kernel for Lotus Notes to Outlook conversion tool. Through the video, you can watch the conversion process. A common user with…
Watch the software video of Kernel Import PST to Office 365 tools which can easily import PST and OST files to Office 365 for bulk mailboxes. The process of migration is simple and user can map source and destination mailboxes and easily import data…

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question