Replication BT SQL SERVER in DMZ and SQL SERVER on LAN

Replication BT SQL SERVER in DMZ and SQL SERVER on LAN

Post by Boy » Fri, 22 Nov 2002 02:19:32



Hello All,

I have a web server in a DMZ that is running sql server 2000 and a sql
server on our LAN that need to replicate to and from each other.

They cant see each other.

The publication fails and says Subscription invalid

I am quite new to this and would appriciate any help.

Thank you

Boyd

 
 
 

1. how to backup a sql server 65 server from a sql server 2000 server

i have two servers:
one with sql server 2000 which replicates (transact) to the sl server 65
server (on a seperate machine); once distribution is complete, i need to
backup sql server 65, and copy backup to other servers using robocopy)

how can i link these processes together?

can i backup the sql server 65 db on antoher machine from the machine which
has sql server 2000? how?

thanks
stephane

2. @@identity question

3. Problem connecting one SQL Server server to another SQL Server server

4. >>>Entrepreneurs Needed<

5. SQL Server 7.0 on NT Server to SQL Server 7.0 on win2k Pro

6. Multiple Client Installations

7. SQL Server 7 - SQL Server 2000 on same server

8. .FindFirst grief !!!! Error 3070

9. SQL Server 7.0 on NT Server to SQL Server 7.0 on win2k Pro

10. SQL Server 2000 license overriding SQL Server 7.0 license on separate server

11. Install SQL Server 2000 and SQL Server 7 on same server

12. SQL Server 7.0 on NT Server to SQL Server 7.0 on win2k Pro

13. link server from Oracle to SQL server occurs blocking on SQL server