An unknown error has occurred related to the filter settings. verify that the parameters are valid

When I try to configure FileStream on SQL Server 2012, I get the following error.

An unknown error was detected that applied filter settings. check that the parameters are valid. (0x80041008)

I configure it using SQL Server Configuration Manager.

Where can I configure it for SQL Server 2008 R2.

+4
source share
3 answers

I had the same problem just yesterday.

In my case, it was because I had 64-bit Windows and 32-bit SQL Server.

, T-SQL, SQL, - "WOW64", .

SQL, 100%.

+3

, SQL Server 2014. , . FILESTREAM SQL Server 2012 .

, , . SQL Server 2012 (SP2, SP3 ).

+2

TL; DR

SP2 2 (SP2) SQL Server 2008 R2, .

, . , , SQL Server 2008 R2. :

Operating System: Windows 7 Ultitmate SP1 (64 Bit)
SQL Server Version: SQL Server 2008 R2 SP1

SQL Server, select @@version, :

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

SQL Server 2008 this. , SQL Server 2014 . File Stream SQL Server 2014, , .

2 (SP2) SQL Server 2008 R2, . SQL Server 2008 R2 , File Stream . SQL Server 2008 R2 SP2 .

0

Source: https://habr.com/ru/post/1526165/


All Articles