• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 473
  • Last Modified:

Error found with CRM Environment Diagnostics Wizard

I managed to get CRM 3.0 Pro to install. Now I'm trying to get the e-mail routing to install and I can't get it to see the CRM server.

The handy dandy diag wizard that was installed by the CRM installation tells me "version string position was too short or too long" for MS SQL.

It then gives the false hope that to fix this I can go to the control panel and choose CRM Server --> Change and choose the repair option.

When I do that I get "setup could not retrieve data from the database" and "row handle is invalid".

Brand new box with:

Win 2003 Server SP1
SQL 2000 SP4
Exchange 2003 SP2  
0
medusaresearch2
Asked:
medusaresearch2
  • 7
  • 6
1 Solution
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
Can you please post the exact error messages along with any event ID's that were generated?  Errors would be listed in the Application Events, System Events or CRMSETUP.log

Jeff
TechSoEasy
0
 
medusaresearch2Author Commented:
There weren't any event ID's that were tied to this which made it frustrating.

Yesterday after I couldn't get SQL 2005 standard to go in clean I uninstalled CRM 3.0. That let SQL 2005 install to completion.  Now as I attempt to reinstall CRM 3.0 it won't go past the verification utility portion for SQL.
It's looking for a url for the reportserver and by all accounts I can find it should be at http://servername/reports
but that isn't working. My browser isn't seeing anything there either.
0
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
Well that problem is a KNOWN error... you really need to review the installation notes in the current readme file:
http://www.microsoft.com/downloads/details.aspx?FamilyID=eac26563-cb05-4acc-9060-5ca70bd8277d&DisplayLang=en

Jeff
TechSoEasy
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

 
medusaresearch2Author Commented:
I prefer that kind of error to the unknown kind. :-)

I'll go read that and see where it takes me. I also sported for Working with Microsoft Dynamics CRM 3.0 on the way in today.  
0
 
medusaresearch2Author Commented:
Most of that document appears to assume I have CRM installed. I can't use any tools to do stuff because I havn't got access to them yet.

I still stop when looking for the reporting services server and the message "an existing reporting services server cannot be found" is what comes up
0
 
medusaresearch2Author Commented:
And as a clarification I do feel I have reporting services installed. I have a tool from SQL 2005 that looks like it's installed.
0
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
Just to clarify... are all three of those servers you listed above separate machines?  

Jeff
TechSoEasy
0
 
medusaresearch2Author Commented:
No the whole shebang is in one box. And the SQL 2005 manager shows report services running.

When I try to load the http://localserver/reportserver web page I get a login box that doesn't seem to accept legitimate full admin logins.  
0
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
Well, are you following the CRM 3.0 Implementation Guide?  The request to clarify whether all of those were on three separate machines was because you specified that you were installing CRM 3.0 Pro and not CRM 3.0 Small Business Edition.

The SBE is the only version recommended for installation on a single server and that server must be Small Business Server 2003 Premium Edition.  If you have less than 75 users on your network, this would be the way to go.  Although you would need to make the SBS the root of your domain, etc.

If you want to stay with CRM 3.0 Pro, you will need to minimally have SQL Server on another box, but ideally both SQL and Exchange are separated.

See the implementation guide for more information:  
http://www.microsoft.com/downloads/details.aspx?FamilyID=1ff067f8-4f77-40f0-ae9c-68ada7d4f16a&DisplayLang=en

Jeff
TechSoEasy
0
 
medusaresearch2Author Commented:
I've read the implementation guide and I'm not real impressed with it as an information source. It talks about software versions and levels of service paks but where does it explicitly say I'll need separate boxes?

Yes this install is a small office and I understand the SBS mentality but it isn't a solution here. With an existing network and servers already in place going to SBS would mean completely upending an existing network. There are 4 boxes in the server room now and we simply want to bring CRM online alongside what is there without creating a server room that has a box count equal to the number of employees in the building. Am I going to have to expect that every time a client wants to install new MS product they'll need to add yet another server? I'm sure that's great for the MS bottom line but tough for small business to stomach.
0
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
It has a whole section on Hardware/Software requirements and states very clearly under Multiple Server Deployment that, "a base scenario  describes a minimum six-server deployment ".  Then further down under Single Server Deployment, it states, "The Small Business Server scenario is the only recomm ended one-computer server deployment".

Now I realize it uses the word "recommended".  However, I have not found any supporting evidence to say that you can install CRM 3.0 Pro on a single server.

But lets be clear about your statement, "Am I going to have to expect that every time a client wants to install new MS product they'll need to add yet another server? I'm sure that's great for the MS bottom line but tough for small business to stomach."

The fact that you have ALREADY purchased the Enterprise licenses for the server products instead of SBS is what's causing this problem.  You've already paid way too much for what MS would have given you for much much less.  So if you already have 4 boxes in the server room... why are you trying to install CRM on one that has SQL and Exchange already??? Why not one of the others???

Jeff
TechSoEasy
0
 
medusaresearch2Author Commented:
The client is fortunate to have all this via the Action Pak subscription and therefore not out of pocket any extravagant sum. And it's not on any of the existing servers because I would never try to bring something like this online in a live environment where it could affect the clients daily business operation. I've had my fill of server installs from hell.

A minimum 6 server deployment is lunacy. CRM 3.0 pro shipped without it's CD in the Action Pak April update. All MS did was include a new non-SBS key on a piece of cardboard and said use the SBS CRM disk with the new key. The very same CD and software that installs CRM on a single server Small Business Server is CRM 3.0 Pro using the new key!!!!

Yes I'll buy that CRM might be a real dog in my single server if 100 people were to hit it, but I've got maybe 5 users who will be connected ever. MS also knows I have it all in one box and has no issue with that fact.  

My issue is reporting services, the server tools like services or SQL manager say it's running. CRM's verification utility that runs with the install can't find it.
0
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
It has NOTHING to do with being a real dog or not... it has has everything to do with the architecture of the product which will not work on the same server with both  Exchange and SQL installed.  In fact the problem actually starts because you are running a standard version of SQL server on a Standard install of Exchange.  Since you have few users you probably haven't seen any resource issues on that box, but they can occur.  

Furthermore, there are a number of interoperability issues with running both together on a regular server platform.  You could see problems with MS DTC, ActiveX Data Objects, or OLE DB objects.  For sure, when you install CRM you will cause some of these issues to occur.  They do not occur on an SBS because of the SBCore service and other SBS technologies which regulate and control the interoperability of these technologies.

You'll find that in much of the documentation and online information they repeatedly say, "you can combine Microsoft CRM Server on the same computer as either SQL Server or Exchange Server, but Microsoft does not recommend these configurations".

So, you are complaining about the lunacy of Enterprise configurations when this "client" should not have had them in the first place... this is exactly what SBS was designed for and ONLY because they somehow have Action Pack are they in this current situation.  (By the way, Action Pack users generally do not hire outside consultants to install the product because the reason Microsoft provides Action Pack is so that Partners can learn how to use the products -- so if they aren't doing it themselves, then technically they don't qualify for it).

I have no idea what you are referring to with the fact that the same PID key is usable for either product... that's no issue... the same exact PID key is usuall used for EVERY MSDN preview product in the same category... for various versions and various users.

So, if you still want to keep all of this on ONE machine, then install Virtual Server 2005 and add an additional  server 2003 running SQL, or add TWO  Server 2003's, one running SQL and the other CRM!

You'll find Virtual Server 2005 in the Action Pack or just download it because it's now a free product.  It's designed for exactly the thing you are doing... testing deployments before putting them on a production server.  Virtual Server CAN work in a production environment as well... but you need lots o' resources for that.

Jeff
TechSoEasy
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now