no assembly associated with Xml key a2

Question

We are an existing CompleteFTP customer (professional version). I have created a stand-alone test server (Windows 2012 R2 Standard - not domain joined) and downloaded and installed a trial in order to experiment with external database users (I selected Professional version).  I am able to setup the Connection-string and test it successfully to a SQL Server 2012 installed on the same machine, but when I try the "Test login" button. I get  the following:

System.Runtime.Serialization.SerializationException: Parse Error, no assembly associated with Xml key a2:http://schemas.microsoft.com/clr/nsassem/System.Data.SqlClient/System.Data%2C%20Version%3D4.0.0.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Db77a5c561934e089 SqlException
   at System.Runtime.Serialization.Formatters.Soap.SoapHandler.ProcessGetType(String value, String xmlKey, String& assemblyString)
   at System.Runtime.Serialization.Formatters.Soap.SoapHandler.ProcessType(ParseRecord pr, ParseRecord objectPr)
   at System.Runtime.Serialization.Formatters.Soap.SoapHandler.ProcessAttributes(ParseRecord pr, ParseRecord objectPr)
   at System.Runtime.Serialization.Formatters.Soap.SoapHandler.StartChildren()
   at System.Runtime.Serialization.Formatters.Soap.SoapParser.ParseXml()
   at System.Runtime.Serialization.Formatters.Soap.SoapParser.Run()
   at System.Runtime.Serialization.Formatters.Soap.ObjectReader.Deserialize(HeaderHandler handler, ISerParser serParser)
   at System.Runtime.Serialization.Formatters.Soap.SoapFormatter.Deserialize(Stream serializationStream, HeaderHandler handler)
   at System.Runtime.Serialization.Formatters.Soap.SoapFormatter.Deserialize(Stream serializationStream)
   at EnterpriseDT.Net.FtpServer.Core.RemoteMethodInvoker.InvokeBySOAP(SecureFTPConnection ftp, Type plugInInterface, String plugInName, String methodName, Object[] methodArguments)
   at EnterpriseDT.Net.FtpServer.Core.PlugInProxyBase.InvokeBySOAP(String plugInName, String methodName, Object[] methodArguments)
   at QZxbQufogAF8MRhA8w.HeEmsgsv3AmmVxQYoS.COOFfnrBZx(Boolean , String , String , Object[] methodArguments)
   at QZxbQufogAF8MRhA8w.HeEmsgsv3AmmVxQYoS.ExecuteAdHocQuery(String , String , String )
   at EnterpriseDT.Net.FtpServer.Manager.View.Extension.DBAuth.DBAuthEditor.pn9D6Q937gB(Object , EventArgs )

It doesn't seem to matter whether I use a stored procedure or an inline query.

Answer 1

Apparently, any failure in the database results in the same message. The root cause for my situation was that permissions on the database were insufficient to run the query I was trying to run.  Once I fixed the permissions, I could get to the next step.

Comments

Thank you for sharing your solution!