Cisco Support Community
Showing results for 
Search instead for 
Did you mean: 

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Changing passwords on option list SQL queries

Changing passwords on option list SQL queries

I'm on 2006.0.6.  We've been using the ability in Service Designer to use a SQL query to populate a select/radio/checkbox list quite a bit.  It seems to require entering the username and password every time a new SQL query is used.  Ideally it would allow those field to remain empty and use the values supplied in the ColdFusion data source.  So I now have over a hundred of these SQL queries across many many services.  And the big question is what to do when I need to change the password for the SQL account?  It would be a nightmare to manually update every service and re-migrate them.  The only thing I could think of was to perform an database level update on the DEFMULTIVALUE table where these entries are stored, but that certainly isn't the ideal way to take care of the problem.  Does anyone have any advice on this? 

Everyone's tags (1)
CreatePlease login to create content