Thanks I'm going to go down with a SQL user and not use the windows authentication. It wasn't my choice to use more this is what I was given.
Thanks for your help Sent from my iPhone > On 11 Feb 2014, at 22:50, Russ Michaels <[email protected]> wrote: > > > I would also point out that if you are currently running CF as system, then > you obviously have not locked it down either, so you should consider doing > that. > You should also remember that if you run CF as a domain user who has access > to network resources and all the databases on your sql server, then any > code and any person with access to upload code on your cf server also has > this level of access as well. > > >> On Tue, Feb 11, 2014 at 9:03 PM, Dave Watts <[email protected]> wrote: >> >> >>> Im having difficulty in creating a datasource to SQL server that has >> windows authentication setup. >>> When i create the datasource using the SA account it creates >> successfully, but when i try and use the windows >>> account i get an error: >>> 'Login failed for user'\domain\username' >>> >>> i have checked the security options for the server and the user is setup >> as db_owner and when i try and login using >>> the SQL management studio with the windows details i can login >> successfully. >>> >>> it just wont work when creating the datasource. >>> >>> I have tried using different combinations in the username field: >>> domain\username >>> username >>> username.domain.local >>> [email protected] >>> uppercase and lowercase >>> >>> still i get the same error - 'Login failed for user' >> >> I'll second Russ' recommendation to use mixed mode authentication >> instead - it's generally just a lot easier. But if you absolutely, >> positively have to use Windows authentication, follow the steps >> described here: >> >> http://www.cfuser.com/windows-authentication-sql-server-and-coldfusion/ >> >> Dave Watts, CTO, Fig Leaf Software >> 1-202-527-9569 >> http://www.figleaf.com/ >> http://training.figleaf.com/ >> >> Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on >> GSA Schedule, and provides the highest caliber vendor-authorized >> instruction at our training centers, online, or onsite. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357667 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
