Category: SQL Server

  • How to Connect to SQL Server Configuration Manager Remotely

    Very neat approach which I didn’t know up until today. Here is the link from Microsoft. However, I am still struggling with a server where either local or remote configuration manager fail to report correct statuses of all SQL Server related services. The error message are simple text “The remote procedure call failed. [0x800706be]” locally and…

  • Error “Alter failed for Server ‘[servername]’ “in maintenance plan’s “check database integrity task”

    This error happened in one of the SQL2005 SP4 instances I am managing. The root cause of this issue is that the integrity check task runs statement ‘EXEC sys.sp_configure N’user options’, 0 RECONFIGURE‘ in the background and this statement conflicts with another “allow update” (with value of 1) setting to system catalogs. To put it another way, if…

  • A very interesting paragraph from a Microsoft KB article about NT AUTHORITY\SYSTEM and BUILTIN\Administrators logins

    The original article is here and the quoted text is as follows: The NT AUTHORITY\SYSTEM account The NT AUTHORITY\SYSTEM account is also granted a SQL Server login. The NT AUTHORITY\SYSTEM account is provisioned in the SYSADMIN fixed server role. Do not delete this account or remove it from the SYSADMIN fixed server role. The NTAUTHORITY\SYSTEM…

  • How to become NT AUTHORITY\SYSTEM on Windows systems

    As a DBA, you will bump into situations to trouble shoot weird things under this account. And this article details the way how to do it beautifully. Just before you follow the steps, you have to install a toolset from Microsoft to run all the commands that are needed in that tutorial. Also don’t forget…

  • Shortcuts to Microsoft MMC Snap-In’s

    Certificates certmgr.msc Indexing Service ciadv.msc Computer Management compmgmt.msc Device Manager devmgmt.msc Disk Defragmenter dfrg.msc Disk Management diskmgmt.msc Event Viewer eventvwr.msc Shared Folders fsmgmt.msc Group Policy gpedit.msc Local Users and Groups lusrmgr.msc Removable Storage ntmsmgr.msc Removable Storage OperatorRequests ntmsoprq.msc Performance perfmon.msc Resultant Set of Policy rsop.msc Local Security Settings secpol.msc Services services.msc Windows Management Infrastructure (WMI)…