Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / December 2004

Tip: Looking for answers? Try searching our database.

Full-text setup error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bogdan - 30 Dec 2004 14:16 GMT
Hi,

I'm trying to install full-text search service on SQL server using command
ftsetup.exe, but I always get error "FulltextSetup returned error code:
0x80000023".

I've upgraded MSDE with SQL Server 2000 standard . Upgrade process did not
install full-text search service, so I had to do it manually as it is
suggested in KB article 827449
(http://support.microsoft.com/default.aspx?scid=kb;en-us;827449). I've
successfuly installed Microsoft Search service (service is running), but
when I try to configure the instance of SQL Server to use the Microsoft
Search service with ftsetup command ("ftsetup.exe SQLServer 0 1 0 0 0"), it
fails. I have SQL server 2000 standard with SP3a, and MSSQLSERVER service is
running as local system account.

Can you please give me some advice how to make full-text working?

Thanx (and Happy New Year to all),
Bogdan
John Kane - 30 Dec 2004 15:56 GMT
Bogdan,
The procedures KB article 827449 are used when it is necessary to "manually
RE-install" the FT Search components on a server where these components were
install installed, but later determined that some problem occurred during
that installation. In your case, the initial FT Search components have not
been installed due to your upgrade path from MSDE to SQL Server 2000
Standard Edition. I'd recommend that you install the Full-text Search
components via your SQL Server 2000 Setup CD and select "custom
installation" and under "server components" you will see "Full-text Search"
and you should checkmark this and then the SQL Server 2000 Setup process
will install these components for you.

Thanks,
John
Signature

SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

> Hi,
>
[quoted text clipped - 16 lines]
> Thanx (and Happy New Year to all),
> Bogdan
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.