SQL Server 2012 SSMS custom reports – Service accounts

Oopps! Upgrade your browser pretty please. Oopps! Upgrade your browser pretty please.

In SQL Server Mangement Studio there are some built-in reports, but they do not cover everything you might want to know about your server, databases, tables, indexes or statistics. In addition to the built-in reports, I will create some useful custom reports for SQL Server 2012, and my 6:th report is the “Service account” report. This report will show information about :

  • When the SQL Server services was started
  • Startup type
  • State of the service
  • The name of the service account
  • Name of the cluster node, if the service is clustered

Download SQL Server 2012 Management Studio Report: SQLServiceMonitor_Service_accounts.zip

I will post all my custom reports at this link : www.sqlservice.se/ssms/custom_reports.aspx

If you have any feature requests, feel free to send me a tweet.

Best regards

Håkan Winther
Twitter: @h_winther