FIX: Error message when you try to enable FILESTREAM settings in SQL Server 2008: “There was an unknown error applying the FILESTREAM settings”

View products that this article applies to.

SYMPTOMS

You try to enable FILESTREAM settings by using SQL Server Configuration Manager in Microsoft SQL Server 2008. When you do this, you may receive the following error message:

There was an unknown error applying the FILESTREAM settings. Check the parameters are valid

This problem occurs after you upgrade to SQL Server 2008.

Back to the top

CAUSE

This problem occurs because the Filestream file share resource expects the following Microsoft Windows NT path:

\\?\GlobalRoot\Device\RsFx0102\MSSQLSERVER

However, the Cluster service does not accept a Windows NT path.

Back to the top

RESOLUTION

To resolve this problem, install hotfix 937444.

For more information about how to do this, click the following article number to view the article in the Microsoft Knowledge Base:

937444 (http://support.microsoft.com/kb/937444/ ) Error message when you try to create a cluster file share resource in a Windows Server 2003-based cluster: "System error 87 has occurred (0X00000057)"

Back to the top