8

As per https://learn.microsoft.com/en-us/sql/relational-databases/native-client/sql-server-native-client?view=sql-server-ver16:

The SQL Server Native Client (often abbreviated SNAC) has been removed from SQL Server 2022 (16.x) and SQL Server Management Studio 19 (SSMS). The SQL Server Native Client (SQLNCLI or SQLNCLI11) and the legacy Microsoft OLE DB Provider for SQL Server (SQLOLEDB) are not recommended for new development. Switch to the new Microsoft OLE DB Driver (MSOLEDBSQL) for SQL Server or the latest Microsoft ODBC Driver for SQL Server going forward.

I used to create aliases using the SQL Server Configuration Manager, but since SQL Server 2022, the form to create alias has all the fields disabled:

Alias - New

How do I create alias in SQL Server 2022, is that even possible?

Tom Pažourek
  • 553
  • 7
  • 19

1 Answers1

11

It's still possible to create SQL Server aliases by using these programs instead of the Configuration Manager:

  • C:\Windows\System32\cliconfg.exe (64bit),
  • C:\Windows\SysWOW64\cliconfg.exe (32bit)
Tom Pažourek
  • 553
  • 7
  • 19