Skip to main content

Adding security on a mssql file, when moving backups or data files around

Every now and then you need to move a MSSQL database file around.

However, how to do you put the MSSQL security attributes back on the file.

Turns out it is real easy, all you need to do is put "NT Service" in front of  the database name

ie:
NT Service\MSSQL$InstanceName

For me, that was
NT Service\MSSQL$PBSQL


Comments

Post a Comment

Popular posts from this blog

Javascript Form Validation

It's real simple. All you need to do is call a javascript function in a html  " onsubmit " in the form tag as a javascript return, like this       <form method="post" action="dosomething.php" onsubmit="return validateForm();"> If the code completes ok, the form is then sent to the page listed in "action" http://www.w3schools.com/js/js_form_validation.asp If the function specified in the onsubmit returns false, then the form is not sent to the page mentioned in action.
Post a Comment
Read more