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.
qlcAsked:
Who is Participating?
 
sguinn100Commented:
Did you try to add Full Text Search and Report Server by going to the Add/Remove programs in the Control Panel? I just tried it and it worked. You highlight the Default Instance of SQL, than click next and highlight the Database Engine. It goes through some thinking and then you get a line that says SQL server. Expand it and Full Text Search is one of the options.
0
 
sguinn100Commented:
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.
0
 
qlcAuthor Commented:
"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.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
sguinn100Commented:
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.
0
 
qlcAuthor Commented:
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.
0
 
sguinn100Commented:
Did you follow the steps at the bottom of the SQLINSTALLSTEPS.HTM to create a default instance of SQL to install CRM on to?
0
 
qlcAuthor Commented:
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.
0
 
qlcAuthor Commented:
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

0
 
sguinn100Commented:
Which set of instructions are you using to install CRM? It looks like CRM is loking for an https ~ SSL ~ enabled version of Reportserver. Two isues with that, the CRM install should initially be done without SSL for Reportserver. Second is, if the non-SSL version is what you selected during the CRM install, then you need to go to Start>All Programs>Microsoft SQL Server>Configuration Tools>Reporting Services Configuration. Connecct to MSSQLSERVER. Down the left hand side you should have Green checkmarks. In Node titles Report Server Virtual Directory, uncheck the box by Require...SSL...
0
 
qlcAuthor Commented:
sguinn, thank you very much.
0
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.

All Courses

From novice to tech pro — start learning today.