We help IT Professionals succeed at work.

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

Medium Priority
1,038 Views
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?
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2012

Commented:
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
CERTIFIED EXPERT
Top Expert 2012

Commented:
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.

OR

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.