Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

FileStream Expand / Collapse
Author
Message
Posted Friday, July 2, 2010 7:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 3, 2012 6:54 AM
Points: 18, Visits: 48
Hello,

I have downloaded SQL Server Express 2008 R2 and a sample database but when I try to install the sample database it gives me an error that relates to FileStream.

I have read some forums talking about how to switch on FileStream post installation of SQL Server Express but they seemed to be directed to IT people and not novices like myself.

Can anyone explain how to switch on FileStream post installation to a dolt like me so I can install the sample database

Thanks
Phil
Post #946800
Posted Tuesday, August 10, 2010 5:53 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 9, 2011 11:23 AM
Points: 4, Visits: 18
At the Windows level, FILESTREAM is enabled either during the installation of SQL Server 2008 or by running SQL Server Configuration Manager. Here are the steps to follow:

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-SQLAccess 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.

Take a read this page: http://msdn.microsoft.com/en-us/library/cc949109%28SQL.100%29.aspx

Regards!


Knowing my objectives, feeling the road's flavors.
Post #966585
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse