To create Filestream enabled DB in Microsoft SQL Server 2012

Question

The following query is my first query on File Stream concept.

EXEC sp_configure filestream_access_level, 2  
RECONFIGURE
go
CREATE DATABASE Archive 
ON
PRIMARY ( NAME = Arch1,
    FILENAME = 'c:\data\archdat1.mdf'),
FILEGROUP FileStreamGroup1 CONTAINS FILESTREAM( NAME = Arch3,
    FILENAME = 'c:\data\filestream1')
LOG ON  ( NAME = Archlog1,
    FILENAME = 'c:\data\archlog1.ldf')
GO

First of all I go-through the following links for self learning the File Stream.

Configure Filestream Link

Create DB Link

SO answer Link

Using these links, yet I got general error as

FILESTREAM feature is disabled.

Let me show the Query, Error and DB's property

What can I do next?

Edit: 1

I did following process with help of Restart SQL Server services. Still, error remains.

To start, stop, pause, resume, or restart an instance of the SQL Server Database Engine Start SQL Server Configuration Manager, using the instructions above.

If the User Account Control dialog box appears, click Yes.

In SQL Server Configuration Manager, in the left pane, click SQL Server Services.

In the results pane, right-click SQL Server (MSSQLServer) or a named instance, and then click Start, Stop, Pause, Resume, or Restart.

Click OK to close SQL Server Configuration Manager.

We can see the Data Engine in Quotes. whereas, the link contains SQL Server services. Am I did correctly?

Thanks, TamilPugal.

Answer 1

Thanks to Dan Guzman. I got solution for my problem. That is on Enable and Configure Filestream. Under this topic.

Enabling FILESTREAM

But I have no idea about this query:

EXEC sp_configure filestream_access_level, 2

Thanks, TamilPugal