Hi

i reached the point in the book where i can register a new user in the database.

Once i regesiter the user it returns him back to my login page where
in the Siteheader it displays the users First and Last name.

I can signout and login different user that are registered in my database. I t will display an error message if a user trys to login with an incorrect email or password. I can do this any number of times without any errors accurring.



The problem arises when i try to access the register.aspx again.

example: I'll signout the user that is currently logged on.Then i try to register a new user and i always get this error



SqlException: Login failed for user 'FRANK\IUSR_FRANK'.]
System.Data.SqlClient.ConnectionPool.GetConn ection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManag er.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
Wrox.WebModules.Data.DbObject.RunProcedure(S tring storedProcName, IDataParameter[] parameters, String tableName)
Wrox.WebModules.Accounts.Data.AccountsTool.G etStateList()
Wrox.WebModules.Accounts.Business.AccountsTo ol.GetStates()
Wrox.ThePhile.WebModules.Accounts.Web.new1.P age_Load(Object sender, EventArgs e)
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

It seems if i go back and forth between my web pages i get the error mentioned above.

I can only access my register page if i don't do anything other than
press my register link button on my login page.

When i do get the error mentioned above i can only access my aspx pages if i do something my like move the curse on one of my .cs pages
and resafe eveything.

Any help will be appreciated
Thanks