http://www.thycotic.com/forums/messages.aspx?TopicID=423 Thycotic Community - Secret Server - Action = Change ODBC Settings - Messages en-us http://blogs.law.harvard.edu/tech/rss Jitbit AspNetForum Tue, 06 Mar 2012 14:15:58 GMT Tue, 06 Mar 2012 14:15:58 GMT http://www.thycotic.com/forums/messages.aspx?TopicID=423
You are correct, this is not currently possible with Secret Server. We do plan on expanding the password changing functionality of Secret Server to allow for more custom setups such as this one. This would include the ability to execute custom scripts as Secret Dependencies, so you could configure Secret Server to update a DSN entry after a password change occurs.

Thanks,
Ben]]> Tue, 06 Mar 2012 14:15:58 GMT http://www.thycotic.com/forums/messages.aspx?TopicID=423
Here is the scenario:
We have an application server that is tied to a SQL server. The application makes its connections via SQL Authentication that has been preprogrammed as an ODBC system DSN. Occasionally the application needs updated, however the updater software requires the application team to type the SQL Auth password. This mean I as a server admin must give over the password and let the app team upgrade their SW. After that I must go back into SQL, change the password and change it again in the ODBC settings. This is a lot of manual steps. I was hoping that Secret Sever would help me by doing the following:
1. The app team checks out the Secret
2. The Current Password is displayed
3. The App Team preforms the upgrade
4. The app team checks in the Secret
5. Secret Sever would change the password of the viewed SQL account on the correct SQL server
6. Secret Sever would update ODBC System DNS of the viewed SQL account on the correct Application server

Is this solution even possible with the current version? I am thinking it is not because one secret needs to track the SQL server, the Application Server(s), and the system DSN name.
]]> Tue, 06 Mar 2012 10:05:49 GMT