> (by the way, you're not given any warning when your > 120 day trial period is about to end, and once it ends, > you're apparently SOL accessing those databases until > you buy a version of SQL Server)
You can always copy the databases to another SQL Server machine, and attach them. > I bought the Developer edition and installed it over > the trial version. During that installation process, > at the step when you're choosing "Windows Authentication" > or "Mixed Mode" I couldn't recall which way I had done it > before, so I chose Windows Auth. The install went seemingly > ok. The CFMX Admin was still able to verify the DSN > without any problems. To use the Type 4 MS SQL Server JDBC driver, you'll need to configure your database server to use Mixed Mode authentication. You can do this without reinstalling it, though. Just go into Enterprise Manager, right-click on your server, select "Properties", go to the "Security" tab, then select "SQL Server and Windows" under "Authentication". I'm pretty sure you'll also need to use TCP/IP connectivity. By default, that's enabled, but if you disabled it for some reason, you'll need to enable it within the Server Network Utility within the "Microsoft SQL Server" menu group. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
