IIS Doesn't retain Windows Authenication

[mjjks]

I don't know of a quick way of describing it, so please bear with me.

I inherited an ASP web application which uses COM component to connect to an Access database. It uses MS DataLink file for that. It all works ok.

Now, I migrated database to SQL2005, changed DataLink to point to the SQL server and use Windows Authenication security. It tests out successfully, however fails when I run it through webpage with database login error.

Microsoft OLE DB Provider for SQL Server error '80040e4d' 

Login failed for user 'ROTOR\S-IDS456C-131$'.

User in the error above, is server\machine name

I don't get it as in IIS(6.0), in directory security I specified to use Integrated Windows Security and unchecked Ananymous access.

How do I fix it so Windows Authenication is being enforced and passed to DataLink correcly?

Thanks
Steve

 

[mjjks]

Anyone? Any ideas?

 

[WhoKilledKenny]

When I set up an .asp page to run Queries agains a SQL Datbase , I set up an ODBC connection on the Web server that points to the instance name of the SQL Database. I've never used a DataLink file for connecting to SQL.