Accesing database after website deployment

Hi

I'm using sqlexpress on development machine and on client server. I'm building a webapp using membership and role provided for asp. In web.config I have definet membership provider and role provider to point to my database.

After web site deployment I get allways message : Failed to update database "c:\app\app.MDF" because the database is read-only, and I'm forced to apply rights for ASPNET. More than that somethimes I must re-register users.

I have tried to modify in web.config with <remove name="LocalSqlServer"/> <add name="LocalSqlServer"...> but I get errors if I try to design my dataset file:"Cannot get web application service".

TIA

Paul

To manipulate the database file, the account used to connect to the database must have read/write permission on the folder where the database file locates.|||Do you get other error message? I guess the problem is permission.|||

Hi

I think the problem is when I use SourceSafe, all folders in projects are maded read only.

Sometimes I get some error about NT Serveces does not have right on database, but that eror I have fised from SQL .

Paul

|||

I agree with you.You should add NT Service to access some folders in security.Change your database file property not to readonly.