THANK YOU!!!!!! I believe a Support person may have done this last week. If I appear to have the ability to change the password in SA -> Properties (that is, it is not grayed-out), then apparently I can change it?
Thanks again... -- richard From: [email protected] [mailto:[email protected]] On Behalf Of Kibble,Tony Sent: Wednesday, July 29, 2015 1:04 PM To: [email protected] Subject: [NTSysADM] RE: Password retriever http://community.spiceworks.com/how_to/22044-recover-sa-password-on-microsoft-sql-server Tony From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Richard McClary Sent: 29 July 2015 17:25 To: [email protected]<mailto:[email protected]> Subject: [NTSysADM] Password retriever Greetings! Here is one of those notes we all have a good laugh, etc over, but... Several years ago, an MS SQL Server 2005 database was installed (on Windows2003R2). The installer is long gone now. It seems the password for the SA account is not recorded anywhere, and it might be useful in migrating the data to a new SQL Server 2012 database. There are a couple of accounts which have not quite SA rights. It could be that these accounts will let us migrate the data. However, just in case... Anyone know a tool which would recover the SA account password? Now, back to digging through drawers, looking under server racks, etc... -- richard The information contained in this e-mail, and any attachments hereto, is from The American Society for the Prevention of Cruelty to Animals(r) (ASPCA(r)) and is intended only for use by the addressee(s) named herein and may contain privileged and/or confidential information. If you are not the intended recipient(s) of this e-mail, you are hereby notified that any dissemination, distribution, copying or use of the contents of this e-mail, and any attachments hereto, is strictly prohibited unless authorized by the sender. If you have received this e-mail in error, please immediately notify the sender by reply email and permanently delete this e-mail and any printout thereof. ________________________________ DISCLAIMER This material has been checked by us for computer viruses and, although none has been found, we cannot guarantee that it is completely free from such problems and we do not accept liability for loss or damage which may be caused. This message is intended only for use of the individual or entity to whom it is addressed and may contain information which may be privileged and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately via e-mail and delete the message. Thank you. ******************************************************* Travelers Insurance Company Limited is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority in the UK and is regulated by the Central Bank of Ireland for conduct of business rules. Registered in England 1034343. Registered as a branch in Ireland 903382. Travelers Syndicate Management Limited is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority. Registered in England 03207530. Travelers Underwriting Agency Limited is authorised and regulated by the Financial Conduct Authority. Registered in England 03708247. Travelers Professional Risks Limited is an appointed representative of Travelers Insurance Company Limited which is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority. Registered in England 05201980 Travelers Management Limited. Registered in England 00972175. The registered offices for all companies listed above is: Exchequer Court, 33 St Mary Axe, London, EC3A 8AG. All other branch offices are available from our websites. travelers.co.uk travelers.ie Issues to: mailto: [email protected]<mailto:[email protected]> ________________________________ This communication, including attachments, is confidential, may be subject to legal privileges, and is intended for the sole use of the addressee. Any use, duplication, disclosure or dissemination of this communication, other than by the addressee, is prohibited. If you have received this communication in error, please notify the sender immediately and delete or destroy this communication and all copies. TRVDiscDefault::1201 The information contained in this e-mail, and any attachments hereto, is from The American Society for the Prevention of Cruelty to Animals(r) (ASPCA(r)) and is intended only for use by the addressee(s) named herein and may contain privileged and/or confidential information. If you are not the intended recipient(s) of this e-mail, you are hereby notified that any dissemination, distribution, copying or use of the contents of this e-mail, and any attachments hereto, is strictly prohibited unless authorized by the sender. If you have received this e-mail in error, please immediately notify the sender by reply email and permanently delete this e-mail and any printout thereof.
