I've recently moved (yeah I know - it's only been round for years) to the Admin API for creating datasources but had a problem with the unencrypted password not working when verifying the datasource.

All elements of the datasource created correctly but the password was being stored incorrectly - I looked at how to create a twofish (2fish) based password but after coming accross this blog entry it became a lot simpler! However, it does require that you have access to the Java service factory too.

First to set up the service and encrypt the password:-

1  <cfset adminObj = createObject("component","cfide.adminapi.administrator")>
2  <cfset myObj = createObject("component","cfide.adminapi.datasource")>   
3  <cfset service = createobject("java","coldfusion.server.ServiceFactory").getDatasourceService()>
4  <cfset form.password = service.encryptPassword(form.password)>

Next to creat the SQL server datasource:-

1  <cfscript> 
2  // Login is always required. This example uses two lines of code. 
3  adminObj.login("youradminpassword"); 
4  
5  // Create a DSN. 
6  myObj.setMSSQL(driver="MSSQLServer",  
7  name="#form.dsn#",  
8  host = "#form.host#",  
9  port = "#form.port#", 
10  database = "#form.database#", 
11  username = "#form.username#", 
12  password="#form.password#",
13  encryptpassword=false,
14  login_timeout = "29", 
15  timeout = "23", 
16  interval = 6, 
17  buffer = "64000", 
18  blob_buffer = "64000", 
19  setStringParameterAsUnicode = "false", 
20  description = "#form.description#", 
21  pooling = true, 
22  maxpooledstatements = 999, 
23  enableMaxConnections = "true", 
24  maxConnections = "299", 
25  enable_clob = true, 
26  enable_blob = true, 
27  disable = false, 
28  storedProc = true, 
29  alter = true, 
30  grant = true, 
31  select = true, 
32  update = true, 
33  create = true, 
34  delete = true, 
35  drop = true, 
36  revoke = false ); 
37  </cfscript>

Voila, the encrypted password works like a charm!