Constant error 2 querying FTS under SQL 2005

Question

Hello everyone,

We are having an issue querying a Full Text field under a SQL 2005 database.

We have a stored procedure that receives 4 parameters. One of them queries the database using full text, the other 3, LIKE. When we use only the LIKE parameters, or combine LIKE and FT parameters, everything goes fine. If we use only the FT parameter, it always cause an error 2.

Does anyone have any idea on why this could be happening, and what we could do to avoid it?

Our app is a ASP.NET one.

Thanks in advance for any help.

---

Marcelo
http://www.eopreco.com.br - Price Comparison. Need the lowest price? We find it for you.

Answer 1

Hi Marcelo,

Could you post the error message and your stored procedures?

Based on your description, it may be a connection problem, please follow this kb article:

You receive the "Microsoft SQL Server login" error message when you connect to Microsoft Project Server

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Perhaps a silly question, but:  Does the SQL Server service account have full control of the the folder where the full-text catalog is created?  

I just ask since Error 2 is often something like 'cannot find the file'.

FWIW,
RLF