June 24, 2005 at 10:38 am
Hey Folks,
I have setup replication between an instance of MSDE in a dmz and between an instance of SQLServer within our domain, however I am having trouble initializing and reading the data from the publisher. Considering we have strict security policies we have just opened connections between port 1433 on each machine. We have also opened up the SMB ports of 445 and 139 between both servers.
If I setup a pull subscription from the box within the dmz I get the following response(in the history)...
Connecting to Subscriber 'TEST'
Connecting to Distributor 'TEST01'
Initializing
Connecting to Publisher 'TEST01'
Retrieving publication information
Retrieving subscription information
The subscription has been marked for reinitialization. Reinitialization will occur the next time you synchronize this subscription.
Category:NULL
Source: Merge Replication Provider
Number: -2147201001
Message: The schema script '\\TEST\G$\replication\unc\TEST01_dbrepl_dbrepl_merge_240605\20050624163443\TB_USER_49.sch' could not be propagated to the subscriber.
Category:AGENT
Source: TEST
Number: 0
Message: The process could not read file '\\TEST01\G$\replication\unc\TEST01_dbrepl_dbrepl_merge_240605\20050624163443\TB_USER_49.sch' due to OS error 53.
The schema script '\\TEST01\G$\replication\unc\TEST01_dbrepl_dbrepl_merge_240605\20050624163443\TB_USER_49.sch' could not be propagated to the subscriber. The step failed.
Could anyone tell me what I have to do to resolve this... it is driving me crazy, I cannot figure out what it is. All help little or big is greatly appreciated.
Thanks,
M
June 27, 2005 at 8:00 am
This was removed by the editor as SPAM
June 27, 2005 at 9:41 am
Hmm SQL Server and DMZ's are a bit of a problem.
However we manage to solve it by following these rules. I don't know whether all these conditions are nescessary, but if we do it this way then it works.
1) Both servers have to have mixed mode authentication
2) Port 1433 is enabled through the firewall and IP is the default connection method.
3) The two machines know each others name to IP address translation (c:\windows\system32\drivers\etc\hosts or by DNS)
4) The replication uses accounts which are SQL server account NOT domain accounts.
Hope this helps
Regards
Terry
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply