when I try to create simple DB with filestream-Enabled with the following Query :
CREATE DATABASE Archive
ON
PRIMARY ( NAME = Arch1,
FILENAME = 'c:\data\archdat1.mdf'),
FILEGROUP FileStreamGroup1 CONTAINS FILESTREAM( NAME = Arch3,
FILENAME = 'c:\data\filestream1')
LOG ON ( NAME = Archlog1,
FILENAME = 'c:\data\archlog1.ldf')
GO
then it'll have the following error..
Msg 5120, Level 16, State 106, Line 1
Unable to open the physical file "c:\data\filestream1". Operating system error -2147024891: "0x80070005(failed to retrieve text for this error. Reason: 1815)".
I'm sure that every one have full-control permissions on the "c:\data\" directory.. and I'm sure that the File stream is enabled with level 1
also I tried to change the DB files location to the default sql data folder same result..
also I tried to manually create the "c:\data\filestrea ...
Go to the complete details ...