Though, it seems impossible to connect MSSQL to Jupyter Notebook because you can not install MSSQL directly on your MAC OS. This tutorial will help in connecting MSSQL to Jupyter Notebook on MAC OS.
<pre><code class="lang-python">brew install msodbcsql17 mssql-tools
</code></pre>
This will install openssl@3, microsoft/mssql-release/msodbcsql17, microsoft/mssql-release/mssql-tools
<img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1682438459900/8e030817-4633-48cd-969f-b34fd43ef294.png" alt class="image--center mx-auto" />
<img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1682438538367/49cfb5be-f3c0-4d61-8fe9-647f0dda1d4b.png" alt class="image--center mx-auto" />
Then, you go ahead and install the package
<pre><code class="lang-python">python3 -m pip install pyodbc
pip install --upgrade pip
</code></pre>
<img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1682438681007/db52e0d1-2803-4b62-8cfe-df396b3037a0.png" alt class="image--center mx-auto" />
<pre><code class="lang-python">brew install unixodbc
brew install freetds

odbcinst -j

sudo ln -s /usr/local/etc/odbcinst.ini /etc/odbcinst.ini
sudo ln -s /usr/local/etc/odbc.ini /etc/odbc.ini
</code></pre>
<pre><code class="lang-python">brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
brew update
brew install msodbcsql mssql-tools

odbcinst -j

sudo ln -s /usr/local/etc/odbcinst.ini /etc/odbcinst.ini
sudo ln -s /usr/local/etc/odbc.ini /etc/odbc.ini
</code></pre>

Though, it seems impossible to connect MSSQL to Jupyter Notebook because you can not install MSSQL directly on your MAC OS. This tutorial will help in connecting MSSQL to Jupyter Notebook on MAC OS.

```python
brew install msodbcsql17 mssql-tools
```

This will install **openssl@3, microsoft/mssql-release/msodbcsql17, microsoft/mssql-release/mssql-tools**

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1682438459900/8e030817-4633-48cd-969f-b34fd43ef294.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1682438538367/49cfb5be-f3c0-4d61-8fe9-647f0dda1d4b.png align="center")

Then, you go ahead and install the package

```python
python3 -m pip install pyodbc
pip install --upgrade pip
```

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1682438681007/db52e0d1-2803-4b62-8cfe-df396b3037a0.png align="center")

```python
brew install unixodbc
brew install freetds

odbcinst -j

sudo ln -s /usr/local/etc/odbcinst.ini /etc/odbcinst.ini
sudo ln -s /usr/local/etc/odbc.ini /etc/odbc.ini
```

```python
brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
brew update
brew install msodbcsql mssql-tools

odbcinst -j

sudo ln -s /usr/local/etc/odbcinst.ini /etc/odbcinst.ini
sudo ln -s /usr/local/etc/odbc.ini /etc/odbc.ini
```

Though, it seems impossible to connect MSSQL to Jupyter Notebook because you can not install MSSQL directly on your MAC OS. This tutorial will help in conne

How to connect MSSQL to Jupyter notebook on MAC OS