January 26, 2005 at 12:53 am
Hi there,
I'd like to set up a transactional replication between 2 servers in different domains. I'm told there is a trustrelation between the domains. However, I cannot see the servers from eachothers position. I'v tried creating a linked server, setting security to Windows Only and Mixed, creating a ODBC connection, nodice. I can see both servers from my desktop.
There are differences: server a definitely runs under Win2003, server B runs under WinNT4. Server A runs under local account, server B runs under a global account. Server A is SQL Server 2000, server B is SQL Server 7. I've tried checking under what networkprotocol servers are running, don't know how, because I cannot open the servers with Remote Desktop or such. Don't know under what port they're listening, and if this would make any differences.
What must be done to enable 2 servers to 'see' each other?
TIA,
Hans Brouwer
Greetz,
Hans Brouwer
January 26, 2005 at 7:55 am
A few points:
From the server having SQL 2000 can you map a drive to a share (eg the repldata one) on the other server? If this is not possible, then something is strange about the setup. Try adding an entry into the HOSTS file on the SQL 2000 server you are configuring which has the IP address and NETBIOS name of the SQL 7 server, then see if the share works.
If you don't want to use FTP, you'll need the sql server agent to use a domain login (and be in the local administrators group).
The network protocol must be TCP/IP in the alias defined on the client network utility for non-trusted domains, but I don't see the need here (of an alias).
Rgds,
Paul Ibison (SQL Server MVP)
Paul Ibison
Paul.Ibison@replicationanswers.com
January 27, 2005 at 4:31 am
Tnx for the response Paul. As I said in my first posting I am not allowed to work on the W2003 server directly, which poses some problem.
I did some further research. I can see the other server with the command PING SERVERNAME. Both servers have the same DSN servers and the same WINS servers. I have changed the networkprotocol to TCP/IP on the WinNT server, did not work. I could make a share from the WinNT Server to the W2003 server, so I guess this would work the other way around as well.
I am flabbergasted and don't know what else to do anymore. Any hints?
TIA
Hans Brouwer
Greetz,
Hans Brouwer
January 27, 2005 at 12:30 pm
If you can map a drive, and have access to files, then that's enough.
Make sure B can see the repldata share on A and post up any error message you see when you set up replication.
Also, presumably serverA is the publisher and B is the subscriber?
Rgds,
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply