April 22, 2010 at 4:43 am
I'm in the process of setting up a new database cluster, and have some files located in the default location for database files defines in SSMS. On the data folder I have a user "mssqlserver" that has full access to the database files located here.
But, I'm in a situation where I have do distribute my database files over a number of disk drives. How can I manually add the "mssqlserver" account full access rights on the database files? I'm not able to find the account in the local user account store on the server. And this is not a domain account. It seems that the account is somewhat tied to the instance since they share name.
My setup is a SQL Server 2008 SP 1 Enterprise edt. cluster running on Windows 2008 Enterprise edt.
Any help will be gratefully appreciated
/A.
May 1, 2010 at 9:21 am
Same issue here. Any luck?
May 1, 2010 at 11:41 am
under what context does your sql server service run user account or local system?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 3, 2010 at 2:20 pm
A domain account, but I figured out the issue. Apparently you have to set the permissions manually, as when clustered, the account does not show in the gui?
icacls directoryName /grant "NT SERVICE\MSSQLSERVER": (F)
Found at the Community Content section of:
http://msdn.microsoft.com/en-us/library/ms345408.aspx
Edit: I can't figure out how to escape smileys, but the above should have no space between the : and (F).
May 3, 2010 at 3:04 pm
Hi, I came to the same conclusion. But it is possible to add the account through the GUI, just choose local machine and specify "nt service\" as prefix when you add the account.
But can anyone explain why it it like this?
/Andy.l
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply