Starting Point:foothold->IS_SRVROLEMEMBER question

According to the guide of hackthebox, there should be 1 result found after input SELECT IS_SRVROLEMEMBER (‘sysadmin’). However, why the SQL server doesn’t hv any result available while I use my VM to try SELECT IS_SRVROLEMEMBER (‘sysadmin’)? Thank you very much first

the above link is the screen shots of no available result while I use my VM to try SELECT IS_SRVROLEMEMBER (‘sysadmin’)

hi dear i am stuck here mssqlclient.py ARCHETYPE\Guest@10.10.10.27 -windows-auth
Impacket v0.9.22.dev1 - Copyright 2020 SecureAuth Corporation

Password:
[*] Encryption required, switching to TLS
[-] ERROR(ARCHETYPE): Line 1: Login failed for user ‘ARCHETYPE\Guest’

Type your comment> @q8cloud said:

hi dear i am stuck here mssqlclient.py ARCHETYPE\Guest@10.10.10.27 -windows-auth
Impacket v0.9.22.dev1 - Copyright 2020 SecureAuth Corporation

Password:
[*] Encryption required, switching to TLS
[-] ERROR(ARCHETYPE): Line 1: Login failed for user ‘ARCHETYPE\Guest’

I was generous and answered your question in another thread. Please though, you can’t just hijack other people’s threads with your question, especially not by spamming EVERY thread. Make one for yourself.

Or don’t, actually, just go look at my reply in that other thread.