The database user for this connection is not allowed to read drives.

nvdweem / intellij-sqlserver-backup-restore

Plugin for Intellij that allows backing up and restoring databases in SQL Server

MIT License

14 stars 3 forks source link

The database user for this connection is not allowed to read drives. #10

Closed rasoolghafari closed 3 years ago

rasoolghafari commented 4 years ago

I installed this plugin, but when i want to make backup, i get this error:

The database user for this connection is not allowed to read drives.

nvdweem commented 3 years ago

This seems to be caused by the plugin using xp_fixeddrives and xp_dirtree for the filetree population. In 0.8.0 (pending moderation) it should use a similar method as SSMS does which doesn't require the sysadmin role.