Share via

SQL Server Management Studio 2012 can't read any user folders

Duy Đinh Hoàng 41 Reputation points
2022-09-10T07:28:17.79+00:00

I want to create and work with sql things on my user folder but I can't because SQL Server Management Studio 2012 can't read any user folders. Is there any solution to fix this problem?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

Answer accepted by question author

Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator
2022-09-11T14:18:50.677+00:00

Your question is not clear, but SSMS sure can read user folders. Just select the Open or Save menus to verify. SSMS runs with your permission, so anything you can access, SSMS can access.

However, if you are browsing for the location of a backup or a place to store a database file it is a different matter. In this case, SSMS asks SQL Server to browse the file system. This is quite natural, since these are folders to be used in SQL commands. I guess you have SQL Server running on your local machine, but keep in mind that this is a special case. Normally, SQL Server runs on different server than your workstation.

And SQL Server does not normally have access to the other user's folders. Or, rather, SQL Server runs under a service account, and that service account has access to its own user folder, but not yours.

Was this answer helpful?

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.