Midlands Technology Centre, Broadlands, Wolverhampton Business Park, WV10 6TA
0845 241 6370 info@msvconsultancy.co.uk
Enable, Entrust & Educate Through IT

Category Archives: SQL 2012

SQL Master Database Recovery

Most of us know that to restore the master database on SQL you need to get the instance started in single user mode however we usually forget the syntax so here it is:
  • Go to SQL Server Configuration Manager
  • Click on the SQL Server Services
  • Right Click the SQL Engine Service for the instance you need to start...
Read more

SPN Self Registration

Are you trying to increase security by removing extranious permissions from service accounts but growing a little tired of having to manually assign SPN's to them? If so get to work with ADSIEdit.
  • Open ADSI edit and connect to the default naming context.
  • Navigate through the structure to your service...
Read more