Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2007-08-08
10
Medium Priority
?
2,071 Views
Last Modified: 2012-06-27
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.
0
Comment
Question by:qlc
  • 5
  • 5
10 Comments
 
LVL 9

Expert Comment

by:sguinn100
ID: 19659672
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
 

Author Comment

by:qlc
ID: 19661726
"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
 
LVL 9

Expert Comment

by:sguinn100
ID: 19661755
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
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
LVL 9

Accepted Solution

by:
sguinn100 earned 2000 total points
ID: 19664556
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
 

Author Comment

by:qlc
ID: 19667640
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
 
LVL 9

Expert Comment

by:sguinn100
ID: 19673804
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
 

Author Comment

by:qlc
ID: 19686283
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
 

Author Comment

by:qlc
ID: 19686291
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
 
LVL 9

Assisted Solution

by:sguinn100
sguinn100 earned 2000 total points
ID: 19686526
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
 

Author Comment

by:qlc
ID: 19687188
sguinn, thank you very much.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
There are literally thousands of Exchange recovery applications out there. So how do you end up picking one that’s ideal for your business & purpose? By carefully scouting the product’s features, the benefits it offers you, & reading ample reviews f…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Loops Section Overview

577 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