best method is to use mixed mode and use an sql login from coldfusion dsn. If you want to use a windows authentication then you need to run coldfusion under a windows user with authentication on the sql server.
On Tue, Feb 11, 2014 at 8:43 PM, Anthony Doherty <[email protected]>wrote: > > Hi, > 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' > > any help would be greatly appreciated! > > Thanks > Anthony > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:357657 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
