set username and password for the datasource in CF Admin Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com
----- Original Message ----- From: "Kay Smoljak" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 06, 2002 9:52 PM 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. > ______________________________________________________ > 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 > > > > > ______________________________________________________________________ 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
