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?