I've never used trusted connections with CF, but I would assume that the account that CF is running under would have to be an account that your other server would have to recognize. You might have to run your CF server service under your name/password.
Marlon ----- Original Message ----- From: "Kay Smoljak" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 10, 2002 6: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
