bryanb
Thu Dec 13 22:12:34 PST 2007
On Dec 14, 6:27 am, Bryan S <Bry...@discussions.microsoft.com> wrote:
> It had to do with the full text index. here are the instructions i got from
> Microsoft:
>
> Lets try to setup the Catalog for Indexing on the CRM implementation. I have
> outlined the steps below. Before performing these steps, please make sure
> you have a backup of the databases.
>
> a. Launch SQL Server Management Studio (user should have admin access to SQL
> and
> MSCRM database).
> b. Expand the server, expand databases, expand Your_Company_Name_MSCRM, and
> then
> expand tables.
> c. Right-click the DocumentIndex table, click Full-Text Index Table, and then
> click Define Full-Text Indexing on a Table.
> d. On the Select Table Columns page, select the following items, and then
> select
> the default options on the remaining pages of the wizard:
> * Title
> * KeyWords
> * Search Text
> e. Under the Your_Company_Name _MSCRM database, click Full-Text Catalogs.
> f. In the right pane, right-click ftcat_documentindex, and then click Rebuild
> Catalog.
> g. Right-click ftcat_documentindex, and then click Start Full Population.
> h. Right-click ftcat_documentindex, and then click Start Incremental
> Population.
> i. In Enterprise Manager, expand Support Services, right-click Full-Text
> Search,
> and then click Start.
> Note:
> Please make sure that the account you are using to perform this task is a
> member
> of the PrivUserGroup and SQLAccessGroup CRM security groups in the AD. This
> should
> ensure that you have access to MSCRM related information.
>
> "bry...@globalgrowth.com.au" wrote:
> > On Nov 30, 12:25 am, Bryan S <Bry...@discussions.microsoft.com> wrote:
> > > I installed the rollup Update 2 as described, and still no change. Any other
> > > suggestions?
>
> > > "Imran" wrote:
> > > > install the rollup update 2.. support.microsoft.com/kb/922815
>
> > > > --
> > > > Regards,
>
> > > > MS CRM Certified Professional
>
> > > >
http://microsoftcrm3.blogspot.com
>
> > > > Chat with me on MSN / Gmail / Skype : ID Is :.. mscrmexp...@gmail.com
>
> > > > "Bryan S" wrote:
>
> > > > > We are having an issue when we attempt to insert a KB Article into an E-Mail
> > > > > Msg in CRM. When we try to do a full text search in the look up articles box
> > > > > we get the following error:
>
> > > > > A SQL Server Error occurred. For more information, contact your system
> > > > > administrator.
>
> > > > > We get the same error when we select Keyword and Title search, but we can
> > > > > search by article number and do a subject browse.
>
> > > > > There is nothing in any of the event logs or the the sql logs.
>
> > I am having the same problem. Did you manage to resolve this issue?
That sorted it out. Thanks a heap for the reply.