Create Database With File Stream Enabaled
I am tring to create a database with Filestream option. The purpose to make a filestream database is to store images.I do have Filestream Enabled. And this is the fi开发者_开发百科rst time I am using FileStream. Here is the script that i am using to create database
Create Database AT_DEV
ON
PRIMARY (Name = FS1,
FILENAME = 'c:\data\AT_DEV.mdf'),
FILEGROUP FileSteamGrop1 CONTAINS FILESTREAM
(NAME = FS2,
FILENAME = 'c:\data\AT_DEV_fileStream1')
LOG ON
(NAME = FS_Log1,
FILENAME = 'c:\data\AT_DEV_LOG.ldf')
and I am getting this error.
Unable to open the physical file "c:\data\AT_DEV_fileStream1". Operating system error -2147024891: "0x80070005(Access is denied.)".
Am I missing something here. Thanks in advance.
I solved this issue, here is the summary: Operating system XP SP3 Sql Server 2008 R2 Enterprise version.
Microsoft is well aware of this issue and has a hotfix for this issue. http://support.microsoft.com/kb/978835
Just install this hotfix and restart your computer and try to run the script to create database again and it will work.
Hope this will help someone and will not waist as much time i did.
精彩评论