Post reply

How to get ID address of sql server using T-SQL with non-sysadmin sql account

  • August 7, 2008 at 5:42 am

    #93613

    I am looking for a solution using which one can get IP address of sql server. I got some solutions on Net with I need to get the same when the user credentials do not belong to "sysadmin" role.

    The folliowing is one of the ways only users of sysadmin role can use it:-

    sp_configure 'show advanced options', 1;

    GO

    RECONFIGURE;

    GO

    sp_configure 'xp_cmdshell','1'

    GO

    RECONFIGURE;

    GO

    exec master..xp_cmdshell 'ipconfig'

    best regards,

    SID

  • August 7, 2008 at 5:59 am

    #854375

    navigate to the below url:

    Link: http://weblogs.sqlteam.com/peterl/archive/2008/07/16/How-to-get-IP-address.aspx

  • August 11, 2008 at 11:03 pm

    #856492

    Thanks alot for the same. Due to security constraints, I am not able to open the same at work place. I will go through the same and will get back to you.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply