comment on

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.

In reply to Using Admin Passwords in Script by OzVegan

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


Perl: the Markov chain saw
	PerlMonks