6

I want to create an alias in SQL Server Configuration Manager. I can navigate to "Aliases" in the tree on the left, and I can right-click to open the context menu when "New alias..." is an option. When I click "New alias...", I get the following window:

enter image description here

All of the fields are grayed-out and uneditable. Is this a bug in SQL Server Configuration Manager, or am I doing something wrong?

This is SQL Server 2016 Standard. I was able to create an alias previously so I do not know why this is not working. I have tried multiple workarounds, such as opening Configuration Manager as administrator, and running the 64-bit version of the SQLServerManager13.msc.

Sam Magura
  • 161
  • 1
  • 3

1 Answers1

0

There is a note in books online

If a configured alias is connecting to the wrong server or instance, disable and then reenable the associated network protocol. Doing this clears any cached connection information and allows the client to connect correctly.

Consider repairing the SQL Server Shared Tools by running the SQL Server installation routine from Programs and Features and selecting the Repair option. Use the highest version. E.g. Microsoft SQL Server 2016 (64-bit).

John K. N.
  • 18,854
  • 14
  • 56
  • 117