The biggest gotcha I see is forgetting to select Windows and SQL Server Authentication during the install - it defaults to Windows only. (maybe I'm an idgit, but I don't think this can be changed after install)
--- Billy Cravens -----Original Message----- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 3:16 PM To: CF-Talk Subject: SQL Server Install and CF Just sold our first CF app... a large manufacturing system. It is based on our previous client server mfg systems. The Installation environment is Windows 2000, SQL Server 2000, and CF5. Our development environment is RedHat 7.2, PostgreSQL 7.1, and CF5. Two Questions: 1. Was wondering if anybody has any sage advice about how we install SQL Server. We have never installed or used it but have been told that there are several options we might want to select when we install. 2. Since we were careful to use Generic SQL queries (ANSI 92) we think that it should run with few adjustments to the code. Is that reasonable? 3. What might be considered great source material for learning more about SQL Server? ok, three questions ;) thanks guys, Brian ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
