sp_whoisactive is a comprehensive activity monitoring stored procedure that works for all versions of SQL Server
This local “user” account is not an administrative account or domain account. This account is automatically created for you on each of the nodes when you create a cluster or on a new node being added to the existing Cluster. This account is completely self-managed by the Cluster Service and handles automatically rotating the password for the account and synchronising all the nodes for you. The CLIUSR password is rotated at the same frequency as the CNO, as defined by your domain policy.windows sql server
A Failover Cluster does not update the
lastLogonTimeStamp the same way as a real computer. A cluster updates the
lastLogonTimeStamp when it brings a clustered network name resource online. Once online, it caches the authentication token. Therefore, a clustered network named resource working in production for months will never update the
lastLogonTimeStamp. This appears as a stale computer account to the AD administrator.
Start the instance of SQL Server in single-user mode by using either the
-f options. Any member of the computer's local Administrators group can then connect to the instance of SQL Server as a member of the sysadmin fixed server role.
In secure environments you sometimes need to install ActiveX components. I wanted to create a silent installation of the Printing components of the SQL Server Reporting Services 2008 R2 in a lock downed environment. The components are needed to present the print dialog box in the Reporting Services website.windows sysadmin sql server