Post reply

Problem loging into 2008 express

  • October 12, 2008 at 11:35 am

    #194549

    I've successfully installed SQL Server Express onto my XP Home SP3 machine. I can log into the DB via windows authentication and a new login/password that I created.

    The issue is when I try to open a connection via a .Net app I get "SQL Server does not exist or access denied." error number 17

    gsConnString = "Data Source=(local);Database=XXX;" & _

    "User Id=XX;Password=XX;"

    Ideas?

  • October 12, 2008 at 12:15 pm

    #883917

    "Data Source=(local)" resolves to the default instance on the local machine. Express always installs as a named instance with the instance name "SQLEXPRESS"

    Try "Data Source = < Server name >\SQLExpress"

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 12, 2008 at 1:03 pm

    #883928

    worked

    thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply