Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have been "securing" our database server. To do this I removed some permissions from the folders that the SQL Express install created.


I kept the permissions on the Data folder as they were, but I removed anything I thought I didn't need from the others.

Now I can't backup databases. If I try selecting the backup location the dialog doesn't show anything in the d:\SQL folder and if I put the path in myself it tells me this:-

Cannot access the specified path or file on the server. Verify that you have the necessary security privilages and that the path and file exists.


It looks like folder permission problem. Another server configured in a similar way has a bunch of "allow" permissions for an account called "MSSQL$SQLEXPRESS", (which I know I deleted), But I can't re-add these permissions because there is no such group, user or built-in security principle on the server.

How do I add permissions for this MSSQL$SQLEXPRESS account?

share|improve this question
Have you tried "repairing" the installation by running setup again? – Max Vernon Sep 7 '12 at 1:49
up vote 18 down vote accepted

This account is a service SID.


share|improve this answer
So I typed that account name in and it accepted it. Easy. – Mat Fergusson Sep 25 '12 at 3:54
Has Microsoft documented this anywhere? I am curious if you have a reference link. – pseudocoder Dec 11 '12 at 16:59
It seems that the Microsoft Training Kit book (for Exam 70-462) titled "Administering Microsoft SQL Server 2012 Databases" covers these Virtual Accounts or Managed Local Accounts, in chapter 1. – Mat Fergusson Aug 9 '13 at 10:33

If your server is in a domain, you must select the computer name location or NT SERVICE\MSSQL$SQLEXPRESS will not be found when adding the user to security rights

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.