Hi Kay, You have probably already done it, but (as Bryan S pointed out) did you set the username and password in the ODBC config inside the CF administrator ? (click on "CF Settings" button to get more detailed options)
If the control Panel verifies the DSN, then setting the password in CF Admin may solve the problem. HTH andy > -----Original Message----- > From: Kay Smoljak [mailto:[EMAIL PROTECTED]] > Sent: Monday, 11 February 2002 8:58 AM > To: CF-Talk > Subject: Re: SQL Server on a separate machine > > > 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. > ______________________________________________________ ______________________________________________________________________ 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