My blog has moved to: http://sqlblogcasts.com/blogs/acalvett/
The full version of this post can be found here.
We had a requirement to allow someone to create and restore databases on a test server today and i thought to myself "Thats easy, i`ll just grant the "Create Any Database" right to the appropriate user, thats when the pain began!
The user was using SSMS connecting using a SQL login to restore a database and when they went to specify the backup location they got an error to the effect "Cannot access the specified path or file on the server".........
To read the complete version of this post go to here.