locked
History on changing alias for Sharepoint 2013 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi ,

    Is it possible to know when the SQL aliases had been changed and by whom?

    There is no possibiliy via run-> cliconfg.

    Maybe logs?

    thank you for your help

    Tuesday, December 12, 2017 2:57 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I'm not aware of any means to find this and I just did this in my lab then searched application and systems logs to no avail.

    It is possible to query domain controller event logs to deteremin who logged into your server though.

    Stacy Simpkins | MCSE Productivity | MCSE SharePoint 2013 | anothersharepointblog.com

    Saturday, March 10, 2018 9:00 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi coco0185,

    Even SharePoint don't log adding/editing sql aliases through cliconfig tool, but if you enabled Audit policy on your SharePoint server , you can search cross event viewer -> security, because adding/editing an entry in cliconfig will add a key in registery editor as the following screenshots

    And any changes to the registery editor will add an event to the event viewer => security .

    Best Regrads, Ahmed Madany MCTS @twitter http://twitter.com/ahmed_madany @Blog http://ahmedmadany.wordpress.com @LinkedIn http://eg.linkedin.com/pub/ahmed-madany/35/80/2b6

    Saturday, March 10, 2018 10:20 PM