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.
| Author |
Topic |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2007-05-04 : 01:50:24
|
| I wrote a stored procedure which backsup my db to disknow when calling it from asp I getMicrosoft OLE DB Provider for ODBC Drivers error '80040e14'[Microsoft][SQL Native Client][SQL Server]BACKUP DATABASE permission denied in database 'traffic'. Is there anyway around it? I want to be able to give the client the option to backup the db to disk |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2007-05-04 : 03:33:00
|
| I am doing this with my application w/o issue. Are you sure the account running the procedure has backup access to the db? |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2007-05-04 : 03:36:52
|
| i didn't set anything -- where do I set this access? |
|
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2007-05-04 : 03:40:56
|
| If your using SMS, you can just right click the db go to properties, then click permissions. Scroll down until you see "Backup Database" then set the permission, or set it under the user you are using. |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2007-05-04 : 03:53:00
|
| thanks that worked but now i getMicrosoft OLE DB Provider for ODBC Drivers error '80040e31'[Microsoft][SQL Native Client]Query timeout expired where does the timeout need increasing - in asp or sql? |
|
|
|
|
|
|
scritp to backup db