Anonymous576168


We have a sql server 2000 active/passive cluster running on Windows Server 2003 and within the last 6 months have started getting the following errors which eventually cause the SQL Resource Group to failover.

An error occurred in the configuration monitor for instance <SQL Server Fulltext>: 80070005 - Access is denied.

SQL is at the latest service pack/hotfixes. (8.00.2187)

This cluster has been running fine for the past 3 years with no problems. Nothing has changed on the servers.

We've had Symantic Antivirus running on the servers for a long time but the FTDATA folder and the sql data and transaction logs are excluded and nothing has changed on the configuration.

We also run Diskeeper 2007 server on these servers but I can't see any problems with this.

Once it fails over it will run fine for several days and then the same errors will occur and it fails over again.

Any ideas on what might be causing this I can't really find anything on the Microsoft site that matches this error.

Note: This has also just started happening on our test cluster which is an identical configuration.




Re: sql cluster - fulltext error

TimDBA


It is not suggested that antivirus software is ran on a clustered sql server environment. Nothing at all has changed on the servers






Re: sql cluster - fulltext error

Anonymous

Microsoft said it was okay if we excluded certain file types and folders. We had originally asked them when we had a problem with a database a couple years ago.

No....nothing has changed. I can't find anything that tells me what it's trying to access when the access denied message is generated.