Login Error

Hi

I am using MSDE2000 and ASP.NET. I have 3 data adapters and a dataset. When running the program I get:

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'CGREGORYT2XP\ASPNET'.

Source Error:
Line 257: If Not Page.IsPostBack Then
Line 258:
Line 259: SqlConnection1.Open()
Line 260:
Line 261: SqlDataAdapter1.Fill(Ds1, "employee")

I have used sp_grantdbaccess 'machinename\ASPNET' on PUBS but still get error.

Where am I going wrong??

Thanks

I pressume you have added a user to the SQL Server for CGREGORYT2XP\ASPNET and that the SQL server supports Mixed Mode authentication.

If not check you have a user by selecting "Security", "Logins" in Enterprise Manager you should see a user in the list called CGREGORYT2XP\ASPNET.