This project has moved. For the latest updates, please go here.

SqlServerUploadStorageProvider error

Jul 10, 2010 at 12:25 AM
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.