Accessing SQL 2000 (SP3) via Trusted Connection in ASP with IIS6 (Windows 2003 Server)

Accessing SQL 2000 (SP3) via Trusted Connection in ASP with IIS6
(Windows 2003 Server)

I have been digging all over the internet and have had no luck in
getting this combination to work

That is using a domain service account account to access the SQL 2000
Database via ASP using Integrated Security

Please note: I performed the same step and the ASP.Net application is
working - just not the classic ASP

I have performed the following:
1. Created a domain service account
2. Added the service account to the IIS_WPG group
3. Created a new application pool in IIS to and entered in the details
in the Identity tab
4. Configure the virtual directory to use the application pool
5. Ensure that only 'Integrated Windows authentication' is checked
6. Changed the connection string to: "Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;Initial
Catalog=myDatabase;Data Source=myDatabaseServer"

When I try to run the ASP, i get the following error:
Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection.

Here are some other details via the Request.ServerVariables
'auth_user' is MyDomain\myID
'logon_user' is MyDomain\myID
'remote_user' is MyDomain\myID
'auth_type' is Negotiate

Please note that this is an Internal application thats run on the
corporate Intranet.

Ideas??

Re: Accessing SQL 2000 (SP3) via Trusted Connection in ASP with IIS6 (Windows 2003 Server)

I do have Kerberos turned on and checking the security log, the
authentication is via Kerberos...

This is really puzzling me; I am sure there is a way to get it
working....