开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜