1

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.

3

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 .

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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