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

NMAP

It's been about 15 years since I used NMAP, I forgot how useful the tool is. To find out what services are running on an IP address simply use something like nmap -n -v -p1-10000 x.x.x.x -n tells nmap not to do name resolution (saves about 13 seconds if the IP you're scanning isn't in DNS_ -v verbose -p1-10000 says scan ports 1 to 10,000 (otherwise nmap will only scan the first 1000 ports)
Post a Comment
Read more