We help IT Professionals succeed at work.

Why does the Path Name for the FileStream BLOB not work in Explorer?

Medium Priority
Last Modified: 2012-05-06
We are using the new FileStream feature of SQL Server 2008.  We have enabled the I/O streaming and allowed access to remote users and set up a share called DTFileStream through the Configuration Manager.  I have Reconfigured the database.

When I use the SELECT BLOB.PathName() query on a table, I am receiving the paths to the files.  Also, I can see the share on my Windows 2008 Server.  When I'm in Network Neighborhood and expand this server, I see the DTFileStream share listed.  The problem is, if I click on DTFileStream share (or copy and paste any path from the PathName function), I'm receiving an Access Denied error.  I don't know where I can even go to determine who has access to this share.  Any ideas?
Watch Question

Top Expert 2012

Is the share on SQL Server or on another server?  Is the SQL Server service startup account a Local System account or a domain account?
The share is on the SQL Server.  The SQL Server Service Account is a Domain Account that has SysAdmin privileges on the SQL Server.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Top Expert 2012

Then I am afraid I have no idea.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.