VSTO Excel 2007 addin fails to install from a network share

.net excel clickonce vsto
Jan picture Jan · Mar 7, 2011 · Viewed 8.5k times · Source

I have a VSTO addin that I published on a network share. In my company everybody is able to install and update this application from the network share. Outside of the domain I am unable to install this customization. I get following error:

Installation error screenshot

Details:

************** Exception Text **************
System.Security.SecurityException: Customized functionality in this application will not work because the certificate used to sign the deployment manifest for flow or its location is not trusted. Contact your administrator for further assistance.
   at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInTrustEvaluator.VerifyTrustPromptKeyInternal(ClickOnceTrustPromptKeyValue promptKeyValue, DeploymentSignatureInformation signatureInformation, String productName)
   at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInTrustEvaluator.VerifyTrustUsingPromptKey(Uri manifest, DeploymentSignatureInformation signatureInformation, String productName)
   at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.VerifySecurity(ActivationContext context, Uri manifest, AddInInstallationStatus installState)
   at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.InstallAddIn()
The Zone of the assembly that failed was:
MyComputer

I first thought it was a problem with the certificate. So I explicitly installed the certificate on the client machine. That didn't solve it. When I copy the flow directory to let's say my desktop I can install and run the addin without any problem. So it seems the network folder is not a trusted location. I added the path Z:/Software/Flow/ to the trusted locations in Excel options. This path automatically resolved to the full path //server/data/software/flow/. But that doesn't change anything. Anybody seen this before?

Answer

Jan picture Jan · Mar 8, 2011

I found the solution. Basically I Defined the network share as a trusted site in the intranet zone.

Related questions

'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

I'm trying to get data from an Excel file on a button click event. My connection string is: string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\source\\SiteCore65\\Individual-Data.xls;Extended Properties=Excel 8.0;"; When I click on the button, …

Read More
How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?

How can I create an Excel spreadsheet with C# without requiring Excel to be installed on the machine that's running the code?

Read More
Reading Excel files from C#

Is there a free or open source library to read Excel files (.xls) directly from a C# program? It does not need to be too fancy, just to select a worksheet and read the data as strings. So far, I've …

Read More