After a cleanup on my Azure SQL VM, I hit Msg 45207: SQL Server Managed Backup to Microsoft Azure cannot configure the database. Here is how I fixed it.
SQL SERVER – SQL Server Configuration Manager Error: 0x80010108 – The Object Invoked Has Disconnected From its Clients
SQL Server Configuration Manager gave error 0x80010108: The object invoked has disconnected from its clients. Here is one cause I could reproduce on demand.
First Queries to Run on an Unfamiliar SQL Server
Inspect an unfamiliar SQL Server with read-only queries for version, uptime, database size, waits, backup history, and settings.
![SQL SERVER - Unable to Launch SQL Server Configuration Manager. Error: Cannot Connect to WMI Provider. [0x80070422]](https://blog.sqlauthority.com/wp-content/uploads/2018/10/sscm-err-02.jpg){kind=small}
SQL SERVER – Unable to Launch SQL Server Configuration Manager. Error: Cannot Connect to WMI Provider. [0x80070422]
SQL Server Configuration Manager would not open on my VM: Cannot connect to WMI provider [0x80070422]. I share what caused it and how I fixed it.
Checking Optional Features Installed on an Instance From T-SQL
A 1 in SERVERPROPERTY does not mean the feature runs. Here is how I line up the flag, the setting and the service in one query.
Formatted Date Alias in ORDER BY: Sort by the Real Date in SQL Server
A formatted date alias can change ORDER BY from a date sort into a text sort. The tests here reproduce the wrong order, show three ways to sort by the real date, and explain the two errors you hit when you try to be clever with the alias.
Index Key Size Limits: 900 and 1,700 Bytes Explained
Check index key size against the 900-byte clustered and 1,700-byte nonclustered limits, then narrow keys without losing query semantics.