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
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:
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?