Skip to main content

How to add the MSSQL service account for a new MSSQL directory

Everyone says that it's "NT SERVICE\MSSQL$[instance name]

However this will not work if the objects aren't right.

In Object Types, "Service Accounts" must be selected.

In Locations, the local computer must be selected.

Only then will it work.

Comments

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)