SC Connection
Hi, I was wondering if SC can have connection to 2 SQL Servers in 2 completely different networks? In other words, one SQL Server is in 192.168.23.113 and another SQL Server is in 10.100.41.2. None of the SQL Servers are GP; we just want to exchange data between them. Thanks in advance for your reply.
Answers
Best Answer
msafi,
assuming sql source and sql destination then – yes.
in both source and destination, you would enter the sql creds and point to the source & dest separately for each. So there shouldn’t be any issues that these are separate machines.
Patrick