Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Access SQL Server On Different Domain

Author  Topic 

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2002-09-20 : 10:24:08
I've porting an access app which is used by people on two domains.
Lets called them EDomain and WDomain.

The access application exists on the EDomain so for people to connect to it from the WDomain they have to use a full unc path.
ie: \\MACHINE1.ED.EDomain.com\ACCESS\DATABASE.mdb

The application I wrote uses a connect string that
has Data Source = MACHINE1 and WorkStationID = MACHINE1 which
works fine for people in EDomain but how do I extend that to work for people in WDomain. Do I have to put in the IP ADDRESS INSTEAD?




robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-09-20 : 10:29:05
You might need to go IP address. See if this helps:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=13389

Also try a forum search on "trusted domains", you'll get a few more links. I know someone had a similar question to yours, I think it depends upon setting up a trust between domains.

Go to Top of Page
   

- Advertisement -