I am no MSSQL guru but I seem to recall running into this once and it had something to do with the server not being set to allow SQL logins and just windows.
-- Aaron Rouse http://www.happyhacker.com/ On Fri, 19 Nov 2004 17:15:19 -0000, Andy Mcshane <[EMAIL PROTECTED]> wrote: > Is Coldfusion on the same server as the database, if so, I usually just > enter 'localhost' for servername. Have you checked that the login > details in Coldfusion actually has permission to access the database on > SQL server? > > Andy McShane > Head of Development > Scout7 Ltd, > 324a Lichfield Road, > Mere Green, > Sutton Coldfield > West Midlands > United Kingdom > B74 2UW > > Telephone: +44 (0)121 323 2640 > Mobile : 07866 430783 > Fax: +44 (0)121 323 2010 > Email: mailto:[EMAIL PROTECTED] > Website: www.scout7.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184909 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54