you have to configure Cold fusion to run as a different user in the services panel of your admin tools. Make the cold fusion application server run as a different user, preferably a user that has access to the SQL server.
Dan ----- Original Message ----- From: "Kay Smoljak" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 10, 2002 7:58 PM 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. > ______________________________________________________ > 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. > > > ______________________________________________________________________ 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=coldfusiona 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