Would you happen to be using MS SQL Express locally? You may need to adjust your TCP/IP connection settings for SQL, as well as adjust the systems firewall rules for access. The following post may assist some:
http://www.fusioncube.net/index.php/coldfusion-sql-server-express Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer ____________ http://cutterscrossing.com Co-Author "Learning Ext JS 3.2" Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book "The best way to predict the future is to help create it" On 2/11/2014 2:43 PM, Anthony Doherty 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 > usern...@domain.com > 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:357656 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
