2005 Full Text Error

I'm having problems creating a new Full Text index in 2005. My environment:
Windows 2003 SP1 Ent Cluster (Active/Active)
SQL 2000 SP4 on one side SQL 2005 on the other.
When I go to create a new index using the GUI, as soon as I click on "new
Full-Text Catalog..." I get this error:
Property DefaultPath is not available for FullTextService
'[LON-IMSSQL01\IMS]'. This property may not exist for this object, or may not
be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)
But the screen does load and it does let me create the catalogue with no
problems.
Then I go to add a table and column. When I press OK I get this error:
Full-text crawl manager has not been initialized. Any crawl started before
the crawl manager was fully initialized will need to be restarted. Please
restart SQL Server and retry the command. You should also check the error log
to fix any failures that might have caused the crawl manager to fail.
(Microsoft SQL Server, Error: 7644)
Press OK to that error and the FT Cataloge screen closes and I get this error:
Index was out of range. Must be non-negative and less than the size of the
collection.
Parameter name: index (mscorlib)
If I go back into the catalogue screen The Eligilble colums box appears as a
white box with a nice big red cross over it.
There are no errors logged in the SQL event log or windows log. I have
rebooted, restarted, failed over and re-installed full text using:
start /wait D:\2005\servers\setup.exe /qb REINSTALL=SQL_FullText
INSTANCENAME=IMS REINSTALLMODE=M
But still I get the same problem. Can someone please help me!?!?
Thanks
Simon
Simon,
An interesting error - "Property DefaultPath is not available for
FullTextService This property may not exist for this object, or may not be
retrievable due to insufficient access rights". Could you post the file or
text from the SQFT log file (SQLFT0000900005.LOG) where 9 is the dbid and 5
the FTCatid under the \MSSQL.1\MSSQL\LOG directory where you have SQL Server
2005 installed? Did you have any problems installing SQL Server 2005? This
may be an installation problem or something else, so perhaps, more info will
be recorded in the SQLFT log file.
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:065E5E9B-FC6E-4621-9CF8-10EB282BB633@.microsoft.com...
> I'm having problems creating a new Full Text index in 2005. My
> environment:
> Windows 2003 SP1 Ent Cluster (Active/Active)
> SQL 2000 SP4 on one side SQL 2005 on the other.
> When I go to create a new index using the GUI, as soon as I click on "new
> Full-Text Catalog..." I get this error:
> Property DefaultPath is not available for FullTextService
> '[LON-IMSSQL01\IMS]'. This property may not exist for this object, or may
> not
> be retrievable due to insufficient access rights.
> (Microsoft.SqlServer.Smo)
> But the screen does load and it does let me create the catalogue with no
> problems.
> Then I go to add a table and column. When I press OK I get this error:
> Full-text crawl manager has not been initialized. Any crawl started before
> the crawl manager was fully initialized will need to be restarted. Please
> restart SQL Server and retry the command. You should also check the error
> log
> to fix any failures that might have caused the crawl manager to fail.
> (Microsoft SQL Server, Error: 7644)
> Press OK to that error and the FT Cataloge screen closes and I get this
> error:
> Index was out of range. Must be non-negative and less than the size of the
> collection.
> Parameter name: index (mscorlib)
> If I go back into the catalogue screen The Eligilble colums box appears as
> a
> white box with a nice big red cross over it.
> There are no errors logged in the SQL event log or windows log. I have
> rebooted, restarted, failed over and re-installed full text using:
> start /wait D:\2005\servers\setup.exe /qb REINSTALL=SQL_FullText
> INSTANCENAME=IMS REINSTALLMODE=M
> But still I get the same problem. Can someone please help me!?!?
> Thanks
> Simon
|||I did have problems with the install. I couldn't install using the GUI,
though it worked from the command line. I also installed FT seperatly (from
command line) after the original install. I think the install problem was
being casued by installing DTS (I'll explain later).
Anyway, I unistalled both all 2005 components (again from command line as
the GUI errored). Then reinstalled SQL, and FT & DTS is one go from command
line, this failed - it was unable to start the scheduled task on the 2nd node
because of a permissions error - though looking through the logs I could see
setup.exe failed with a fatal exception.
So I tried the install again with just SQL and FT from command line - it
worked perfectly and FT appears to be fine now. I still can't install DTS -
but I guess I'll just have to live without it.
Unfortunatly I didn't keep the FT logs - I cleared all folders before
reinstalling. I do however have all my install logs (there's a lot of them).
But I think this will probably go down as "one of those things". After all
the product was only released yesterday.
Thanks for you help anyway.
Simon
"John Kane" wrote:

> Simon,
> An interesting error - "Property DefaultPath is not available for
> FullTextService This property may not exist for this object, or may not be
> retrievable due to insufficient access rights". Could you post the file or
> text from the SQFT log file (SQLFT0000900005.LOG) where 9 is the dbid and 5
> the FTCatid under the \MSSQL.1\MSSQL\LOG directory where you have SQL Server
> 2005 installed? Did you have any problems installing SQL Server 2005? This
> may be an installation problem or something else, so perhaps, more info will
> be recorded in the SQLFT log file.
> Thanks,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Simon" <Simon@.discussions.microsoft.com> wrote in message
> news:065E5E9B-FC6E-4621-9CF8-10EB282BB633@.microsoft.com...
>
>
|||You're welcome, Simon,
Great news! Although, its a shame that you don't have the FTS log file as
that could of been helpful info for helping others troubleshoot similar
problems in the future with SQL Server 2005 as I'm very positive there will
be more such situations! <G>
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:43E21A03-80DA-4AFA-B1E5-48B0BE52D2C7@.microsoft.com...[vbcol=seagreen]
>I did have problems with the install. I couldn't install using the GUI,
> though it worked from the command line. I also installed FT seperatly
> (from
> command line) after the original install. I think the install problem was
> being casued by installing DTS (I'll explain later).
> Anyway, I unistalled both all 2005 components (again from command line as
> the GUI errored). Then reinstalled SQL, and FT & DTS is one go from
> command
> line, this failed - it was unable to start the scheduled task on the 2nd
> node
> because of a permissions error - though looking through the logs I could
> see
> setup.exe failed with a fatal exception.
> So I tried the install again with just SQL and FT from command line - it
> worked perfectly and FT appears to be fine now. I still can't install
> DTS -
> but I guess I'll just have to live without it.
> Unfortunatly I didn't keep the FT logs - I cleared all folders before
> reinstalling. I do however have all my install logs (there's a lot of
> them).
> But I think this will probably go down as "one of those things". After all
> the product was only released yesterday.
> Thanks for you help anyway.
> Simon
>
>
> "John Kane" wrote: