FULL-TEXT catalogs

Question

Post reply

FULL-TEXT catalogs

CooLDBA

Hall of Fame

Points: 3301
More actions
October 16, 2007 at 3:35 pm

#120801

In SQL 2000,
I have two questions:
1. Why the new full-text catalogs is disable in EM, you need to go to the server remotely to create new
full-text ctalogs, is this a bug?
2. If you disable the builtin\administrators, the full-text catalogs are not working anymore, any ideas?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Pam Brisjar SSChampion Points: 12094 More actions · Answer 1

1) Nope. It's the new security settings.

2) Again, check the security settings. The full text agent id must have domain rights.

CooLDBA Hall of Fame Points: 3301 More actions · Answer 2

Thanks for your reply, Pam.

Can you guide me where can I find the full text agent id?

Thanks again

Pam Brisjar (10/16/2007)
1) Nope. It's the new security settings.
2) Again, check the security settings. The full text agent id must have domain rights.

Pam Brisjar SSChampion Points: 12094 More actions · Answer 3

It's a Windows service account:

SQL Server FullText Search (MSSQLSERVER)

Right click, go to properties and check the Log On tab.

You also want to double-check that it's enabled in the Surface Area Configuration tool.

CooLDBA Hall of Fame Points: 3301 More actions · Answer 4

Under Services,

I don't see SQL Server FullText Search, I only see MSSQLSERVER and Microsoft Search

Pam Brisjar (10/16/2007)
It's a Windows service account:
SQL Server FullText Search (MSSQLSERVER)
Right click, go to properties and check the Log On tab.
You also want to double-check that it's enabled in the Surface Area Configuration tool.

CooLDBA Hall of Fame Points: 3301 More actions · Answer 5

I'm using SQL Server 2000,

Is there Surface Area Configuration tool in SQL2000?

Pam Brisjar (10/16/2007)
It's a Windows service account:
SQL Server FullText Search (MSSQLSERVER)
Right click, go to properties and check the Log On tab.
You also want to double-check that it's enabled in the Surface Area Configuration tool.

Pam Brisjar SSChampion Points: 12094 More actions · Answer 6

No, the surface area configuration tool is a feature of 2005. You need to post your questions to a SQL Server 2000 forum as Full text works differently.