Check to make sure that tcpip is enabled in SQL server. SQL 2008 started disabling it by default.
Sent from my iPhone On Dec 22, 2012, at 10:23 PM, Eric Roberts <[email protected]> wrote: > > I am ha king an issue with creating s data source in cf10 administrator > connecting to an MS SQL 2008 sqlexpress version db. Both the db and cf are > on the same box (Dev box). It says login failed for user "cfuser". SQL is > in mixed authentication, I have, triple, and quadruple checked to make sure > the username and password are correct. I have set the tcpip port on the db > to 1433 and enabled it and the127.0.0.1 connection. I have pretty much > followed all of the advice for a similar issue with SQL 2005 and Cfmx. Any > ideas? Thanks in advance. > > Eric > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:353616 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
