How to install and get FILESTREAM working using SQL Server 2008 and Windows XP

by Heathesh 14. July 2011 00:43

To simplify this I'm just going to give you a step by step of what I did, I hope this helps you. If you have any problems with it please feel free to use my Contact page to get in touch and see if I can help you.

1. Run the Sql Server Configuration Manager

All Programs --> Microsoft Sql Server 2008 --> Configuration Tools --> Sql Server Configuration Manager

2. Select "SQL Server Services" which will populate the frame on the right, then right click and select "Properties" on the SQL Server Instance you want to enable this on

3. Select the FILESTREAM tab, check all the checkboxes on the tab

4. Click "Apply" then "OK"

5. Close the "Sql Server Configuration Manager", and open SQL Server Management Studio.

6. Connect to your SQL instance and then right click the instance name and select "Restart".

7. Next select "New Query".

8. Copy and paste the following into the window and run it, you only need to change "[Your Database Name]" to whatever the database you're trying to enable the filestream on:

EXEC sp_configure filestream_access_level, 2

RECONFIGURE

alter database [Your Database Name]
add FILEGROUP [MY_FILESTREAM] CONTAINS FILESTREAM


8. Install the following hotfix:

http://hotfixv4.microsoft.com/Windows%20XP/sp4/Fix303510/2600/free/403099_ENU_i386_zip.exe

If that link above is broken for whatever reason, you'll have to download the hotfix by starting here:

http://support.microsoft.com/?id=978835

They require you to supply them with your email address for some reason, I have no idea why.

9. Restart your PC.

10. Once restarted, open "SQL Server Management Studio" and run this (feel free to change the file location if you need to):

alter database [Your Database Name]
add FILE ( NAME = N'my_filestream', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQL2008\MSSQL\DATA\MyFileStream.Repository' )
TO filegroup [MY_FILESTREAM]


That should be it. Happy streaming!

Tags: , ,



Powered by BlogEngine.NET 1.5.0.7 (with enhancements by Heathesh)
Theme by Mads Kristensen (with tweeks by Heathesh)

Certifications

Microsoft Certified Professional

Microsoft Certified Technology Specialist

Answer Questions

 

Tag cloud

Calendar

<<  August 2014  >>
MoTuWeThFrSaSu
28293031123
45678910
11121314151617
18192021222324
25262728293031
1234567

View posts in large calendar

http://heathesh.com