Trying to move master.mdf file but sql service won't start after move

I am almost positive I am using the correct procedure to move the master database
http://basitaalishan.com/2012/07/29/how-to-move-master-and-resource-database/

I am able to move it deeper in the file directory location where it currently is just to make the procedure work.  What I can't do is get the service to start after I move the master.mdf file and ldf  files to a location outside of the current folder.  I can make this work in subfolders of the current folder.

in the security properties of the folder that works I see a user MSSQLSERVER that has full rights to the default folder.
in the folder I am trying to move the master.mdf, I do not see MSSQLSERVER.  I also can not add it.  Can someone explain how to correct this.  I am almost positive this is the problem
mast-file-location.jpg
jamesmetcalf74Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kyle AbrahamsSenior .Net DeveloperCommented:
Are you logged in as an administrator on the local box?  
Confirm MSSQLServer is the account that's actually running the service?

You might want to try creating another local account, assigning permissions to that account in the new folder, and then changing the service that the account runs under.

The question is why can't you add the MSSQLServer as a permission to the new folder, you need to resolve that first.
0
jamesmetcalf74Author Commented:
Ok I am more jacked up now.   I am trying to revert back to the username and password for the service account shown in the screenshot.  I don't know the password.  how to manage the password for the nt service/mssqlserver  account.
anyone know/
0
Kyle AbrahamsSenior .Net DeveloperCommented:
Leave it blank, it should be auto populated.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

jamesmetcalf74Author Commented:
VOILA
now im back to square one.  I think I'm missing something probably pretty easy.  I have run into this before.  I added an administrator account to start the sql service but trying to start the sql instance with the new master file location failed.

is there someplace within sql management studio to identify folders that sql accounts should have access to.....
0
Kyle AbrahamsSenior .Net DeveloperCommented:
it's not within management studio . . . you do that in the windows explorer.
0
jamesmetcalf74Author Commented:
does this screenshot help?
0
jamesmetcalf74Author Commented:
sorry here it is
2.jpg
0
Kyle AbrahamsSenior .Net DeveloperCommented:
The question is why you can't.  

If you click edit -> add ->

First change your locations to be the machine name (rather than a domain [assuming you're attached to one])

Then do advanced -> find now . . . see if MSSQLServer is listed or anything like it.
0
jamesmetcalf74Author Commented:
can't find it.... not from the local host.  not from different types.   notta
0
Kyle AbrahamsSenior .Net DeveloperCommented:
try

"NT SERVICE\MSSQLSERVER"

without the quotes.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jamesmetcalf74Author Commented:
tried. it...i can't find that account anywhere and when i try to select it from the user list i can't find it either.  tried local, domain, all 3 types..
0
jamesmetcalf74Author Commented:
Kyle-
thanks for working with me.  You lead me down the right path.
eventually i gave the folder on my host read/write access to the user everyone
that fixed it
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.