Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 The strange case of SQL full-text and the access is denied error!

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-09-18 : 11:02:10
John writes "Hi,

I have a frustrating problem which I guess is NT permissions related but must also have a relation to SQL7.

I create a full-text catalog and attempt to search it through ASP. All I ever get is Access is denied errors. The query runs fine in SQL itself and I have only had this problem since a fresh install on my development machine. My live enviroment works fine.

MS Search Service running as a system account
SQL7 SP1
IIS4
WinNT4 SP6

There is very little information on Full-text searching on the web but I understand that the full-text catalogs are not kept within SQL7 itself and SQL7 passes the query to MS Search service.

Any help would be appreciated.

With Thanks
John"
   

- Advertisement -