Connecting MS Access to a SQL 2005 Express

  • I have connected my Access ADP to a SQL 2005 Express receding in a ordinary desktop PC in the same network, and it works OK.

    The connection is something like ServerPCName\SQLExpress.

    The problem is that users in other networks can not connect to the SQL server.

    Then I tried somthing like Network\ServerPCName\SQLExpress.

    Without any success.

    What to do?

    /Ulf

  • What errors are you getting when trying to connect to the server?

    --Ramesh


  • Not entirely sure what you mean by "other networks". Most likely, what you need to do is use the IP address of the computer with the database on it. If, on the other hand, you mean people are trying to connect to the database from other locations, not on the same LAN, then you'll need to expose that database to external connections and set it up with an externally available IP address and all that.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Thanks

    I'l do some testing

  • Also - might be worth taking a look under the Surface Area Configuration. Even with Express - the default setting is to NOT allow remote connections to your DB server, so you have to actually turn that on....

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Viewing 5 posts - 1 through 5 (of 5 total)

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