title: SSMS browse filesystem - Cannot access the specifed path or file on the server
body: <p>We have a database which have different logins and database users. If login is not sysadmin, SSMS gives an error like below</p>
  <blockquote>
  <p>C:\BackupShare
  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.</p>
  <p>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.</p>
  </blockquote>
  <p>--</p>
  <p>Concerns</p>
  <ul>
  <li>We should not login as windows login, use sql login instead</li>
  <li>We should not give sysadmin role to user.</li>
  </ul>
  <p>I tried following ways but did not work</p>
  <ul>
  <li>Giving all permissions to folder for NETWORKService, MSSQL$instance (sql server service user)
  (<a href="https://msdn.microsoft.com/en-us/library/jj219062.aspx" rel="nofollow noreferrer">https://msdn.microsoft.com/en-us/library/jj219062.aspx</a>)</li>
  <li>Giving all other roles to user(login) except sysadmin</li>
  <li>Giving all permissions to user(login)</li>
  </ul>
  <p>Want to do following things without any restriction with non-sysadmin role</p>
  <ul>
  <li>Backup- restore</li>
  <li>Attach - detach</li>
  <li>Create new db etc</li>
  </ul>