I'm writing maintenance plans for SQLServer2008 Express (no SQLAgent and usefulness whatsoever). To check database integrity, perform automated maintenance etc I need to use the SQLCMD utility with an administrative user name and password.
Obviously I'm not going to hard code such things in the script itself but I will have to record them somewhere.
What are my options? I've thought of:
- Putting passwords in a class/package and storing it in an Admin group access only library folder.
- Encrypting it somewhere but this defeats the purpose because you only have to read the code to unencrypt it
Etc...etc... I'm pushing these scripts to over 700 servers as part of our company's supply chain upgrade. Yes they went for free SQLServer versions ( doh! ). The systems have to operate by themselves in cases of comms drop outs which we experience quite a bit.
Any ideas regarding securing passwords with perl much appreciated.