MSFT News Aggregator » FILESTREAM Configuration and Setup Changes in SQL Server 2008 …

Tue, 04 Mar 2008 02:59:15 GMT

PingBack from http://msft.starsports.info/msft/filestream-configuration-and-setup-changes-in-sql-server-2008/

re: FILESTREAM Configuration and Setup Changes in SQL Server 2008 February CTP

ktegels — Sun, 23 Mar 2008 18:28:21 GMT

So this begs the questions:

1. If I don't want to do this during setup and a prefer to write to T-SQL scripts, do I really need use the SP_CONFIGURE option (e.g.. will sp_filestream_configure continue to be supported)?

1a. Clarifying q1, which of this lis actually needed to fully configure a filestream share via T-SQL only?

a. EXEC sp_configure 'filestream_access_level', '0'

b. RECONFIGURE

c1. declare @sn sysname = N'MusicShare';

c2. exec sp_filestream_configure @enable_level = 3, @share_name = @sn;

2. If I don't use the configureation tools and sp_filestream_configure is removed, how do I enable the share name?

Thanks!

re: FILESTREAM Configuration and Setup Changes in SQL Server 2008 February CTP

OmelJ - MSFT — Fri, 28 Mar 2008 01:40:01 GMT

sp_filestream_configure will be removed from the product. To specify a share name without having to go thru the SQL Configuration Manager UI, you can use the WMI scripting CM support. Here is a sample VBS script on how to do that (note that this requires Windows admin privilege, just like SQL CM, FILESTREAM functionality still requires the the SQL admin to call sp_configure/reconfigure):

' USAGE:

' cscript filestream_enable.vbs [/Machine:<MachineName>] [/Instance:<InstanceName>] [/Level:<0|1|2|3>] [/Share:<ShareName>]

On Error Resume Next

Err.Clear()

InstanceName = "MSSQLSERVER"

MachineName = "."

TargetLevel = 3

ShareName = ""

If WScript.Arguments.Named.Exists("Machine") Then

MachineName = WScript.Arguments.Named("Machine")

End If

If WScript.Arguments.Named.Exists("Instance") Then

InstanceName = WScript.Arguments.Named("Instance")

End If

If WScript.Arguments.Named.Exists("Level") Then

TargetLevel = WScript.Arguments.Named("Level")

End If

If WScript.Arguments.Named.Exists("Share") Then

ShareName = WScript.Arguments.Named("Share")

End If

WScript.Echo "Machine: " & MachineName

WScript.Echo "Instance: " & InstanceName

WScript.Echo "Level: " & TargetLevel

WScript.Echo "ShareName: " & ShareName

WScript.Echo vbNewLine & "Current Filestream configuration:"& vbNewLine

set fsInstance = GetObject("WINMGMTS:\\" & MachineName & "\root\Microsoft\SqlServer\ComputerManagement10:FilestreamSettings='" & InstanceName & "'")

If Err.Number <> 0 Then

If Err.Number = -2147217396 Then

WScript.Echo "WBEM_E_NOT_SUPPORTED == IDS_FILESTREAM_NOT_SUPPORTED_ON_INSTANCE (0x8004100C : -2147217396)"

Else

WScript.Echo "Unknown error calling GetObject for FilestreamSettings object "

WScript.Echo "Error: " & Err.Number & " Description: " & Err.Description

End If

return Err.Number

End If

WScript.Echo "InstanceName = " & fsInstance.InstanceName

WScript.Echo "AccessLevel = " & cstr(fsInstance.AccessLevel)

WScript.Echo "ShareName = " & fsInstance.ShareName

WScript.Echo "RsFxVersion = " & fsInstance.RsFxVersion

WScript.Echo vbNewLine & "Calling method EnableFilestream with new level" & vbNewLine

Set method = fsInstance.Methods_("EnableFilestream")

Set inParam = method.inParameters.SpawnInstance_()

inParam.AccessLevel = TargetLevel

inParam.ShareName = ShareName

Set outParam = fsInstance.ExecMethod_("EnableFilestream", inParam)

If outParam.returnValue = 0 Then

WScript.Echo "Method executed successfully" & vbNewLine

Else

WScript.Echo "Method failed: hr = " & cstr(outParam.returnValue)

' WBEM_E_NOT_SUPPORTED == IDS_FILESTREAM_NOT_SUPPORTED_ON_INSTANCE (0x8004100C : -2147217396) (Thrown at GetObject time)

' WBEM_E_INVALID_OPERATION == IDS_FILESTREAM_CANNOT_CHANGE_SHARE (0x80041016 : -2147217386)

' HRESULT_FROM_WIN32 (ERROR_ALREADY_EXISTS) == IDS_FILESTREAM_DUP_SHARE_NAME (0x800700B7 : -2147024713)

' HRESULT_FROM_WIN32 (ERROR_ACCESS_DENIED) == IDS_FILESTREAM_ACCESS_DENIED (0x80070005 : -2147024891)

' HRESULT_FROM_WIN32 (ERROR_INVALID_SHARENAME) == IDS_FILESTREAM_INVALID_SHARENAME (0x800704BF : -2147023681)

' HRESULT_FROM_WIN32 (ERROR_FILENAME_EXCED_RANGE) == IDS_FILESTREAM_SHARENAME_TOO_LONG (0x800700CE : -2147024690)

' HRESULT_FROM_WIN32 (ERROR_RESOURCE_NOT_FOUND) == IDS_FILESTREAM_PRIMARY_NODE_NOT_ENABLED (0x8007138F : -2147019889)

' HRESULT_FROM_WIN32 (ERROR_CLUSTER_INVALID_REQUEST) == IDS_FILESTREAM_SHARENAME_NODE_MISMATCH (0x800713B8 : -2147019848)

' HRESULT_FROM_WIN32 (ERROR_SUCCESS_RESTART_REQUIRED) == IDS_FILESTREAM_DISABLED_RESTART (0x80070bc3 : -2147021885)

' WBEM_E_INVALID_PARAMETER == IDS_FILESTREAM_GENERAL_ERROR (0x80041008 : -2147217400)

If outParam.returnValue = -2147217386 Then

WScript.Echo "WBEM_E_INVALID_OPERATION == IDS_FILESTREAM_CANNOT_CHANGE_SHARE (0x80041016 : -2147217386)"

Else If outParam.returnValue = -2147024713 Then

WScript.Echo "HRESULT_FROM_WIN32 (ERROR_ALREADY_EXISTS) == IDS_FILESTREAM_DUP_SHARE_NAME (0x800700B7 : -2147024713)"

Else If outParam.returnValue = -2147024891 Then

WScript.Echo "HRESULT_FROM_WIN32 (ERROR_ACCESS_DENIED) == IDS_FILESTREAM_ACCESS_DENIED (0x80070005 : -2147024891)"

Else If outParam.returnValue = -2147023681 Then

WScript.Echo "HRESULT_FROM_WIN32 (ERROR_INVALID_SHARENAME) == IDS_FILESTREAM_INVALID_SHARENAME (0x800704BF : -2147023681)"

Else If outParam.returnValue = -2147024690 Then

WScript.Echo "HRESULT_FROM_WIN32 (ERROR_FILENAME_EXCED_RANGE) == IDS_FILESTREAM_SHARENAME_TOO_LONG (0x800700CE : -2147024690)"

Else If outParam.returnValue = -2147019889 Then

WScript.Echo " HRESULT_FROM_WIN32 (ERROR_RESOURCE_NOT_FOUND) == IDS_FILESTREAM_PRIMARY_NODE_NOT_ENABLED (0x8007138F : -2147019889)"

Else If outParam.returnValue = -2147019848 Then

WScript.Echo "HRESULT_FROM_WIN32 (ERROR_CLUSTER_INVALID_REQUEST) == IDS_FILESTREAM_SHARENAME_NODE_MISMATCH (0x800713B8 : -2147019848)"

Else If outParam.returnValue = -2147021885 Then

WScript.Echo "HRESULT_FROM_WIN32 (ERROR_SUCCESS_RESTART_REQUIRED) == IDS_FILESTREAM_DISABLED_RESTART (0x80070bc3 : -2147021885)"

Else If outParam.returnValue = -2147217400 Then

WScript.Echo "WBEM_E_INVALID_PARAMETER == IDS_FILESTREAM_GENERAL_ERROR (0x80041008 : -2147217400)"

End If

WScript.Echo vbNewLine & vbNewLine & "New Filestream configuration:"& vbNewLine

set fsInstance = GetObject("WINMGMTS:\\" & MachineName & "\root\Microsoft\SqlServer\ComputerManagement10:FilestreamSettings='" & InstanceName & "'")

WScript.Echo "InstanceName = " & fsInstance.InstanceName

WScript.Echo "AccessLevel = " & cstr(fsInstance.AccessLevel)

WScript.Echo "ShareName = " & fsInstance.ShareName

WScript.Echo "RsFxVersion = " & fsInstance.RsFxVersion

re: FILESTREAM Configuration and Setup Changes in SQL Server 2008 February CTP

ankitmalpani — Wed, 21 May 2008 02:53:33 GMT

I tried enabling Filestream during installation but post installation it appears diabled. Even on retrying after installation (using Sql Configuration Manager) does not work.

If I try to do it from sqlcmd I get the following error :

The current user does not have permissions to configure the FILESTREAM feature. To configure the FILESTREAM feature, Windows Administrator and sysadmin rights are required.

But I (this user) am a Windows Administrator.

Am I miising something here??

re: FILESTREAM Configuration and Setup Changes in SQL Server 2008 February CTP

ankitmalpani — Wed, 21 May 2008 02:53:40 GMT

I tried enabling Filestream during installation but post installation it appears diabled. Even on retrying after installation (using Sql Configuration Manager) does not work.

If I try to do it from sqlcmd I get the following error :

The current user does not have permissions to configure the FILESTREAM feature. To configure the FILESTREAM feature, Windows Administrator and sysadmin rights are required.

But I (this user) am a Windows Administrator.

Am I missing something here??

Enabling the FILESTREAM datatype on SQL Server 2008

Chris Roland — Wed, 25 Mar 2009 23:35:24 GMT

Enabling the FILESTREAM datatype on SQL Server 2008