Should the SQL Server Service Account be a local or domain admin? No. Best practices from a client Q&A on service accounts, permissions and passwords.
SQL SERVER – Unable to Bring Resource Online – Error – Could Not Find Any IP Address that this SQL Server Instance Depends Upon
A clustered SQL Server could not find any IP address it depends upon, so it would not start. Here is how to fix it and bring the resource online.
SQL SERVER – Unable to bring resource online. Error – Data source name not found and no default driver specified
A clustered SQL Server resource would not come online on one node. The cluster log said: data source name not found and no default driver specified.
SQL SERVER – Unable to Bring SQL Online – DoSQLDataRootApplyACL : Failed to Create Directory Tree at SQLDataRoot
Unable to bring SQL Online on a cluster node? The cluster log showed DoSQLDataRootApplyACL failed to create directory tree at SQLDataRoot. Here is the fix.
SQL SERVER – Configuring Startup Options for SQL Server Management Studio
SSMS is the first thing I open every day. Here is how to configure the Startup Options in SQL Server Management Studio so it opens the way you work.
SQL SERVER – Unable to Start Services After Patching (sqlagent_msdb_upgrade.sql)
Unable to start services after patching? The ERRORLOG pointed to sqlagent_msdb_upgrade.sql failing. Here is what caused it for my client and the fix.
How to Find Missing SQL Server Configuration Manager? – Interview Question of the Week #089
Question: I just installed the latest version of SQL Server and now I am not able to find SQL Server Configuration Manager. What should I do?