I'm trying to connect to a SQL Server database from a web app programmed in C#/ASP.NET. It's throwing an exception that says "Login failed for user 'CISUser'. The user is not associated with a trusted SQL Server connection."

I've searched around for solutions to this problem and the only one I've come across is to change the authentication mode in the SQL Server Management Studio from "Windows Authentication" to "SQL Server and Windows Authentication". But on my machine, it's already set to "SQL Server and Windows Authentication". I've restarted the server and still I'm getting the same issue.

What else could be causing this problem?

....usb esp port is on the fritz...care to post your connection string?

Is your SQL Server configured to accept SQL Authenticated connections?

-PatP

"user id=uuu;password=ppp;server=COREDATA23\\SQLEXPRESS; Trusted_Connection = no;Database=ContractorInvoiceSystem;connection timeout=30"

I think so. When I try to connect to the server, I'm able to select "SQL Server Authentication" and it gets me in.

I'd suggest using:

"user id=uuu;password=ppp;server=COREDATA23\\SQLEXPRESS; Trusted_Connection = False;Database=ContractorInvoiceSystem;connection timeout=30"

The "no" keyword used to sometimes work with VBA and very old versions of VB. I've never seen it work with ADO.NET.

You are running your C# executable on the same machine running SQL Express, correct?

-PatP

Thanks, but unfortunately that didn't solve the problem. Any other suggestions are always welcome.