I have a problem with my ASP program.

It's a store, retrieve and update program from a database.

previously it connect to access 2000 db and its work perfectly.

Then somebody ask me to change to SQL Server 2000 (IIS5.0 and SQL Server 2000 in the same web server).

Then the following problem occurs :
When try to connect to the SQL Server it state the following error "...... login fail as user........ "

Actually there r no security setting set. means UID=; PWD=; or
Trusted_Connection=yes;

Then we try to use my pc using PWS as a server and link to SQL server it can work perfectly. That's mean if separate machine it work (IIS5.0 and SQL Server 2000 in separate server).

Can u pls help me solve this problem b'coz i've tried for long time to solve it.