When you use the "sp_configure" Transact-SQL command to enable the FILESTREAM option in SQL Server 2008 or in SQL Server 2008 R2, an incorrect message is written to the SQL Server error log

Article translations Article translations
Article ID: 955861 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

When you use the sp_configure Transact-SQL command to enable the FILESTREAM option in Microsoft SQL Server 2008 or in SQL Server 2008 R2, an incorrect message is written in the SQL Server error log in response to the command. For example, assume that you run the following Transact-SQL command in the Query Editor:
EXEC sp_configure filestream_access_level, 2
GO
RECONFIGURE
GO
In this situation, the following message is written to the SQL Server error log:
<Date> <Time> spid<Number> FILESTREAM: effective level = 3, configured level = 3, file system access share name = 'MSSQLSERVER'.
Note The value for the option is set to 2, not to 3.

CAUSE

This issue occurs because the value 3 is stored internally. Therefore, the actual set value is not written to the error log.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

Because this problem does not affect SQL Server functionality, no resolution is required.
To reproduce this issue, follow these steps:
  1. Click Start, click Programs, click Microsoft SQL Server 2008, click 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 the FILESTREAM option.
  4. Right-click the instance, and then click Properties.
  5. In the SQL Server Properties dialog box, click the FILESTREAM tab.
  6. Click to select the Enable FILESTREAM for Transact-SQL access check box, and then click Apply.
  7. In SQL Server Management Studio, click New Query to display the Query Editor.
  8. In the Query Editor, enter the following Transact-SQL code:
    EXEC sp_configure filestream_access_level, 2
    GO
    RECONFIGURE
    GO
  9. Click Execute.
  10. Restart the SQL Server service.
  11. In the Query Editor, enter the following Transact-SQL code:
    EXEC sp_configure filestream_access_level, 2
    GO
    RECONFIGURE
    GO
  12. Click Execute. Notice that the message that is written to the error log incorrectly specifies a Filestream value of 3 instead of 2.

Properties

Article ID: 955861 - Last Review: July 29, 2008 - Revision: 1.2
APPLIES TO
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Workgroup
Keywords: 
kbtshoot kbbug kbprb KB955861

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com