file stream enable 2012
-
Samstag, 14. April 2012 02:10
hi team
i m trying to enable file stream option in 2012 but i m getting below error
can you please guide me on this.
-- Enable Filestream
EXEC sp_configure filestream_access_level, 2
RECONFIGURE
GO
-- Create Database
CREATE DATABASE FileTableDB
ON PRIMARY
(Name = FileTableDB,
FILENAME = 'D:\FileTable\FTDB.mdf'),
FILEGROUP FTFG CONTAINS FILESTREAM
(NAME = FileTableFS,
FILENAME='D:\FileTable\FS')
LOG ON
(Name = FileTableDBLog,
FILENAME = 'D:\FileTable\FTDBLog.ldf')
WITH FILESTREAM (NON_TRANSACTED_ACCESS = FULL,
DIRECTORY_NAME = N'FileTableDB');
GOi m getting below error.
FILESTREAM feature is disabled.
subu
Alle Antworten
-
Samstag, 14. April 2012 02:23
http://msdn.microsoft.com/en-us/library/cc645923.aspx
On the Start menu, point to All Programs, point to Microsoft SQL Server Code-Named 2012, point to Configuration Tools, and then click SQL Server Configuration Manager.
In the list of services, right-click SQL Server Services, and then click Open.
In the SQL Server Configuration Manager snap-in, locate the instance of SQL Server on which you want to enable FILESTREAM.
Right-click the instance, and then click Properties.
In the SQL Server Properties dialog box, click the FILESTREAM tab.
Select the Enable FILESTREAM for Transact-SQL access check box.
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.
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.
Click Apply.
Chuck
-
Samstag, 14. April 2012 11:09Weird, not sure what happened with that post.
Chuck
-
Samstag, 14. April 2012 15:35
Hi Magenic,
Thanks for your reply. .. as per your suggestions i had enabled it. It is working fine now.
but i have some quries..
i have created database this option
Check the Filestream Options
SELECT DB_NAME(database_id),
non_transacted_access,
non_transacted_access_desc
FROM sys.database_filestream_options;
in the out put i got this one.
databasename id full/off
a 0 offf
b 0 off
c 2 full
What is mean by 2 and FULL
and other databases are showing 0 why ? is there any option 1 also.
please expline bit more.Tx
subu
- Als Antwort markiert Kalman TothMicrosoft Community Contributor, Moderator Mittwoch, 25. April 2012 12:47
-
Samstag, 14. April 2012 15:58
0 means that the database does not have filestream access enabled at the DB level
2? Are you sure it is not 3?
http://msdn.microsoft.com/en-us/library/gg492071.aspx
Chuck
-
Samstag, 14. April 2012 16:05
Please check following links, may help you.
-
Samstag, 14. April 2012 17:12
See http://msdn.microsoft.com/en-us/library/gg492071.aspx
Altough, 2 is not listed as a possible value...
These columns are specific to the new FileTable feature in SQL 2012.
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se -
Donnerstag, 19. April 2012 19:18ModeratorCan you please delete the bad reply and re-post but not break the thread? Thanks in advance.
For every expert, there is an equal and opposite expert. - Becker's Law
My blog -
Donnerstag, 19. April 2012 19:23
Can you please delete the bad reply and re-post but not break the thread? Thanks in advance.
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
Nope - it won't let me delete or edit it. tried that the day it happenedChuck
-
Donnerstag, 19. April 2012 19:24ModeratorI see. I am also unable to edit it. I'll send it to Brent Serbus by e-mail now (I already have a thread in the forums feedback).
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
