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
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
Though you may give it a try by disabling the encryption first and then creating the FILESTREAM...If get nothing then the learning.
15 People are following this question.
