Hi Rog
This is a permissions problem. Typically an ASP site will run as the IUsr account on the machine (sometimes it will be called 'IUSR_[machinename]'). But an ASP.NET one will normally run as one of the following users:
ASPNET
Network Service
It is also possible to get an ASP.NET site to run using the IUSR account if you have the following in the web.config file:
<identity impersonate="true"/>
(this tag should be present already, but with 'false' set as default)
Keep it as false for now.
Whichever user your site runs as needs to be given permission to use the database.
To do this, open up SQL Server management studio, and under the SQL server find the 'security', then 'logins' folder. Right click it and do 'New Login'.
Keep 'windows authentication' selected and click 'search'. A dialogue will appear - click 'advanced' and then 'find now' and then select both the following accounts:
ASPNET (if there is one)
NETWORK SERVICE
Once these are added, expand the database itself and then in the security folder under it, you should find a 'users' folder. You should now see ASPNET (if there was one) and NETWORK SERVICE listed.
Right click each and do 'properties'. For both, in the 'role owners' window, check 'db_owner'.
This should give your web site permissions to use the database now.
Let me know if this works - if not, be patient, we will definitely get it working.