asked on

Installing MS SQL Server 2005 on Windows SBS 2003 R2 Premium Edition for MS CRM

When installing MS SQL Server 2005 on Windows SBS 2003 R2 Premium, I had accepted the defaults. Then, when installing MS CRM 3.0 SBS edition, the Microsoft CRM Environmental Diagnostics Wizard reports the following errors:
The full-text component is not installed on the specified SQL Server.
Specified Reporting Services Report Server http://SERVER01/ was not found.

I tried to install these components using the instructions found here: http://support.microsoft.com/kb/913967
However, that did not install the requested components, and I still get the above mentioned errors.

sguinn100

Full Text search and Report Server Services are not installed by default. So if you accepted the defaults they are not there and that is why you are getting those errors during the CRM installation. Even after you run SQL setup and add Report Services at that point it is still not completely installed you have completed all the steps in the Reporting Services Configuration Manager. You get to it by going Start>All Programs>Microsoft SQL Server 2005>Configuration Tools>Reporting Services Configuration. You pretty much have to have all green checkmarks in there before Report Services will work.

Where you are at now, I don't think you can install either of those by just running SQL setup again. I think you have to go to Add/remove programs, click on SQL Server 2005. There will be a drop down menu when you can select Full Text Search and Reporting Services and add them to the default instance.

qlc

ASKER

"There will be a drop down menu when you can select Full Text Search and Reporting Services and add them to the default instance." I have tried that, and it doesn't work. It says that I have made no changes and therefore there is nothing for it to do, although I have.

sguinn100

Yup, that is the challenge. Let me look at it in my test server later today. I found a workaround last time I'm just not remembering it at the moment.

ASKER CERTIFIED SOLUTION

sguinn100

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

qlc

ASKER

Yes, I did just that. And, the "Full-Text Search" seems to be installed according to the "Microsoft SQL Server 2005 Setup" window. But, the CRM installer fails to recognize it. I even tried removing the Full-Text Search and then reinstalling it, but to no avail, the CRM installer still doesn't see it.

sguinn100

Did you follow the steps at the bottom of the SQLINSTALLSTEPS.HTM to create a default instance of SQL to install CRM on to?

qlc

ASKER

Yes. I have uninstalled SQL Serer 2005 and reinstalled it making sure that the full-text component was checked. It seems to pass the full-text validation now. Now I have the following errors:

Specified Reporting Services Report Server URL https://SERRVER01/reportserver cannot be resolved into IP. The requested name is valid, but no data of the requested type was found

Setup was unable to verify that the "Trust for Delegation" property is enabled for the computer object.

qlc

ASKER

the typo is mine, it should read:
Specified Reporting Services Report Server URL https://SERVER01/reportserver cannot be resolved into IP. The requested name is valid, but no data of the requested type was found

SOLUTION

sguinn100

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

qlc

ASKER

sguinn, thank you very much.