Skip to main content
Participating Frequently
February 9, 2010
Question

mssql2k5 connection to cf9

  • February 9, 2010
  • 1 reply
  • 521 views

hello- need help establishing a connection from my ms "sqlexpress" instance in cf9 administrator (note: using windows 7 if that matters).  I cannot create the datasource and continually get an error stating that the instance is not running.  I verfied that all sql services are enabled, naming conventions are correct, tcip is enabled, ports seem correct... not sure what i'm missing.  I am experienced in setting up mssql->cf connectivity and i've checked all my previous pitfalls, i'm stumped.

any help is appreciated,

dj

    This topic has been closed for replies.

    1 reply

    Inspiring
    February 9, 2010

    Is mixed mode authentication enabled in your SQL instance?  I think that in the default SQL install only Windows authentication is enabled.

    Participating Frequently
    February 10, 2010

    i believe it is in mixed mode.  I'm able to connect to the server directly using a user/pwd combination in the user/password.

    dj