Is it Possible to use only one database on one server for 2 web sites?

[Ovatvvon]

Is is possible to have the web site from one server interact with a database on another server?

Here is my situation:

I am running my site from two servers, mine, and then a friends. However, some people go to one, while others go to the other. This is a problem because to have access to the site, you must be authorized, and it stores your personal info on the database where only members of the site have access to it. however, one person may run a search for somone on one server, and that person's records are on the other server.

Sincerely,
Jim

 

[foxdev]

You didn't mention what the database product is. In the case of MS SQL Server, for example, it would be possible, so long as you are setup for TCP/IP protocol (not Named Pipes) and there are no firewall restrictions. Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org

 

[Ovatvvon]

TCP/IP through ODBC broadcast? What about MS Access?

 

[foxdev]

If the two servers are NT and they are on the same domain, you should be able to reference the file from one server on the other. But Access is not a database server like SQL Server or Oracle, so if the machines are not in the same domain or do not have a trusting relationship, I can't think of a way to reference the file via ODBC. Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org

 

[Ovatvvon]

How would I go about setting up a "trust" relationship between the two servers? My buddy (illinois) and I (north carolina) are both learning while working with all this...learning a lot - fast....but still learning.