Is it with Tableau Server that you are having issues opening the workbooks? If so, then the following links should be able to provide you with the information necessary to open a workbook unprompted:
No, it wasn't on server, it was in desktop. However, I have since resolved the problem, not sure exactly what did the trick. I set up another connection to the database (teradata) in the ODBC control panel, and then restarted Tableau. After going back in, I was prompted to enter my db password, and after that, it seemed all my workbooks were then using the new password. I'm not sure I understand how that worked -- is the Data Connection in Tableau (with old password) now refreshing the password field with data from the new driver config?? Or was the old password cached, so simply restarting Tableau cleared the cache and allowed the new one to be saved?? With all the troubleshooting I was doing, I lost a methodical approach, so can't pin down exactly what did the trick. If someone knowledgeable about how configurations in the ODBC control panel and saved Data Connections in Tableau work together, I'd really like to understand better what fixed this.
Thanks for your response.