Home Forums SQL Server 2005 SQL Server 2005 Security Is there any way to script out Linked server with remote login password ? RE: Is there any way to script out Linked server with remote login password ?

  • March 4, 2016 at 7:37 am

    #1863109

    simon.jones.p (3/4/2016)

    Hello, I know your post is a bit old so I'm working with a 'better late than never' approach to this.

    Passwords can now be extracted. Anyone who arrives here while looking for the solution, please be aware that with a bit of powershell knowledge, access to the DAC and administrative access to the local machine; you can use the following scripts (explained in the URL and downloadable from github) to get some of the passwords.

    https://blog.netspi.com/decrypting-mssql-database-link-server-passwords/

    Simon

    It seems to work. I was wondering if it would be a security issue, but that's probably not the root cause of the problem. I can't understand why are people still using mixed Authentication.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2