SQL Native Client 10.0 Login Failed
I'm setting up a Classic ASP site in IIS 7.5 (Windows Server 2008 R2). I set the site and the application pool to run as a specific domain account. I added the domain account to the SQL Server 2008 instance running on the same server. I'm getting the following error:

<code>
[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'DOMAIN\Account'.
</code>

Here is my connection string:

<code>
Driver={SQL Server Native Client 10.0};Server=server;Trusted_Connection=Yes;Database=db
</code>

I have the exact same setup on another site on the same server. The other site works flawlessly. Any thoughts?
SQL Native Client 10.0 Login Failed
===

I'm setting up a Classic ASP site in IIS 7.5 (Windows Server 2008 R2). I set the site and the application pool to run as a specific domain account. I added the domain account to the SQL Server 2008 instance running on the same server. I'm getting the following error:

<code>
[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'DOMAIN\Account'.
</code>

Here is my connection string:

<code>
Driver={SQL Server Native Client 10.0};Server=server;Trusted_Connection=Yes;Database=db
</code>

I have the exact same setup on another site on the same server. The other site works flawlessly. Any thoughts?