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
https://ibb.co/0cPGHnM
the above link is the screen shots of no available result while I use my VM to try SELECT IS_SRVROLEMEMBER ('sysadmin')

Tagged:

Comments

  • hi dear i am stuck here mssqlclient.py ARCHETYPE\[email protected] -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'

  • edited June 2020

    Type your comment> @q8cloud said:

    hi dear i am stuck here mssqlclient.py ARCHETYPE\[email protected] -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.

Sign In to comment.