>>>>Can someone advise me as to how to provide read/write permissions to my internet users for write access to the data tables? I am able to read data out of them but cannot write to them. This is not a problem in the development environment but appears when I access it via the web. Folder and file permissions are open in the system. It appears to be something related to SQL Server.
>>>
>>>How does your app. connect to SQL (what does your connection string look like)? If you're using normal Windows authentication for the SQL string, then it will attempt to connect using the same security context as ASP.NET (Network Service under Win 2003). You can either give that account access to SQL Server, or change the connection string to connect as a named user (assuming you've configured SQL Server to used mixed-authentication: both Windows and accounts configured only in SQL). Or, you can change IIS to run under a different user that has access to SQL.
>>
>>Thanks Paul -
>>Being totally new to this subject I only understand about 1/3 of what you said. Here's my Connection string.
>
>It's connecting to the database using Integrated Security, which means (assuming you're under Win2003) that it's connecting to SQL Server as the "Network Service" user. That user probably doesn't have the access it needs to SQL Server.
>
>You have a few things you can do to fix this:
>
>- Add Network Service as a user in SQL and give it the permissions it needs
>- Change the connection string to explicitly pass in the username/password. Create that same user/pass in SQL and give them the permission they need.
>- Change the account IIS runs ASP.NET under to an account which already has permission to SQL Server.

OK, I think you mean any one of these suggestions as opposed to ALL of them. Right?
In SSMS/Security/Logins I am showing an entry for NT Authority\NETWORK SERVICE and another for TPD284\ASPNET. (The latter is my PC.) What is not clear is how to add permissions to either of these. A rt-click/properties brings up a blank form with no entries. Can you walk me from there?
Thanks