This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
Using SQL Server 2022 Standard Edition. SQL Server runs on Windows Server SRVSQL. The software client runs Windows Server SRVAPP.
When i run our software client on Windows Server SRVSQL the Filestream Documents can be saved in the SQL Server.
If i run the same Software client on the Windows SRVAPP i get the error Message "The system cannot find the path specified" when i execute "System.Data.SqlTypes.SqlFileStream.OpenSqlFileStream"
I checked the ports on the Firewall. Port 139, 445, 1434 and the SQL Server Instance Ports are open.
I logged in with the same Windows User on SRVAPP und SRVSQL.
The network looks like this: \SRVSQL\InstanceName\v02-A60EC2F8-2B24-11DF-9CC3-AF2E56D89593\INNO\dbo\DOKUMENTDATA19\DokumentData\97059726-7EDD-EF11-A22C-9B7F16CF19C0\VolumeHint-HarddiskVolume4
Cant find any further information about this issue.
Any hint is very appreciated
Kind regards
Paolo
Have you configured SQL Server for remote access to FILESTREAM:
Likewise, what does this report:
EXEC sp_configure 'filestream access level'
Hi Erland
Yes, all 3 checkbox are set.
Exec sp_configure 'filestream access level' has this result:
minimum=0, maximum=2, config_value=2, run_value=2
I can run my Testclient on the Server SRVSQL and a PDF document will be stored in SQL Server Filestreams.
Same Testclient, same Windows Login, but on another server and i get the error message: "The system cannot find the path specified"
And how did you get that path?
By the way, this may be a typo only in your post, but the path really needs to start with two backslashes, \SRVSQL\etc.
Hi Erland
Sorry, its a typo, the path begins with 2 backslashes
This is the SQL and C# Code to retrieve the Network Path:
SQL
Select DokumentData.PathName() as NetworkPath
, GET_FILESTREAM_TRANSACTION_CONTEXT() as TransactioContext
From DMSDatabase.dbo.DokumentTable10
where ID_Dokument = @ID_Dokument
and Laufnr_Dokument = @Laufnr_Dokument
C#
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
serverPath = reader.GetSqlString(0).Value;
serverTxn = reader.GetSqlBinary(1).Value;
}
}
Obvious, just Code Snippets from my Testclient which i use to Debug and print all Informations
The c# variable serverPath contains the Network Path
And how does the call to OpenSqlFilestream look like?
I did some testing on my end, and the paths I get back from filestreamcol.GetPath() looks like this:
\AGGE2\MSSQLSERVER\v02-A60EC2F8-2B24-11DF-9CC3-AF2E56D89593\Olle$DB\dbo\fstest\data\C6262B1A-386D-4B6C-98C8-9E12C8ADCD01\VolumeHint-HarddiskVolume3
That is, very much like yours. And the above path works, with the client running on a different machine. (Well, the machine that hosts the VM AGGE2.)
My gut feeling is that this is not a permissions issue - I think the error message would be different in that case.
Hi Erland
This is the way if open / retrieve a Document out of the SQL Server FileStreams
In Addition on the code i already posted im using the c# SqlFileStream Assembly
The variables "serverPath" and "serverTxn" are retrieved via the SqlDataReader
using (SqlFileStream source = new SqlFileStream(serverPath, serverTxn, FileAccess.Read))
i get a c# filestream where i can read the byte array
Im also suspecting a network issue. For me it seems, that the network path cant be resolved on the Windows Server that runs our applications.
I asked the network engineer of the customer for support. Waiting on his answer.
I did a test in my setup, where I stopped my test script just before the call to OpenSqlFilestream and made a change to the path. Indeed the error was the same as yours, The system cannot find the path specified.
Yes, agree that it sounds like there is some configuration issue.
One thing to keep in mind is that if you recently change the Filestream settings: you need to restart the SQL Server instance, or so the documentation says.
Hi Erland
Thank you very much for testing and for the hint to restart the SQL Server Instance. Im checking that.
Im doing now some recherche if there are some Network Policies or Firewall Settings that can block resolving a Network path.
Keeping you informed.
Regards Paolo
Please check that the login/user that you are using to connect to the database has enought rights on the database. also see if you can open File Explorer and connect to the FT folder Or you can open SSMS and right click over the table to browse the folder
Regrds
Javier
Hi Javier
The Windows User that i use has Select, Insert, Update, Delete and Show Definition on the Table with the FileStream.
The SQL Server Service Account has FULL Rights on the Filestream Directory.
The Filestream Share is accessible from Windows Explorer
If i execute my c# Testclient on the Windows Server where the SQL Server runs, Files are stored in the Filestream table.
If i execute my c# Testclient on another Windows Server i get the Error Message: "The system cannot find the path specified"
The SQL Server Instance can be accessed on the whole Network Lan. Just Filestreams fails.
Regards Paolo
Double post