How do I configure SQL Server 2012 so that it can restore and see files in my user account?
10
4
I have an SQL Server 2012 instance running as a service on my computer, and according to the service page it logs on as account "NT ServiceMSSQLSERVER". However I can't see that account name anywhere else including in the "Local Users and Groups" area in the computer management screen, because, as a link below says, that's not a User Account, it's a service name, in that box that Microsoft so helpfully labelled "account". At this point I can see many people being confused. The task I'm trying to accomplish is to restore files using the SSMS dialog "Locate Backup File", which uses a dialog completely unlike any of the standard windows file open dialogs, probably because it's doing a "remote" job and operating from the security context of