FileStream Not Enabled when installing AdventureWorks Databases
I was recently installing the SQL Server 2008 R2 sample databases. I was repeatedly getting an error message indicating the filestream was not enabled on the R2 OLTP database.
I checked the configuration by running sp_configure ‘filestream access level’ and sure enough, it was enabled.
I tried stopping all services and restarting with no joy. I then stumbled across the FILESTREAM tab on the SQL Server Service. I enabled the “Enable FILESTREAM for Transact-SQL access”. It’s only a test instance, so I also enabled “Enable FILESTREAM for file I/O access”.
I restarted the SQL Server Service, ran the installation file again and this time, I could install the OLTP database with no problems.