Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a SQL Server 2008 instance. I have configured filestream access properly, and use it from one column on one table in one of my databases. However, I cannot access the UNC share for the filestream data. I have tried browsing to it as well as trying to open specific files and I get errors both ways.

I am running SQL Server 2008 enterprise on a Windows 7 workstation running on the domain. I've tried running the sql server service as a local user, then as network admin. The user I am logged in as is a local admin and a sysadmin in SQL server.

share|improve this question

1 Answer 1

up vote 3 down vote accepted

This is not how filestream works - you don't browse the share and open files directly. You need to go through SQL Server to obtain a logical file path and transaction context and then use these two when opening the file (either using Win32 OpenSqlFilestream API or .Net SqlFileStream class). Here's a tutorial on how to access filestream data from windows applications: Managing FILESTREAM Data by Using Win32 .

share|improve this answer
    
Looks like you are right. –  Justin Dearing Apr 19 '10 at 19:56

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.