How do I make sure CF has permission to access SQL server?
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 > > > > > -----Original Message----- > From: Donna French [mailto:[EMAIL PROTECTED] > Sent: 19 November 2004 17:10 > To: CF-Talk > Subject: Re: SQL Datasource > > still no luck on this. can anybody help me out? i've entered my local > machine name & no luck??? > > On Thu, 18 Nov 2004 15:13:41 -0600, Eric Creese <[EMAIL PROTECTED]> wrote: > > GOT THE SERVER NAME RIGHT? YOU MAY HAVE TO USE THE NAME OF YOUR LOCAL > MACHINE > > > > > > > > -----Original Message----- > > From: Donna French [mailto:[EMAIL PROTECTED] > > Sent: Thursday, November 18, 2004 3:05 PM > > To: CF-Talk > > Subject: SQL Datasource > > > > I'm trying to setup a SQL Server datasource and keep getting an error. > > I've imported my database locally from the remote server using DTS, > > and have named the datasource, database, appropriate datasource type. > > Any suggestions welcome. > > > > TIA, > > Donna > > -- > > ------------------------ > > Donna French > > [EMAIL PROTECTED] > > > > Blog: http://dgfrench.blogspot.com > > Site: http://www.dgfrenchdesigns.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:184915 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54