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
 General SQL Server Forums
 New to SQL Server Programming
 Execution of a full-text operation failed. 'Access

Author  Topic 

megetron
Starting Member

2 Posts

Posted - 2008-12-09 : 05:39:24
Hello,

After run scripts that using full-text operations (one of the components that comes with SQL Express installation) I recieve errors:
Execution of a full-text operation failed. 'Access is denied.'

I was trying to google on this, and could find the reason but not the solution.
It seems like the problem is that Sql Server instance (SQLEXPRESS) logged on as "LocalSystem" user, and SQL Server FullText Search (SQLEXPRESS) logged on as NT AUTHORITY\NetworkService.
(You can check this on Sql Server Configuration Manager)

I assume that it expects both instances to be on the same user.

The problem is whenever I am trying to change the Sql Server instance user to be NT AUTHORITY\NetworkService I recieve error messege:
"No Mapping between account names and security IDs was done"

So now I am out of ideas....do you have some?
I appreciete any help to come.
   

- Advertisement -