sql server in vb.net - log in failed

Login failed for user '***\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 '***\ASPNET'.

Source Error:

Line 64: Dim users As New ArrayListLine 65: Dim pass As New ArrayListLine 66: myData.Fill(myLogin)Line 67: End SubLine 68:

Stack Trace:

[SqlException: Login failed for user 'KRISTI\ASPNET'.] System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction) System.Data.SqlClient.SqlConnection.Open() System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection, ConnectionState& originalState) System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) mySC_VB.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\mySC-VB\login.aspx.vb:66 System.Web.UI.Control.OnLoad(EventArgs e) System.Web.UI.Control.LoadRecursive() System.Web.UI.Page.ProcessRequestMain()




--> hope sum1 know how to fix this problem....

It's quite straightforward message.
User MACHINENAME\ASPNET has no rights to login to the database, nor has the right to read anything from it.

The happens because you're using trusted connection.

you might try one of the following:

1) add user MACHINENAME\ASPNET to the databse and grant him rights to read (of write if needed) the database.
And check if you got the right database right.

2) create user of any name and pasword for the databse and change you connectionString property of your SqlConnection object, providing there username and password you set.

hope it will help
regards,
Pawel Rogozinski

i'll try your suggestion later....
thanks fot your reply