Frank,

I can't answer for #1 but as far as security is concerned, you just need to grant 'execute' rights to the user that will be used for your web app. For mine, it is 'NT Authority\Network Service'.

HTH
>Hi,
>
>I'm trying out my first ever deployment of an MM.NET ASP.NET solution. I've got the app running but there are a couple questions I have:
>
>1. My pages do not have the same look as they do within Visual Studio. I've used Master files and my header and footers and background aren't showing up.
>
>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?