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:357655 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
