Please can anyone help me with this problem. I have checked all of the forums for this problem and even though there are two listed (they are using SQL Server 2000 and i am using MSDE) i still can't get this to work.

My web config code is as follows
-------------------------------------------

<appSettings>
<add key="ConnectionString" value="Server=(local)\NetSDK;integrated security=sspi;Initial Catalog=ScentSation" />
</appSettings>

--------------------------------------------

I am using intergrated security and my database name is ScentSation. The problem i recieve when i run my program is

Server Error in '/ScentSation' Application.
----------------------------------------------------------------------

Login failed for user 'SCENTSATION1980\ASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

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

Source Error:


Line 11:
Line 12: ' Open the connection
Line 13: connection.Open()
Line 14:
Line 15: ' Return a SqlDataReader to the calling function


Source File: C:\ScentSation\ScentSation\BusinessObjects\Catalog .vb Line: 13

Stack Trace:


[SqlException: Login failed for user 'SCENTSATION1980\ASPNET'.]
   System.Data.SqlClient.SqlConnection.Open() +761
   ScentSation.Catalog.GetDepartments() in C:\ScentSation\ScentSation\BusinessObjects\Catalog .vb:13
   ScentSation.DepartmentsList.Page_Load(Object sender, EventArgs e) in C:\ScentSation\ScentSation\UserControls\Department sList.ascx.vb:39
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +29
   System.Web.UI.Control.LoadRecursive() +92
   System.Web.UI.Control.LoadRecursive() +92
   System.Web.UI.Page.ProcessRequestMain() +724

Please help as i have trying to solve this matter for nearly two weeks now. Do i have to do anyting in the IIS manager to give my database read/write permission. I have followed the book word by word. Please help