Thanks for your help. I have changed the SQL Server security tab settings on the server to allow "SQL Server & Windows" authentication. I have set the DSN up on my local machine using Windows ODBC and it verifies fine. I then look it up in the CF administrator and it fails. I have tried:
- Named pipes in the client network utility - Named pipes in the client network utility and "use trusted connection" checked in the CF administrator - TCPIP in the client network utility - TCPIP in the client network utility and "use trusted connection" checked in the CF administrator I am sure that the username and password are correct - and the Control Panel ODBC applet is able to test the connection successfully no matter which combination of the above I use. Any other ideas as to what the problem is? Could it be something to do with user permissions for IIS on my local machine? Thanks again, Kay. ______________________________________________________ Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd Level 9/105 St George's Terrace - Perth - Western Australia Ph: (08) 9226 1366 Fax: (08) 9226 1375 www.perthweb.com.au http://developer.perthweb.com.au - Tools for Developers cfx_pwcamtech | cfx_pwimageproc | cfx_pwcardcyrpt "Andy Parry" <[EMAIL PROTECTED]> wrote in message news:<000001c1af9c$d510ede0$[EMAIL PROTECTED]>... > 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. > ______________________________________________________________________ Get Your Own Dedicated Windows 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=coldfusionb 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
