I posted this on the asp.net 2.0 forum but received no reply.

My asp.net 2.0 application works perfectly well offline.

When I put it online, I get a message that
Cannot open database "mydatabase" requested by the login

I realize it's a permission problem, but I am a bit confused as to what

I should do.

My server is Win 2000 and I am running IIS 5 and SQL server 2005
express.

I am not that sure of what user user I should be adding to SQL Server
Express 2005 and how?

The ASP.NET client uses the IUSR_*MACHINENAME* NT user.
So if you need the ASP.NET client to make use of the SQL server try
adding that NT user to the SQL Server instance.

Let me know how it goes.

Andrew La Grange
Business Artists
http://www.businessartists.co.za