Hi Kay, Check your ODBC configuration on your client machine, as it might be that, rather than the SQL Server config. The SQL Server ODBC driver may be configured to use "With Windows Authentication" and you can change this to "With SQL Server authentication" Alternatively, if you do need to use Trusted connection, go to the CF Administrator/ODBC/your DSN and check the Use Trusted Connections box. Also, watch out for ODBC config resetting itself to Named Pipes instead of TCP/IP.
HTH andy > -----Original Message----- > From: Kay Smoljak [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 7 February 2002 1:53 PM > To: CF-Talk > Subject: SQL Server on a separate machine > > > Hi all, > > Our development environment has CF4.5 and SQL Server 2K on an SBS2K > machine on a LAN. Some of my clients are on CF5 hosting, and there are > some features of CF5 I would like use for these clients. I have the > Developers edition of CF5 on my Win2K machine, and I would like it to > connect to databases on the SQL Server (over the LAN). I can set up a > DSN on my machine, but when I try to run a CFQuery it errors out because > I'm not using a "trusted connection". How do I set the server up so it > will allow my machine to connect? Can I even do this on SBS2K? > > Thanks, > Kay. ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
