First, to find the identifier of a IIS website, you simply need to click the “Websites” folder in the left side of the IIS Manager windows.   The right pane will list the websites on the server and their respective identifiers.  If you need to change one, use the following three commands (assuming the current id is 1 and you want to change it to 2):

CSCRIPT %SYSTEMDRIVE%\Inetpub\AdminScripts\adsutil.vbs STOP_SERVER W3SVC/1
CSCRIPT %SYSTEMDRIVE%\Inetpub\AdminScripts\adsutil.vbs MOVE W3SVC/1 W3SVC/2
CSCRIPT %SYSTEMDRIVE%\Inetpub\AdminScripts\adsutil.vbs START_SERVER W3SVC/2

If you receive this error message upon accessing Microsoft CRM 4.0 for the first time after an upgrade, chances are you are simply using the wrong URL.  It is important to note that because of the new multi-tenancy feature in CRM 4.0 it is now necessary to reference the Organization name in the URL.  The correct format for the homepage for example is:

http://servername:5555/organizationname/

As always, if you are looking for professional Microsoft CRM Consulting for assistance with installation, migration, or upgrade, contact Kazmarek Technology Solutions directly.

I received this error message during the CRM 4.0 Upgrade:

“There is already an object named ‘AttributeTypes’ in the database”

It turns out that this error message is poorly designed and doesnt describe the actual cause of the error which was the ftcat_documentindex issue discussed here:

http://blog.kazmarek.com/2008/03/11/full-text-index-inconsistency-when-upgrading-to-crm-40/

I received the following error in the environmental diagnostics wizard during an upgrade to CRM 4.0:

“The full-text indexes on the Microsoft Dynamics CRM database are not consistent with Microsoft Dynamics CRM 3.0 full-text indexes.”

After some research, MS article 927226 pointed me to the log file from the installation found here:

C:\Documents and Settings\user\Application Data\Microsoft\Mscrm\Logs\crm40svrsetup.log

Looking for the error message towards the bottom of the log, I found where it referenced the table with the inconsistency.  this section of the log looked like this:

21:54:13|   Info| tableowner:                             dbo
21:54:13|   Info| tablename:                              documentindex
21:54:13|   Info| fulltextkeyindexname:          cndx_primarykey_documentindex
21:54:13|  Error| remark:                                  modified full-text index

Looking at the table in question, dbo.DocumentIndex, I was able to determine that it didn’t have any full-text indexes.  After some research, I discovered that it was in fact suppoed to…you can run the following commands to check this:

Command: sp_help_fulltext_tables
Expected Results:

dbo DocumentIndex cndx_PrimaryKey_DocumentIndex 1 1 ftcat_documentindex

Command: sp_help_fulltext_columns
Expected Results:

dbo 1205579333 DocumentIndex Title 9 NULL NULL 1033
dbo 1205579333 DocumentIndex KeyWords 11 NULL NULL 1033
dbo 1205579333 DocumentIndex SearchText 12 NULL NULL 1033

The fix then was to create a new full-text catalog for the table.  The steps I followed are:

1. Right-click the dbo.DocumentIndex table and select “Full-Text Index”
2. Select the defaults (click “Next”) until you get to the column selection.
3. Select the following columns to include in the index:
   • KeyWords
   • SearchText
   • Title
4. Select the defaults the rest of the way through and name the catalog ftcat_documentindex.

After creating the full-text catalog, full-text indexing will be enabled on that table.  This will cause another error in the CRM 4.0 setup, so right-click the table again and choose “Disable Full-Text Index” from the “Full-Text Index” menu.

As always, if you are looking for professional Microsoft CRM Consulting for assistance with installation, migration, or upgrade, contact Kazmarek Technology Solutions directly.

In Vista, I have seen my network and sound icons disappear from the notification area quite often.  Microsoft KB article 945011 explains why and how to workaround the issue.  Unfortunately, this isnt a permanent fix and they still seem to disappear occasionally.  I have created a batch file to do the work for you so that you can run it often if need be.  Take the following text, paste it into a text file and then save it as restore_icons.bat or something similar (must end in .bat).  Run it to restore your icons.

 NOTE! This blog breaks up the first two lines at the first space.  Make sure you piece the code back together as it should be.

reg delete “HKCU\Software\Classes\Local Settings\Software\Microsoft\Windows\CurrentVersion\TrayNotify” /v IconStreams /f