January 14, 2009 at 6:41 am
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
January 14, 2009 at 7:02 am
What errors are you getting when trying to connect to the server?
--Ramesh
January 14, 2009 at 7:09 am
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
January 14, 2009 at 10:59 am
Thanks
I'l do some testing
January 14, 2009 at 11:03 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy