Connecting MS Access to a SQL 2005 Express

• ulf.a

  Newbie

  Points: 8

  More actions

  January 14, 2009 at 6:41 am

  #71846

  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

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  January 14, 2009 at 7:02 am

  #926548

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

  --Ramesh
  

  ---

• GSquared

  SSC Guru

  Points: 260824

  More actions

  January 14, 2009 at 7:09 am

  #926552

  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

• ulf.a

  Newbie

  Points: 8

  More actions

  January 14, 2009 at 10:59 am

  #926773

  Thanks

  I'l do some testing

• Matt Miller (4)

  SSC Guru

  Points: 124210

  More actions

  January 14, 2009 at 11:03 am

  #926779

  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?