Not Your Dad's IT

Updated Solutions to Classic Challenges

A personal website dedicated to helping IT professionals review where we've been, where we are, and maybe where we are headed.

  • Blog
  • About
  • Disclaimer

Quick and Dirty - SQL Server 2008 R2 to SQL Server 2017 Migration

June 10, 2019 by Nathaniel Avery in Enterprise, Tip

SQL Server 2008 R2 is quickly approaching EOL. Some are still looking for ways to migrate their databases to newer releases of SQL Server such as SQL Server 2017. This blog post details a simple method for migrating simple databases using detach and attach. By simple, I mean databases without complicated transnational replication technologies such as mirroring. I imagine this method would used for databases supporting simple applications.

Read More
June 10, 2019 /Nathaniel Avery
SQL Server, SQL, MS SQL
Enterprise, Tip
1 Comment

Troubleshooting - MS SQL Server - Cannot connect to WMI provider. [0x8004100e]

March 04, 2019 by Nathaniel Avery in Bugs, Tip

I ran into a strange error today. I attempted to launch SQL Server Configuration Manger on a server deployed in Azure, and I was greeted with an error dialog that implied either the server was unreachable or that I didn’t have rights. The error read, “Cannot connect to WMI provider. You Do not have permission or the server is unreachable. Note that you can only manage SQL Server 2055 and later servers with SQL Server Configuration Manager. Invalid namespace [0x8004100e].” After a bit of digging, I found a solution, and possibly even a root cause.

Read More
March 04, 2019 /Nathaniel Avery
SQL Server, SQL, MS SQL, windows Server, Windows
Bugs, Tip
Comment

Powered by Squarespace