>>I've sorted out the display problem, but am still stuck with the security issue.
>>
>>>2. Security access to the database. As soon as I tried to login I got a message about my ASPNET use not having access to the database, so I added that user in SSMS and added them to the db_datareader role. This worked, but then when I needed to make changes to the data it failed, so I added them to the db_datareader role. However, it does not work when my stored procedures get called:
>>>
>>>Exception Details: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'ClientsSelectByNumberOrName', database 'SIAS', schema 'dbo'.
>>>
>>>Does this mean that I need to go through each stored proc one by one and add Execute rights?
>>
>>My user that the web site seems to be using is SAMAAN\ASPNET.
>>
>>I have created a schema called db_ASPNET and tried code like this in SSMS:
>>
>>GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE
>>ON SCHEMA::db_ASPNET TO SAMAAN\ASPNET
>>
>>but I get a syntax error pointing at the "\". How do I get this to work?
>
>
>What version IIS, OS?
IIS5.1 on XP for now, but IIS7 on Vista eventually and then whatever version comes with Server 2003