Hi,

I am new at ASP.NET, and I need some help from you.

I am started with a first example got it from MSDN related to the
Studio.NET, I am going through the example step by step.

The example is easy and simple which is about how to display data from
database (Pubs) on web page using dataset (SQL Server 7). actually i know
the username but i do not the password of it, so i created a new login
(username: "pupuser",  password: "pupuser") for the database and i used it
in the example.

But when i make run for the application I got the following error message:
Login failed for user 'pupuser'.
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
'pupuser'.

Source Error:

Line 3:
Line 4:      Public Sub FillDataSet(ByVal dSet As MyDataSet)
Line 5:          SqlDataAdapter1.Fill(dSet)
Line 6:      End Sub
Line 7:  #Region " Component Designer generated code "

Source File: c:\inetpub\wwwroot\MyWebForm\Component1.vb    Line: 5

Stack Trace:

[SqlException: Login failed for user 'pupuser'.]
  System.Data.SqlClient.SqlConnection.Open() +761
  System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
ConnectionState& originalState) +44
  System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +98
  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
  MyWebForm.Component1.FillDataSet(MyDataSet dSet) in
c:\inetpub\wwwroot\MyWebForm\Component1.vb:5
  MyWebForm.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\MyWebForm\WebForm1.aspx.vb:33
  System.Web.UI.Control.OnLoad(EventArgs e) +67
  System.Web.UI.Control.LoadRecursive() +29
  System.Web.UI.Page.ProcessRequestMain() +724

Best regards.....................