cancel
Showing results for 
Search instead for 
Did you mean: 
jlpruk
Level 7
Report Inappropriate Content
Message 1 of 4

Problem with SQL 2008 Filestream

I have an issue with two sites that are unable to run a SQL Express 2008 database with filestream. As soon as I attempt to bring the filestream data online it generates the following sql log:

Msg 5120, Level 16, State 106, Line 1

Unable to open the physical file "C:\ProgramFiles\Microsoft SQL Server\MSSQL10.databasename\databasename_filestreamfolder".Operating system error 259: "259(failed to retrieve text for this error.Reason: 1815)".

This issue is not happening on other sites, or on computers in those sites that do not have McAfee AV/DLP installed. As soon as the McAfee products are installed the filestream data becomes inaccessible.

The are a number of 'fixes' for the SQL error on MS Technet and I have tried them all but none work. Have any of you come across this issue or have a solution? Perhaps any exclusions that should be set up to resolve this conflict?

Thanks in advance for any suggestions.

Regards,

Jon

3 Replies
jlpruk
Level 7
Report Inappropriate Content
Message 2 of 4

Re: Problem with SQL 2008 Filestream

Please note that AV is not the cause. Disabling DLP on the client resolved the conflict. The question of why SQL filestream data cannot be brought online when DLP is active is still an open question though?

Tristan
Level 15
Report Inappropriate Content
Message 3 of 4

Re: Problem with SQL 2008 Filestream

Is the problem a result of overly restirctive polices or the DLP install itself?

Have you tried removing all DLP polices (but still have DLP active) from the computer and see if the problem persists?

Message was edited by: Tristan on 20/07/11 15:15:56 IST
tonyw
Level 12
Report Inappropriate Content
Message 4 of 4

Re: Problem with SQL 2008 Filestream

What operating system are you running the DLP agent on that's causing the issue with the sql server?

More McAfee Tools to Help You
  • Subscription Service Notification (SNS)
  • How-to: Endpoint Removal Tool
  • Support: Endpoint Security
  • eSupport: Policy Orchestrator
  • Community Help Hub

      New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

    • Find Forum FAQs
    • Learn How to Earn Badges
    • Ask for Help
    Go to Community Help

    Join the Community

      Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

    • Get helpful solutions from McAfee experts.
    • Stay connected to product conversations that matter to you.
    • Participate in product groups led by McAfee employees.
    Join the Community
    Join the Community