You would have to check this in SQL server. There are different ways of configuring SQL access, personally I have created a user with limited rights that matches my Coldfusion login details i.e.
Coldfusion login username = wibble Coldfusion login Password = wobble In SQL server I then create the following SQL server login username = wibble SQL server login password = wobble I then specify which databases that user has permission to access. Without knowing exactly how you have SQL access configured i.e. windows authentification or mixed mode access it is difficuly to advise. To check whether you have a user login in SQL that matches your Coldfusion details you will have to use the SQL Enterprise Manager, click on the the SQL instance under SQL server group, select security and click on logins. You will then be able to see what users exist and also add new ones if needed. 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:54 To: CF-Talk Subject: Re: SQL Datasource 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:184950 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