Whats wrong with my ConnectionString in Web.Config
This is my first attempt in learning how to write Web program using VB.Net 2003 and ASP.Net. I don't understand why the error listed below occurred and how to fix it. Please help.
Here is the scenerio:-
I am using the SERVER EXPLORER objects to create ConnectionString and DataAdapter to populate a DataList control on the Web Form. When I execute it with "Start Without Debugging", the error list below pops up.
Login failed for user 'LENNIEDO-1P65RG\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 'LENNIEDO-1P65RG\ASPNET'.
Source Error:
Line 138: '
Line 139: 'obtain the data
Line 140: daAuthors.Fill(DsAuthors1)
Line 141:
Line 142: Try
Source File: c:\inetpub\wwwroot\WebDataList\FrmDataList.aspx.vb Line: 140
Stack Trace:
[SqlException: Login failed for user 'LENNIEDO-1P65RG\ASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
WebDataList.FrmDataList.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebDataList\FrmDataList.aspx.vb:140
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750

