Posted on: 5/21/2012 7:04:09 AM | Views : 244

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 ...