sp_whoisactive SQL Server Monitoring Stored Procedure Sept. 11, 2019, 5:03 p.m.

sp_whoisactive is a comprehensive activity monitoring stored procedure that works for all versions of SQL Server

windows sql server

So what exactly is the CLIUSR account? Nov. 14, 2018, 12:03 p.m.

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

Cluster and Stale Computer Accounts Nov. 12, 2018, 8:38 a.m.

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.

active directory sysadmin sql server

Connect to SQL Server When System Administrators Are Locked Out July 19, 2018, 2:15 p.m.

Start the instance of SQL Server in single-user mode by using either the -m or -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.

security sysadmin sql server

Silently deploy SSRS Printing Components for SQL 2008 R2 (RSPrintClient.dll) Aug. 31, 2016, 4:55 p.m.

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