Obtain SQL Login account password
If it's a sql login and you have access to the application servers, you could look for it in connection strings on those. Otherwise, there is no way to find the password.  Your only option is to reset the password.