Hmmm...despite the conventional wisdom otherwise... I nuked the user and recreated it, making the authentication type SQL Authentication and it worked! Go figure... On Dec 22, 2012 10:33 PM, "Eric Roberts" <[email protected]> wrote:
> Did that...tcpip is enabled...all of the "0"s were removed from the > dynamic ports and port was given the value of 1433...127.0.0.1 was turned on > > Eric > On Dec 22, 2012 10:17 PM, "Steve Durette" <[email protected]> wrote: > >> >> 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:353618 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
