You are currently offline, waiting for your internet to reconnect

PRB: "Error 229: Execute Permission Denied on Object 'xp_availablemedia' Owner 'dbo'"

This article was previously published under Q323249
This article has been archived. It is offered "as is" and will no longer be updated.
SYMPTOMS
In SQL Server Enterprise Manager, if you follow these steps
  1. Right-click a database, and then click All Tasks - Backup Database.
  2. Click Add for the destination, and then click the ellipsis button (...) to select a new backup destination.
you receive the following error message:
Error 229: Execute permission denied on object "xp_availablemedia" owner "dbo"
CAUSE
This problem occurs under the following conditions:
  • Your SQL Server logon user profile is a member of the public or the db_owner role (or both).
  • You cannot browse the local directory tree, and you cannot back up or restore a database without typing the actual path and the backup file or device name.
This problem can also occur when you try to back up a SQL Server 7.0 database by using SQL Server Enterprise Manager from SQL Server 2000.

Only members of the SQL Server system administrators role (sysadmin) can view the directory structure and select local backup files. This behavior prevents you from accidentally overwriting backup files.
WORKAROUND
To work around this behavior, assign the user profile to the sysadmin role. By doing so, the user profile has unlimited access to all SQL Server features.

REFERENCES

For more information about the sysadmin role, view the "Adding a Member to a Predefined Role" topic in SQL Server Books Online.
Properties

Article ID: 323249 - Last Review: 12/07/2015 11:12:26 - Revision: 3.3

Microsoft SQL Server 2000 Standard Edition

  • kbnosurvey kbarchive kbpending kbprb KB323249
Feedback