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:
How do I create alias in SQL Server 2022, is that even possible?
1 Answer 1
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)
-
Thanks! That worked perfectly.AntrikshSharma– AntrikshSharma2023年04月23日 13:01:33 +00:00Commented Apr 23, 2023 at 13:01
-
Upvoted (thx!) but just gonna ask... What the odds are that SysWOW64 has the 32-bit version, and System32 has the 64?Wellspring– Wellspring2023年06月21日 14:37:17 +00:00Commented Jun 21, 2023 at 14:37
-
jokes aside, I submitted a fix to this helpful answerWellspring– Wellspring2023年06月21日 14:52:44 +00:00Commented Jun 21, 2023 at 14:52
-
1@Wellspring Actually, you are wrong. My original answer was correct.
SysWOW64does actually contain the 32-bit version, andSystem32the 64-bit version even if it's counterintuitive.Tom Pažourek– Tom Pažourek2023年06月26日 14:42:57 +00:00Commented Jun 26, 2023 at 14:42 -
1Proves my google spot-check came up short! (I did check!) I saw the explanation, "The System32 folder is often used by 32-bit programs, while 64-bit programs use the SysWOW64 folder" and drew the wrong conclusion. Thanks, @TomPažourekWellspring– Wellspring2023年06月27日 12:21:20 +00:00Commented Jun 27, 2023 at 12:21