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

Posted on 2009-02-16
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?
Question by:CyprexxDev
    LVL 75

    Expert Comment

    by:Anthony Perkins
    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?
    LVL 1

    Accepted Solution

    The share is on the SQL Server.  The SQL Server Service Account is a Domain Account that has SysAdmin privileges on the SQL Server.
    LVL 75

    Expert Comment

    by:Anthony Perkins
    Then I am afraid I have no idea.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Viewers will learn how the fundamental information of how to create a table.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now