I am accessing data using data access pages in IIS 7 to SQL server 2005 Authentication is failin

is there a step by step paper to get there? here is what i need to consider. I Iwill have many customers that will need their own set of records and access pages "branded for their company" each customer will have many clients. I am hosting this application on a windows 2003 server with SQL 2005 server enterprise.

I am using windows authentication, I have created a username in windows, then i added the windows user in SQL management studio in security, granted "DB Read" and "DB write" and again under the database security tab. still from the web authentication fails. i must be nissing a step or two?

I expect to set up a username for each database as i setup new customers.

There is another post that had a similar issue...the discussion there may prove to be relevant for you:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=978330&SiteID=1

The important step is to disable Anonymous Authentication on your web server and enable Integrated Windows authentication. This will get the database request running in the context of the user making the web request (as opposed to the context of the default anonymous account).

Note that for data security/privacy reasons, you will probably want to avoid having clients from different companies, etc. sharing the same database and/or tables.