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
