Symptoms:
Creating Cache Database Error: Server was unable to process the request. The system cannot find the file specified.
Solution:
Check the following in your Web Server machine.
1. Make sure the "NETWORK SERVICE" user account has Read and Write Permissions in the Web Service folder.
2. Make sure that the SQL server installed should have the capability of using the BCP Utility. If you don't want to install a SQL Server instance on your server, you only need to install two components, which are as follows;
Microsoft® SQL Server® 2008 R2 SP3 Native Client (sqlncli.msi 7.8MB)
Microsoft® SQL Server® 2008 R2 SP3 Command Line Utilities (SqlCmdLnUtils.msi 12.0MB)
Here is the link to download the 2 components:
https://www.microsoft.com/en-us/download/details.aspx?id=44272
3. Verify and check that this location exists in your server. C:\Program Files\Microsoft SQL Server\100\Tools\Binn
4. You need to add the location of your SQL Command Line Utilities or BCP.exe in the System Path advance Preference.
For Server:
1. Right-click on the My Computer > Select Properties > Select Advanced
2. Open the Environment Variables.
3. In the System Variables, find the Path variable > Select Edit > Append the location of the BCP.exe.Sample location: C:\Program Files\Microsoft SQL Server\100\Tools\Binn
Applicable Products:
All Connected Business Versions
