Re: Configuring Full Text Search FOr SharePoint Web

I will keep this reply short but want to thank you Charles for your help and
encouragement in getting this resolved.

My SharePoint database had been upgraded to SQL and the data was being
stored there like I thought. After getting Indexing installed from the
Premium Technologies disk I was part of the way there but needed to
re-install SP4 for SQL2000. After doing that the Full-Text Catalogs were
showing in each of the SharePoint databases in Enterprise Manager. I enabled
the Full Text Search and Index again in SharePoint Central Administration
and the search engine began to work!

Thanks Again
Jeff

""Charles Yang [MSFT]"" <v-chayan@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:ZDQw9x4iFHA.2468@xxxxxxxxxxxxxxxxxxxxxxxx
> HI Jeff,
>
> Thanks for detailed updates.
>
> Please note that the issue might relate to SQL issue, we may focus more on
> SBS side. If you have any concerns about SQL, it also your best interest
> to
> post on to SQL newsgroup.
>
> According to your description, it seems you could not configure "full text
> searching". In order to make the issue more clearly, I suggest you perform
> the steps below:
>
> 1. You need to make sure that you have upgrade your sharepoint instance to
> SQL, by default if you did not upgrade it even if you install SQL on your
> SBS 2003, you could not use the "full text search".
> 2. I suggest you follow the steps I referred in my previous reply to
> confirm your steps about install or upgrade MSDE instance on sharepoint
> services. We also test on our test machine, we found if we only installed
> SBS 2003 premium but not completely the steps on premiuminstall of
> additional technology, we will also run the SBS 2003 well, but we could
> not
> use "full text search"
>
> You can refer to the following KB article:
>
> 837367 How to turn on full-text search in Windows SharePoint Services on a
> http://support.microsoft.com/?id=837367
>
> 823377 You receive a "The database this server is using does not support
> http://support.microsoft.com/?id=823377
>
> In addition, please make sure that you follow the steps below move the SQL
> database.
>
> 224071 INF: Moving SQL Server Databases to a New Location with
> Detach/Attach
> http://support.microsoft.com/?id=224071
>
> I suggest you reapply SP4 to your SQL server to sharepoint instance to see
> if the issue can be resolved. If you have confirmed the database is moved
> follow the steps below, if not there might be some issue when performing
> full text search.
>
> Please also check if there are any error events in the event view.
>
> Thanks for your understanding, if you have any concerns, please let me
> know. I will be here waiting for your updates.
>
>
>
> Best regards,
>
> Charles Yang (MSFT)
>
> Microsoft CSS Online Newsgroup Support
>
> Get Secure! - www.microsoft.com/security
>
> ======================================================
> This newsgroup only focuses on SBS technical issues. If you have issues
> regarding other Microsoft products, you'd better post in the corresponding
> newsgroups so that they can be resolved in an efficient and timely manner.
> You can locate the newsgroup here:
> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
>
> When opening a new thread via the web interface, we recommend you check
> the
> "Notify me of replies" box to receive e-mail notifications when there are
> any updates in your thread. When responding to posts via your newsreader,
> please "Reply to Group" so that others may learn and benefit from your
> issue.
>
> Microsoft engineers can only focus on one issue per thread. Although we
> provide other information for your reference, we recommend you post
> different incidents in different threads to keep the thread clean. In
> doing
> so, it will ensure your issues are resolved in a timely manner.
>
> For urgent issues, you may want to contact Microsoft CSS directly. Please
> check http://support.microsoft.com for regional support phone numbers.
>
> Any input or comments in this thread are highly appreciated.
> ======================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
> =====================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>


.

Relevant Pages

  • Re: SQL CE 3 and CF 1.0 support
    ... > We have designed our application so that all data access logic is ... > using our automated upgrade mechanism and at the same time upgrade the ... > from the engine download and the database upgrade delay). ... > I also know of applications that have been using SQL CE databases in RAM ...
    (microsoft.public.sqlserver.ce)
  • Steps for Migrating WSS 3.0 from Windows Internal Database to Microsoft SQL 2005
    ... done the stupid things I did when I started playing with Sharepoint ... when I first installed it and assuming that it would find the SQL 2005 ... Windows Internal Database). ... Reboot the server to finish up any uninstall scripts. ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Upgrading to R2 premium SQL questions
    ... there are already 2 instances using MSDE ... You could upgrade the SharePoint named instance to full ... SQL from MSDE to SQL 2005. ... You cannot upgrade the Monitoring instance to SQL ...
    (microsoft.public.windows.server.sbs)
  • Having trouble getting Sharepoint over to SQL 2000 during Premium Upgrade
    ... Last week my client wanted me to upgrade a SBS standard edition to ... I ran through the html procedure to install single instance of SQL ... I then tried to upgrade Sharepoint from MSDE to SQL as per same ...
    (microsoft.public.windows.server.sbs)
  • Re: Sharepoint Services (V2 and now V3) recording of the date/time recorded into Database
    ... directly at the SQL 2005 database, ... Document List) must update the database directly with the GMT0 ... I have also done a test with the Reporting Services against the test ... times used by SharePoint itself and the times used in the database. ...
    (microsoft.public.sharepoint.windowsservices)