Deployment Issue

Nov 7, 2008 at 11:50 PM
I am using VS2008 and SQL Server 2005. I downloaded v1.7.0, read the document on codeproject and was able to run the application in VS2008. I updated the connection strings (not using SQL Express version and SQL Server authentication) and now I want to deploy the application but so far, it hasn't worked.

I tried on local IIS (6.0) but I keep getting "The user is not associated with a trusted SQL Server connection." error. The user name displayed is "" so not sure what/how user name is selected here? Code work if I run it from VS2008.

Also, I checked and SQL Server 2005 Mixed authentication is enabled. Not sure what else to look for.

Any help/pointers to fix this is much appreciated.