SQL Service wont Auto Start with Mcafee McShield enabled

"John Bell" wrote in message

> On Sun, 28 Mar 2010 13:32:37 -0400, "Neil W" wrote:
>
>>On certain customer machines, the SQL Server service won't AutoStart when
>>McAfee McShield (on access scan) is enabled. I have tried specifically
>>excluding the SQL Binn and Data directories, but still no luck. I have to
>>actually disable the McShield Service, or make SQL dependent on the
>>McShield
>>Service so it starts up after McShield.
>>
>>The customer is using SQL 2005 Express and McAfee VirusScan Enterprise +
>>AntiSpyware Enterprise 8.5.0i with Patch 8" on XP Pro.
>>
>>Is this a known issue with McShield? I posted on a McAfee community board
>>as
>>well but no responses.
>>
>>Thanks for any tips or suggestions.
>>
> Hi
>
> What does the SQL Server Error log or even the Windows Event log say?
> I would have thought that assuming your log files are in the data
> directory then you would be ok. Do you need to exclude the
> directories for schedule scans?
>
> John

Thanks for the reply. Interestingly enough, there is no error log created.
The directories are excluded from on-access scanning. I haven't tried
excluding them from on-demand scanning.

No problem starting manually at any time. And no problem auto starting if
McShield is disabled, or if SQL is dependent on McShield (or vice versa).
Apparently the system does not like trying to start them both at the same
time. Haven't see this with any other AV software, and only happens on a few
similarly configured machines. They are running XP Pro btw.
 >> Stay informed about: SQL Service wont Auto Start with Mcafee McShield enabled 

If something in startup doesn't start, there should be _something_ in the
Windows event log. After all, it logs when it starts, so it should log when
it fails.

Not having anything in the SQL Server log, while disappointing, isn't very
surprising (if the error occurs early enough).

Worse case, I like your idea of setting the dependencies, even though I
think you reversed them in your description.

--
Jay Konigsberg
SQL Server DBA in Sacramento, CA
http://www.linkedin.com/in/jaykonigsberg

Live in Sacramento, CA?
Join the Sacramento SQL Server User Group on LinkedIn
http://www.linkedin.com/groups?home=&gid=2825448&trk=anet_ug_hm&goback=%2Emyg



"Neil W" wrote in message

> "John Bell" wrote in message
>
>> On Sun, 28 Mar 2010 13:32:37 -0400, "Neil W" wrote:
>>
>>>On certain customer machines, the SQL Server service won't AutoStart when
>>>McAfee McShield (on access scan) is enabled. I have tried specifically
>>>excluding the SQL Binn and Data directories, but still no luck. I have to
>>>actually disable the McShield Service, or make SQL dependent on the
>>>McShield
>>>Service so it starts up after McShield.
>>>
>>>The customer is using SQL 2005 Express and McAfee VirusScan Enterprise +
>>>AntiSpyware Enterprise 8.5.0i with Patch 8" on XP Pro.
>>>
>>>Is this a known issue with McShield? I posted on a McAfee community board
>>>as
>>>well but no responses.
>>>
>>>Thanks for any tips or suggestions.
>>>
>> Hi
>>
>> What does the SQL Server Error log or even the Windows Event log say?
>> I would have thought that assuming your log files are in the data
>> directory then you would be ok. Do you need to exclude the
>> directories for schedule scans?
>>
>> John
>
> Thanks for the reply. Interestingly enough, there is no error log
> created.
> The directories are excluded from on-access scanning. I haven't tried
> excluding them from on-demand scanning.
>
> No problem starting manually at any time. And no problem auto starting if
> McShield is disabled, or if SQL is dependent on McShield (or vice versa).
> Apparently the system does not like trying to start them both at the same
> time. Haven't see this with any other AV software, and only happens on a
> few similarly configured machines. They are running XP Pro btw.
>
>
>
>
 >> Stay informed about: SQL Service wont Auto Start with Mcafee McShield enabled