RE: Adding Full Text Search to SBS 2003 - Yes I have searched and Read Everything

Hello Ryan,

Thanks for posting here.

From your problem description, I understand that when you want to enable
the Full-text search function on the Companyweb, but you receive message
"The database this server is using does not support search" on that
configuration page.

First, please go through the steps in the following KB:

You receive a "The database this server is using does not support search"
error message when you configure full-text search for a Windows SharePoint
Services virtual server
http://support.microsoft.com/?id=23377

I understand you have already follow the KB837367 article to upgrade the
Sharepoint instance from MSDE to Full SQL and register this instance in the
SQL Enterprise Manager. So, I would like to suggest the following steps for
this issue.

I. Open the properties page Server\SHAREPOINT (Windows NT) in the
Enterprise Manager. In the General tab, please read the Value of Product
and let me know the result.

Note:
When the database is MSDE, the value will be "SQL Server Desktop Engineer"
When the database is full SQ>, the value will be "SQL Server Standard
Edition"

II. Check the Full-Text Search Service for this instance

1. Please open Enterprise Manager;
2. Expand SHAREPOINT database
3. Please expand Support Services container;
4. Please make sure Full-Txt Search service is there. Please let me know
the result
5. Right click Full-Text Search and click properties
6. Click Refresh and confirm the following:

a. The Service Status should be started. If not, please right click this
service and click start.
b. Please check the location of database files exist and be accessible

III. We could rerun the SQL setup program and try to reinstall the
Full-Text Search service. On the Select Components page, under the
SubComponents column, select the Full-Text Search check box.

IV. Then, you may also need to re-apply the SQL service Pack 4 on the
SharePoint Database and force the upgrade of every components.

If you have any questions or concerns related to this issue, please let me
know.

I appreciate your time and look forward to hearing from you.

Best regards,

Terence Liu(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.

--------------------
| From: ryan_condon@xxxxxxxxx
| Newsgroups: microsoft.public.windows.server.sbs
| Subject: Adding Full Text Search to SBS 2003 - Yes I have searched and
Read Everything
| Date: Thu, 09 Aug 2007 16:27:27 -0000
| Organization: http://groups.google.com
| Lines: 36
| Message-ID: <1186676847.080917.117550@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
| NNTP-Posting-Host: 216.177.120.99
| Mime-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-1"
| X-Trace: posting.google.com 1186676848 13832 127.0.0.1 (9 Aug 2007
16:27:28 GMT)
| X-Complaints-To: groups-abuse@xxxxxxxxxx
| NNTP-Posting-Date: Thu, 9 Aug 2007 16:27:28 +0000 (UTC)
| Cc: rsankala@xxxxxxxxxxxxxxxxxxxxx
| User-Agent: G2/1.0
| X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET
CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
| Complaints-To: groups-abuse@xxxxxxxxxx
| Injection-Info: q3g2000prf.googlegroups.com; posting-host=216.177.120.99;
| posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0
| Bytes: 2635
| Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!newsfeed0
0.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.co
m!out01a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.u
senetserver.com!postnews.google.com!q3g2000prf.googlegroups.com!not-for-mail
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:55513
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| I have been requested to add full text searching to Company Web (Share
| Point). I am using SBS2003 with MS SQL already installed. When I
| went into Enterprise manager and clicked Properties on the SERVERNAME
| \Sharepoint database i realized it was running on MSDE.
|
| I followed the following post
|
| http://support.microsoft.com/Default.aspx?id=837367
|
| That explained exactly how to upgrade the Sharepoint DB to SQL 2000.
| I got through all task, except the upgrade to SP3 because my SQL on
| SBS was already at SP4. This should not cause a problem. When I
| follow the steps for enabling Full Text search sharepoint states
|
| "The database this server is using does not support search."
|
| I went back to enterprise manager and clicked on Properties of the
| SERVERNAME\Sharepoint and is says SQL2000 SP4 now.
|
| I also cross referenced against Mariette's website for the same
| process and I did everything she states:
|
|
http://www.smallbizserver.net/Default.aspx?tabid=266&articleType=ArticleView
&articleId=172
|
| The only thing I could figure out that maybe Sharepoint was still
| pointing to the old MSDE DB even though I upgraded. I stopped the
| SQL2000 Sharepoint server and tried to browse content and the site was
| down. I restarted and it worked again, so I believe it is pointing to
| the correct DB.
|
| Does anyone have any suggestions on next steps?
|
| Thanks
|
| Ryan
|
|

.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)