Last post Nov 11, 2020 08:52 PM by PaulTheSmith
Nov 02, 2020 07:03 AM|sureshamsala|LINK
I am trying to generate a report by using SQL Server 2008 R2 File Stream and WCF Service. I am able to generate reports if the service is hosted in the same server which database is located i.e. Database and service is hosted in the same server.
If I hosted the service in different server I am getting the "System.ComponentModel.Win32Exception (0x80004005): The system cannot find the path specified" exception. I have given all the necessary permissions to the SQL FileStream share location like IIS_User,
Everyone etc and I am able to access the share path from the new server also. Still getting the same error.
Please help me to get out this.
Nov 03, 2020 07:51 AM|XuDong Peng|LINK
Based on your description, I did some searches on the issue.
The possible causes of this issue are:
You could also get more possible information from the detailed errorlogs.
Nov 04, 2020 01:24 PM|sureshamsala|LINK
Hi XuDong Peng,
Thanks for reply, I have tried the possible causes but no luck
Note: I am able to ping the Database server from Web server.
Am I missing anything regarding permission ?
Nov 09, 2020 07:36 AM|XuDong Peng|LINK
I think the most effective solution is to find the cause of the problem step by step from the detailed error loggings.
In addition, I found the following two cases, hope they can help you.
WCF + The system cannot find the file specified + Error
Adding service reference gives the system cannot find the path specified error
Nov 10, 2020 09:22 PM|PaulTheSmith|LINK
What is the path you are specifying? If it can't be found then it is probably wrong. Show your code!
(Note that this is not asking what do you think the path is but rather "What is actually happening at runtime")
Nov 11, 2020 08:37 AM|sureshamsala|LINK
The file path is not a normal file path. It's generated by the SQL server 2008(which is integrated within it) and can't be used like other normal file path. It looks like below:
which can't be access via folder. The application runs fine when both SQL server and application is running from same machine and in the same way, the above path is not accessible from the explorer.
Nov 11, 2020 08:52 PM|PaulTheSmith|LINK
Is this what you are talking about?
(Step 8 looks interesting).
I would suggest that you ask in a SQL/Server forum. If "which can't be access via folder" is true then this doesn't seem to have much to do with ASP.Net