pointers, solutions and scripts for the SQL DBA
not intended to replace msdn, common sense or oxford commas

Friday, August 16, 2013

Cannot find NT Service\MSSQL$SQL2012?

If you cannot find the virtual account used by the default settings installation of your SQL 2012 instance (in this case running on Windows 7), try searching for:
nt service\mssql

























You must have the "Built-in security principals" object type selected, and you must be searching on your local machine name (not in the domain).










Frustratingly, searching for the virtual account does not work for these strings:
  • MSSQL$SQL2012
  • MSSQL
  • nt service
  • nt service\
  • NT
Which is misleading...



1 comment:

Yvonne said...

I have recently installed SQL 2012 and in the middle of experimenting the application. I have had same issue of not being able to find the virtual account used by default installation. I've followed the above instructions but am still having the Name Not Found error message. Any suggestions will be greatly appreciated!