Post reply

Command line password hiding

  • October 5, 2009 at 10:34 am

    #215982

    If I am running SQL scripts in a batch job (using osql or sqlcmd or whatever), is there a generally accepted "best way" to hide the password? This is for SQL 2005 but if there is anything helpfuly in 2008 that would be good too.

    All I could find was using environment variables, but that won't work well for me.

    Thanks

  • October 5, 2009 at 12:40 pm

    #1061928

    Run the batch jobs with Windows auth, and set the password in the Windows scheduler, or other scheduler. That way the account running the batch has the rights.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply