SQL 2017 Configuration error

When I launched SQL 2017 configuration manager, I got the error below.

To fix the issue, I ran the following command in command prompt on the server.

mofcomp "%programfiles(x86)%\Microsoft SQL Server\140\Shared\sqlmgmproviderxpsp2up.mof"

I was able to open SQL server configuration manager.


Thank you for reading my blog!

Good Bye 2018...

Hello 2019..............

Creating Alias for SQL server

To Create an alias for SQL instance

Open SQL Server Configuration Manager

Go to both SQL Native Client branch on 32 and 64 bit. Please see screenshot below.

Right click on the right side of the window pane.

Alias Name : any name

Port No : 1433 (SQL default Port no)

Protocol :  TCP/IP

Server :  Fully qualified local server name(ex. server.domain.us.dom)

Next step is very important. We need to add the alias to DNS entry.

Please add the following SQL server alias to DNS entry alias/CName.

Alias Name : Newalias
Fully Qualified domain Name(FQDN)for target host : server.domain.us.dom

After adding it to DNS entry, we will be able to connect to Alias using SSMS from our desktop or application.