Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 database backup error

Author  Topic 

h0mer
Starting Member

3 Posts

Posted - 2006-04-25 : 12:31:54
I have a webform to manage sql express 2005 backups.
If i test the application with the debugger and click the button to made a backup, everything works ok and the backup is created inside my web application folder. When i run the web app under IIS, if I try to do the backup i recieve the following error:

Server Error in '/test' Application.
--------------------------------------------------------------------------------

User does not have permission to perform this action.
User does not have permission to perform this action.
Processed 416 pages for database 'test', file 'test' on file 5.
Processed 3 pages for database 'test', file 'test_log' on file 5.
BACKUP DATABASE successfully processed 419 pages in 0.754 seconds (4.543 MB/sec).

I have included the <localmachine>\ASPNET user in my database with
schema 'dbo' and 'db_owner' permission. I have also change the security directives of the folder where the backup is going to be saved (write permission,creation,etc..) but it doesn´t work.

Any Idea??

Kristen
Test

22859 Posts

Posted - 2006-04-25 : 14:22:52
Duplciate post of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65187
Go to Top of Page
   

- Advertisement -