Post reply

Any Way to get the login information - SQL Port Number

  • June 30, 2015 at 6:41 am

    #319503

    is there a way to identify who have changed the SQL port number other than the DBA's?

    for example through c2 audit or any other triggers?

  • June 30, 2015 at 7:29 am

    #1809113

    is it a named instance or default instance?

    what is it changing from and to?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • June 30, 2015 at 7:32 am

    #1809118

    its a Named instance..somebody changed the port number and left it for a month. After server reboot, the issue got raised. we don't have any information in the default trace as it is changed a month ago.

  • June 30, 2015 at 8:35 am

    #1809154

    Please post the output of this powershell query, substitute VERSION.INSTID for your sql server version and instance name

    Get-ChildItem "hklm:\software\microsoft\microsoft sql server\mssqlVERSION.INSTID\mssqlserver\supersocketnetlib\tcp\" | ForEach-Object {Get-ItemProperty $_.pspath}

    so if you're using sql server 2012 and instance name is FRED use

    Get-ChildItem "hklm:\software\microsoft\microsoft sql server\mssql11.FRED\mssqlserver\supersocketnetlib\tcp\" | ForEach-Object {Get-ItemProperty $_.pspath}

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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