I need to try out SQL Server replication. I'm using VMWare Player 3.1.1. I have a domain controller VM and a SQL Server VM. I took a copy of the SQL Server VM to give me my SQL Subscriber.
I have set the VMs to use "Host-only" network. I have assigned each a unique ip address on the same range and each has a unique machine name. When using only 1 of the SQL Servers with the domain controller then all works fine.
When I try to logon to the second of the SQL Servers after loading the 1st I get an error message "the security database on the server does not have a computer account for this workstation"
Can anyone suggest a way around this please.