Posts written by Fred Terry

SQL Server 2016 Configuration Manager missing, SSMS 17.2 “Cannot connect to WMI provider”

On an internal SQL Server 2016 instance that we run on a Windows 10 host/OSE, we had SQL Server Management Studio 17.1 installed, and it recently informed us that a new version (17.2) was available. Someone performed that upgrade (I plead the fifth!)– perhaps uninstalling 17.1, and doing the full install of 17.2 SSMS. A few days later (while logging traffic through the network generated by using “runas” to authenticate SSMS to another domain) I found that the local copy of SQL Server Configuration Manager (under Start > Microsoft SQL Server 2016 > Configuration Tools) had disappeared, and we instead had SQL Server 2017 RC1 Configuration Manager (Under Start > Microsoft SQL Server 2017 RC1).

And that would have been fine– but launching it generated an error:

“Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.
Invalid namespace [0x8004100e]” Keep reading…

How to migrate a Microsoft SQL database back to an older version of SQL

There are situations where you might need to migrate newer-version SQL Server databases to older versions of the MSSQL engine, such as in various QA or testing scenarios, or after an upgrade that for any number of reasons calls for a rollback but needs to keep existing data. Unfortunately, backup/restore does not work when going from a newer to an older version of Microsoft SQL Server– it is not possible to restore a SQL 2012 database backup into a SQL 2005 server, for example. So in order to accomplish this, we have to take a different approach. Keep reading…

Pay the Piper – Software Licensing and Audits

Once upon a Wikipedia safari, I found myself sucked into the article on the Pied Piper of Hamelin. I read that contrary to popular belief, the expression “pay the piper” actually comes not from the Pied Piper, but from the phrase “He who pays the piper calls the tune.” You learn something new every day, I thought to myself. You see, over the years, I have advised employers, clients, and contemporaries that when it comes to software licensing, it is best to “pay the piper.” It was an expression I learned as a kid in the Boston area. Keep reading…

We're Here To Help.

Database problem? Tell us a little bit about it.

Name*

Email*

Subject

Message*

captcha

* Required