[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1025
  • Last Modified:

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

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?
0
CyprexxDev
Asked:
CyprexxDev
  • 2
1 Solution
 
Anthony PerkinsCommented:
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?
0
 
CyprexxDevAuthor Commented:
The share is on the SQL Server.  The SQL Server Service Account is a Domain Account that has SysAdmin privileges on the SQL Server.
0
 
Anthony PerkinsCommented:
Then I am afraid I have no idea.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now