Home page
or browse popular tags

Sign up for the free email newsletter for new tips, tutorials and more. Enter your email address below, and then click the button.

Privacy Policy

RSS Twitter

SQL Server: Insufficient access rights error when doing backup


All of sudden SQL Server Management studio gives me the following error message when I'm trying to browse for the backup file location.

Property BackupDirectory is not available for Settings 'Microsoft.SqlServer.Management.Smo.Settings'. 
This property may not exist for this object, or may not be retrievable due to insufficient access 
rights.  (Microsoft.SqlServer.Smo)

SQL Server was installed on the server by Plesk control panel which might the part of the problem. Anyway, this can be fixed by adding BackupDirectory registry key that points to default backup directory. For example, if you are in the default SQL instance, create the "BackupDirectory" string value under [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQLServer] and in the value itself put the complete path for the default backup directory you want. To be on the safe side add the same key to [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQLSERVER] branch as well.


Add To: Add to dzone dzone | Digg this digg | Add to del.icio.us del.icio.us | Stumble it stumbleupon

  • Comments

Copyright © 2005-2023             www.WebCheatSheet.com All Rights Reserved.