Geek Answers Handbook

How to enable filestream in SQL Server 2008 without SQL Server Management Studio

I am trying to enable Filestream in SQL Server 2008, and I do not have the SQL Server Management Studio component installed on my computer. All the information I found already needs a management studio, how can I turn it on without it? thanks

+4
source share
4 answers

use the sqlcmd utility to enter the following commands:

USE master Go EXEC sp_configure 'show advanced options' GO EXEC sp_configure filestream_access_level, 1 GO RECONFIGURE WITH OVERRIDE GO

There are 3 FILESTREAM access levels that are supported in SQL Server 2008, and they are listed below for your reference.

  • When the specified value is 0, FILESTREAM support for the instance is disabled.
  • When the specified value is 1, FILESTREAM for Transact-SQL Access is enabled
  • When the specified value is 2, FILESTREAM for Transact-SQL and Windows Streaming is enabled

see this page ( http://www.mssqltips.com/tip.asp?tip=1838 ) for more information.

0
source

Although you can use sp_configure to set the FILESTREAM access level, the documentation notes that it has no effect unless Windows is configured using the SQL Server Configuration Tool.

Assuming the server is under your or your internal control, you can simply use RDP and use the tools installed on the server.

+1
source

You can enable part of the OS using WMI. Here are some details about this along with a downloadable script:

http://sqlsrvengine.codeplex.com/wikipage?title=FileStreamEnable

After that, you still need to enable via osql or a similar Alex_L answer.

+1
source

To enable the FILESTREAM function in SQL Server 2008, you can use SQL Server Configuration Manager:

  • Open SQL Server Configuration Manager (Start> Programs> Microsoft SQL Server 2008> Configuration Tools> SQL Server Configuration Manager)
  • Go to SQL Server node services and select the instance of SQL Server that you want to modify SQL Server
  • Go to the FILESTREAM tab and check the boxes to enable FILESTREAM and enter the share name for the files

enter image description here

+1
source

More articles:


All Articles