We're experiencing an error with SqlServerUploadStorageProvider as configured below: <add name="SqlServerUploadStorageProvider" type="Hitone.Web.SqlServerUploader.SqlServerUploadStorageProvider, Hitone.Web.SqlServerUploader" connectionString="Persist
Security Info=True;User ID=username;Password=password;Initial Catalog=dbname;Data Source=remotehost.com" tableName="FileList" dataColumnName="fileContent" partialFlagColumnName="partialFlag" fileNameColumnName="fileName"
mimeTypeColumnName="fileMIMEType" hashColumnName="fileHash" /> The error is: Login failed for user ''. The user is not associated with a trusted SQL Server connection. It should be noted that this used to work and has been working for
several months on a web farm. Suddenly it's no longer working. I've even installed the latest version of the Upload dlls and we're still having problems. The interesting thing is that the user in the db is specified correctly and we can connect with the password
without any problem. Also, normally this error means that the db is configured for windows authentication only, not mixed mode. But the db has always set to be mixed mode on the farm, and we can still connect with the username and password through the tool.
The tables, fields etc have also not changed.