SqlServer Begin's

The default service accounts in SQL Server 2012 (NT Service\MSSQLServer, NT Service\SQLSERVERAGENT) Few days back I realised that Microsoft had added few service account to Windows 7 and Windows Server R2 to support SQL server 2012. When SQL server 2012 is installed the accounts ( NT Service\MSSQLServer , NT Service\SQLSERVERAGENT)   are created under the cover to as the default SQL service accounts   for the SQL Server service and SQL server agent service respectively. These accounts are called virtual account for windows. Unlike the traditional windows accounts they can’t be used to log into any environment as they work   below the authentication layer of windows and does not have a password. Virtual accounts in Windows Server 2008 R2 are managed local accounts that provide simplified service management. The virtual account is auto-managed and has limited access to the network in a domain environment. However Virtual accounts cannot be used in certain scen...

After many force restarts my laptop the MSDB database decided to that it was time and   let the owner know of the harassment and didn’t want come back up.   The error log read as following An error occurred during recovery, preventing the database 'msdb' (database ID 4) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.   Solution Following is a step by step guide to bring the database back online     1.        Put MSSQL into single user mode 1.        Click START ; Microsoft SQL Server 2005 Configuration Tools ; SQL Server Configuration Manager 2.        Right click on SQL Server and choose Properties 3.        Click on the Advanced tab. Under Startup Parameters you will be addin...