question

FBG25 avatar image
FBG25 asked

FILESTREAM and encrypted drives

I have a script to configure FILRSTREAM support and create a database to use it. Works fine on a number of servers. But recently I ran into an issue when trying to configure it on a couple of laptops that have hard drives encryption enabled by our IT department. I am getting an error: [center]Msg 5120, Level 16, State 106, Line 2 Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\EmpowerOneFileStream". Operating system error 259: "259(No more data is available.)".[/center] Here is the script: USE [master] GO IF EXISTS (SELECT name FROM sys.databases WHERE name = N'MyFSDB') DROP DATABASE [MyFSDB] GO USE [master] GO CREATE DATABASE [MyFSDB] ON PRIMARY ( NAME = N'MyFSDB', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\MyFSDB.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) ,FILEGROUP [EmpowerOneFileStreamGroup] CONTAINS FILESTREAM DEFAULT ( NAME = N'EmpowerOneFS', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\EmpowerOneFileStream' ) LOG ON ( NAME = N'EmpowerOne_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\EmpowerOne_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO Msg 5120, Level 16, State 106, Line 2 Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\EmpowerOneFileStream". Operating system error 259: "259(No more data is available.)". Any help would be greatly appreciated. Thanks, FB
sql-server-2008-r2encryptionfilestream
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
VishalhSingh avatar image
VishalhSingh answered
Aah..it hurts here. To what I know, SQL Server doesn't seems to be friendly with disk encryption. As MS states we can;t even install SQL Server on a drive which is encrypted with BitLocker (I believe more or less same story with other encryption methods/tools) You may read more [ here][1] A similar scenario like your can be found [here][2] A silver line in sky is not every encryption tools/methods make this to SQL Server so you need to firstly check which tools/methods are used to encrypt the hard drive where you are trying to create FILESTREAM and then if you are lucky that it's not Bitlocker you may get in touch with vendor of that tool. [1]: http://technet.microsoft.com/en-in/library/cc732774.aspx [2]: http://stackoverflow.com/questions/12273626/error-when-creating-db-with-a-filestream
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Though you may give it a try by disabling the encryption first and then creating the FILESTREAM...If get nothing then the learning.
0 Likes 0 ·
Thanks VishalhSingh , I saw the the posting from Gary Brunton that you've mentioned, but was not sure if this is really a case... FB.,
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.