(I'll answer here, instead of replying to your personal message, if you don't mind).
How did you set up SQL Server? Is it using Mixed Authentication, or Windows only authentication? You can check that on the Properties dialog for SQL Server in the Enterprise Manager.
The error you get makes me think that SQL Server is using Windows Authentication, but that your connection string in your ASP page is using the SA account, and is not using Integrated Security / a Trusted Connection.
If that is the case, either switch the security model for SQL Server to SQL Server Authentication (IMO, not recommended), or change your connection string so it uses a trusted connection. Take a look here for ideas on connection strings:
and search this forum (or Google) for "Login failed for user sa" for much more background on this problem. It has been reported many many times, so you can find quite a lot of information and fixes in the archives of this forum.
Everyone is unique, except for me.