Chapter 8 and Chapter 9 of the book have discussed about how we can access database (i.e. including select, update, delete and edit) using Web Matrix. But, I came to know one problem this recently when I try to update my database via IIS Server, where I get an error not allowing me to update the database.

I am quite confuse about this as I don't understand why it is fine when I try to update my database via Web Matrix Web Server, but it is not the case when I try to do the same thing via IIS Server.

So, is any one here face this kind of problem before, and what is the problem behind? How to solve it?

Does it give an error message?

Did you give permissions to the ASPNET user account to 'write'?

Below is the error message:

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


 

What do you mean by give permissions to ASPNET user account to write? You mean the configuration in Sql Server? If this is the case, then I think I have never give any permission to ASPNET user the right to write by configuring in Sql Server; in fact, I do not know how to do so because I am a Sql Server novice.

Then what should I do?

Oh great, I can update data to my database finally!

Ya stu9820, your

 

inspire me to configure Sql Server to let ASPNET user the right to write.

Thanks a lot!