The account that it's running as does have admin rights on the dev machine (it's a member of the local administrators group) but it's a domain account. I haven't had the time to work up the proper security configuration for it to work as a less priveledged user. Although, I would imagine that it can be done.
Jeff -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 8:50 PM To: CF-Talk Subject: RE: ODBC Problems? you mean installed and ran under a user other than Administrator? tony -----Original Message----- From: Jeff Garza [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 10:47 PM To: CF-Talk Subject: RE: ODBC Problems? I have the ODBC connector working with a SQL Server database in my development environment. It's the only way we have right now to connect to our SQL Servers as our DBA is loath to enable SQL Server Authentication. We run our CFMX service as a named domain account that has rights to the database. It works fine, albeit, there is very little load on this server and due to the config of the server, we do not load test on it. Specs are CFMX Updater 2, IIS 5.0, Win2k Server (Standard), SQL Server 2000 with SP 2 applied. I think that the key here is running CFMX as a named user. I couldn't get it to work when it ran as system. HTH, Jeff Garza -----Original Message----- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 8:23 PM To: CF-Talk Subject: Re: ODBC Problems? To get back onto the original topic: Has anyone found the ODBC socket connection to work? Using what db/version? We've heard from people who didn't, both in this thread and previously. Who can share with us an experience of a stable connection? Maybe if we approach this from a different end we'll hear some good news. ------------------------------------------- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com ------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
