No password or blank passwords in datasources, or blank passwords for the sa account will leave you open to unacceptable security risks. There are a number of SQL server exploits that use blank passwords to compromise your server. http://support.microsoft.com/default.aspx?scid=kb;en-us;313418
I don't know your situation, but I sure don't understand why you would need 50 datasources on a single server, instead of a central database (single datasource) with multiple tables. I guess it would be different if you were accessing multiple servers, in a widely distributed environment though. ====================================== Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf ====================================== If you are not satisfied with my service, my job isn't done! ----- Original Message ----- From: "Daniel Pacitti - ASP" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 27, 2003 6:25 AM Subject: Setting up datasources with SQL Server | I am trying to set up some datasources in CFMX Administrator. I have bout | 50 to do. The only way that i can get the datasources to verify correctly | is to enter an sql server username and password when the datasource is | created. | | When in CF5 i can sucessfully verify the datasouce without the need to enter | a username and password, and i was hoping that i could do the same again in | CFMX so when i change passwords i don't have to make the same change 50 | times!! | | Is there an easier way of doing this without having to enter the password in | everytime i make a datasource?? | | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
