No impacket.examples.mssqlshell

so, i wanna install impacket and it works, but when i trying to run mssqlclient.py i got this error. what should i do?

Traceback (most recent call last):
File “/home/phyn/impacket/examples/mssqlclient.py”, line 25, in
from impacket.examples.mssqlshell import SQLSHELL
ModuleNotFoundError: No module named ‘impacket.examples.mssqlshell’

2 Likes

Hi, probably it’s because of the PATH. Maybe your user and root do not use the same python interpreter. You can probably run it by executing like this python3 home/phyn/impacket/examples/mssqlclient.py

The cleanest way is to reinstall maybe impacket from scratch. Grab the latest.

git clone https://github.com/fortra/impacket
sudo pip3 install .

Or you can even check the requirements. python3 -m pip install -r requirements.txt

2 Likes

I have the same issue. Could you please tell me how to solve it? Above sulution did not help me.

me too i got the same error while attacking the ARCHETYPE machine!!!

I am also getting this error after having tried various methods to install impacket like trying to install via pipx instead of pip3, having installed the requirements and updated my python interpreter, even going as far to relocate the mssqlshell.py script from the impacket/impacket/examples directory but still to no avail. as of now I am unable to complete this machine due to this error.

I have also noticed that when using pip, I am getting this error

1 Like

Check out my solution, replied to Sakura (most recent comment)

Hi,
I had the same error message too. For me, it was because my VM (Pwnbox) had an old version of Impacket. Here’s how I fixed it (might not be the best way, but it did the trick for me):

#1 Create a virtual environment in your home directory
cd ~
python3 -m venv myenv

#2 Activate the virtual environment, When the virtual environment is activated, you will see (myenv) before your terminal prompt.
source ~/myenv/bin/activate

#4 Update pip in the virtual environment:
pip install --upgrade pip

#5 Install Impacket from the GitHub repository:
pip install git+https://github.com/fortra/impacket.git

#6 Verify Impacket installation:
pip show impacket

#7 Navigate to the virtual environment bin directory:
cd ~/myenv/bin

#8 Run the Impacket mssqlclient.py script:
python3 mssqlclient.py ARCHETYPE/sql_svc@{IP_target} -windows-auth

#To disable the virtual environment:
deactivate

2 Likes

TY, this got me there.
Posting some road bumps I ran into in case its helpful for others.

#5, if you get prompted for uname/password, you have a typo in the url. Don’t go down the rabbit hole of setting up Git fine-grained personal access tokens. You can, but its a waste of your time.

#8, If it just leaves after saying [*] Encryption required, switching to TLS… but just drops you back with no SQL connection, you may have copied the username as ARCHETYPE\sql_svc… from the exposed credential when you needed to use the forward / as indicated here by br4un. I am curious why.

Idk if others are just as foolish as I, but just incase, ensure you have the . after install via sudo pip3 install .