ASP.NET page that login has failed with Sql Server

[Sheena777]

I have just publish my asp page to my local host and when I went to check that the page was working I got this error:

Exception Details: System.Data.Sql Client.SqlExcep tion: Login failed for user 'DCM01\ASPNET'.

How would I go about fixing this?

[DrBunchman]

Hi Sheena,

What sort of authentication does your SQL Server use? Your IIS account (DCM01\ASPNET) may need to be set up as a user within the SQL Server.

Dr B

PS You've posted this question in the ASP Forum which is for Classic ASP only - I've moved it to the .NET forum where you should post all your future ASP.NET questions. Thanks :-)