Hi,I'm using:Use MasterGOIF EXISTS (SELECT name FROM sys.databases WHERE name = N'UserImages')DROP DATABASE UserImagesGOUSE masterGOCREATE DATABASE [UserImages] ON PRIMARY ( NAME = N'UserImages_Primary', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\UserImages.mdf', SIZE = 11520KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )LOG ON ( NAME = N'UserImages_Log', FILENAME = N'E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data\UserImages_1.ldf' , SIZE = 32448KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)GOALTER DATABASE [UserImages] ADD FILEGROUP [FileStreamGroup] CONTAINS FILESTREAM GOALTER DATABASE [UserImages] ADD FILE (NAME = N'UserImages_FileGroup', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\UserImages_2.UserImages')TO FILEGROUP FileStreamGroupGO
to create a filestream enabled database and this returns the following error:Msg 5120, Level 16, State 106, Line 2Unable to open the physical file "D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\UserImages_2.UserImages". Operating system error -2147024891: "0x80070005(Access is denied.)".Does anyone have an idea why I get this error? The database is created but without the filestream filegroup etc. is it permissions related? If so, what permissions need to should be assigned?Thanks,Pat.FWIW, I get the same error whether creating the database from scratch (as above) or when restoring a filestream enabled db from another server.