SQL server problem need help ---

hi guys,

I'm using window2000 advance server with service pack 1... and SQL server.. my IIS is running ok...

I already created a database in SQL server... and i have already created ASP pages..

I already put the DSN in the ODBC.. but everytime i run it on my browser i kept getting this error..

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'TEST-WEBSERVER\IUSR_TEST-WEBSERVER'.

test-webserver is the name of my server.. the connection is ok too that only problem i've got that errror everytime i run my ASP pages...

but those program that i used acccess is running properly..

hope someone can help me....:D

Check how you connect to it through the asp pages.

You need to give a known user and password to connect to the DB.

Or add a user to the users on SQL server with the name of the webserver.

i'm running it on the server itself..

This could be.

I geuss the dsn is created with trusted connection to the server.
So the nt user must be known in the sql-server .
If a user is not known on the SQL side than the connection is restricted and this user cannot log in to the DB.

I'd suggest you apply the user and password to the connection through code.

If this sounds a bit to loose you could have a seperate dll which gets the name and password from some encrypted file and opens and closes the connection for you.