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