Yes is is possible via a linked server. Use the UI to setup a linked server between the two servers. The domains do not need to be trusted, you just need to know the IP of the remote machine, and have a hole in the firewall to connect to the SQL Server on the remote machine.
Then use the full four part name to access data across the linked server.
Last Wiki Answer Submitted: April 29, 2008 4:55 pm by Denny Cherry64,520 pts.