I'm trying to connect to SQL Server 2008 via integrated security from IIS 5.1 and get the following error:
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
How do I change the account the application is using to a domain account? (SQL account is not an option) Here is my connection string: connectionString="Data Source=databasename;Initial Catalog=database;Integrated Security=True"