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?