August 3, 2012 at 10:58 am
Just wanted to know what do other DBA's use to manage passwords of SVC account. I should be able to install this tool on a windows server.
August 3, 2012 at 11:57 am
sqldba_newbie (8/3/2012)
Just wanted to know what do other DBA's use to manage passwords of SVC account. I should be able to install this tool on a windows server.
I use KeePass. I don't know why I chose this one other than it was the first one I tried. It is free and it does a decent job of storing my data. Not sure I would store my passwords on a server though unless it is an internal file/app server.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 3, 2012 at 12:12 pm
Lifehacker routinely recommends KeePass.
August 3, 2012 at 12:32 pm
KeePass also has a mobile version now. I have it on my android and I can use the same file as my windows version. I keep the windows version as the master but I have access from my phone anywhere. Pretty slick.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 3, 2012 at 1:25 pm
Sean Lange (8/3/2012)
sqldba_newbie (8/3/2012)
Just wanted to know what do other DBA's use to manage passwords of SVC account. I should be able to install this tool on a windows server.I use KeePass. I don't know why I chose this one other than it was the first one I tried. It is free and it does a decent job of storing my data. Not sure I would store my passwords on a server though unless it is an internal file/app server.
I want all the passwords to be on a centralized place, not on local user machines for obvious reasons.Thansk
August 3, 2012 at 1:31 pm
sqldba_newbie (8/3/2012)
Sean Lange (8/3/2012)
sqldba_newbie (8/3/2012)
Just wanted to know what do other DBA's use to manage passwords of SVC account. I should be able to install this tool on a windows server.I use KeePass. I don't know why I chose this one other than it was the first one I tried. It is free and it does a decent job of storing my data. Not sure I would store my passwords on a server though unless it is an internal file/app server.
I want all the passwords to be on a centralized place, not on local user machines for obvious reasons.Thansk
Which I was I said unless it is internal. 🙂 I have seen password vaults stuck on a webserver at clients in the past. Not exactly a great location for them. KeePass stores all the data in a file that is encrypted. There is nothing to prevent somebody from copying that file and using it elsewhere as long they know the master password.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 3, 2012 at 1:33 pm
Sean Lange (8/3/2012)
sqldba_newbie (8/3/2012)
Sean Lange (8/3/2012)
sqldba_newbie (8/3/2012)
Just wanted to know what do other DBA's use to manage passwords of SVC account. I should be able to install this tool on a windows server.I use KeePass. I don't know why I chose this one other than it was the first one I tried. It is free and it does a decent job of storing my data. Not sure I would store my passwords on a server though unless it is an internal file/app server.
I want all the passwords to be on a centralized place, not on local user machines for obvious reasons.Thansk
Which I was I said unless it is internal. 🙂 I have seen password vaults stuck on a webserver at clients in the past. Not exactly a great location for them. KeePass stores all the data in a file that is encrypted. There is nothing to prevent somebody from copying that file and using it elsewhere as long they know the master password.
Where would you recommend to have it installed?
August 3, 2012 at 1:38 pm
Well I don't know how the other work but KeePass is a client application. It can open a data file from anywhere. So you would install the client on any workstation that needs it. Then you open the database from wherever you want to keep it (most likely a secure file storage on your network). Then everybody can access the same file and there is only 1 copy of it. I have no idea how it handles concurrency. That is not something I have had to worry about because we have a small team.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 3, 2012 at 1:39 pm
Sean Lange (8/3/2012)
Well I don't know how the other work but KeePass is a client application. It can open a data file from anywhere. So you would install the client on any workstation that needs it. Then you open the database from wherever you want to keep it (most likely a secure file storage on your network). Then everybody can access the same file and there is only 1 copy of it. I have no idea how it handles concurrency. That is not something I have had to worry about because we have a small team.
Thanks. This helps. For some reason my company is not big favour of Open Source 🙁
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply