Unable to enable FILESTREAM

I am tryign tio enable FILESTREAM in SQl 2008, I am not able to see the instance name in
I hae followed this http://technet.microsoft.com/en-us/library/cc645923.aspx
and I do not see an instance name under  SQL Server Configuration Manager.

I continue to receive the following error.
Msg 5591, Level 16, State 1, Line 1
FILESTREAM feature is disabled.
manelson05Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AndrewDizonCommented:
How to: Enable FILESTREAM

Before you can start to use FILESTREAM, you must enable FILESTREAM on the instance of the SQL Server Database Engine. This topic describes how to enable FILESTREAM by using SQL Server Configuration Manager.
 To enable and change FILESTREAM settings

   1.

      On the Start menu, point to All Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, and then click SQL Server Configuration Manager.
   2.

      In the list of services, right-click SQL Server Services, and then click Open.
   3.

      In the SQL Server Configuration Manager snap-in, locate the instance of SQL Server on which you want to enable FILESTREAM.
   4.

      Right-click the instance, and then click Properties.
   5.

      In the SQL Server Properties dialog box, click the FILESTREAM tab.
   6.

      Select the Enable FILESTREAM for Transact-SQL access check box.
   7.

      If you want to read and write FILESTREAM data from Windows, click Enable FILESTREAM for file I/O streaming access. Enter the name of the Windows share in the Windows Share Name box.
   8.

      If remote clients must access the FILESTREAM data that is stored on this share, select Allow remote clients to have streaming access to FILESTREAM data.
   9.

      Click Apply.
  10.

      In SQL Server Management Studio, click New Query to display the Query Editor.
  11.

      In Query Editor, enter the following Transact-SQL code:

      EXEC sp_configure filestream_access_level, 2
      RECONFIGURE

  12.

      Click Execute.


happy hunting
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.