Cannot install/update Microsoft ODBC 18 on macOS 12

[ferben]

Following error I get when I try install/upgrade MSSQL ODBC on ma mac with macOS 12 Monterey step-by step from your manual (https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/install-microsoft-odbc-driver-sql-server-macos?view=sql-server-ver15#microsoft-odbc-18) The same error I get if I try install older Microsoft ODBC 17.

dev@imac ~ % brew --version
Homebrew 3.4.11
Homebrew/homebrew-core (git revision 5519bcebf8a; last commit 2022-05-18)
Homebrew/homebrew-cask (git revision fd02ed5c32; last commit 2022-05-18)
dev@imac ~ % HOMEBREW_NO_ENV_FILTERING=1 ACCEPT_EULA=Y brew install msodbcsql18 mssql-tools
Warning: HOMEBREW_NO_ENV_FILTERING is undocumented, deprecated and will be removed in a future Homebrew release (because it breaks many things)!
==> Downloading https://download.microsoft.com/download/5/c/3/5c36bcf5-6571-4715-85e0-174b105b0e7
######################################################################## 100.0%
==> Downloading https://download.microsoft.com/download/1/9/A/19AF548A-6DD3-4B48-88DC-724E9ABCEB9
######################################################################## 100.0%
==> Downloading https://download.microsoft.com/download/F/D/1/FD16AA69-F27D-440E-A15A-6C521A1972E
######################################################################## 100.0%
==> Installing msodbcsql18 from microsoft/mssql-release
==> odbcinst -u -d -n "ODBC Driver 18 for SQL Server"
==> odbcinst -i -d -f ./odbcinst.ini
Last 15 lines from /Users/dev/Library/Logs/Homebrew/msodbcsql18/02.odbcinst:
2022-05-18 07:43:03 +0000

odbcinst
-i
-d
-f
./odbcinst.ini

odbcinst: SQLInstallDriverEx failed with Invalid install path.

If reporting this issue please do so at (not Homebrew/brew or Homebrew/core):
  https://github.com/microsoft/homebrew-mssql-release/issues

dev@imac ~ % 

[v-chojas]

This seems to come up semi-regularly. Have you looked at the previous issues e.g. https://github.com/microsoft/homebrew-mssql-release/issues/40 ?

[ferben]

Thank you. This help: sudo chown [me] /usr/local/etc/odbcinst.ini Following install finish successfully.