Posted on: 4/24/2013 9:54:45 AM | Views : 252

I am accessing my sql server 2008 r2 express server using SSMS. I have about 5 logins. For a particular login I have all server roles other than sysadmin. It is a sql login(not windows authentication) In user roles it has all permission for almost all database.For some database it has only datareader. Now when i try to take backup of database using SSMS and when try to select backup destination by clicking button i get error like "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Backup Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.  If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box." Even though I have db_owner and all permissions i am getting this error. But if I select the path manually in the file nam ...

Go to the complete details ...