October 27, 2006 at 9:24 am
Hi friends. I have a doubt with replication and remote server.
I've configure a database replication (snapshot) between 2 sql servers (2K with SP3a, soon 4). Now, due to SOX standards, we need to disable the "Allow other SQL Servers to connect remotely to this SQLServer using RPC" (Remote Servers). I know SQL Server 2000 supports remote servers for backward compatibility only. but, when i go to the Remote Servers Under Security Menu, I see 3 remote servers connections created:
- Source Server
- Destination Server
- Repl_distributor (?)
Note: This replica was made in SQL2000 sp3a, is not legacy from an older SQL version.
So, if i disable the "Allow other sql....." the replica will work fine? Exist some alternative method to configure this?
Thanks for advices...
Martin.
October 30, 2006 at 8:00 am
This was removed by the editor as SPAM
October 31, 2006 at 3:56 am
Having worked with SOX for a number of years I'd take exception to the statement SOX requires disabling RPC connections - sorry that's absolute Tosh !! If your systems talk to each other then you need RPC / linked servers ( technically a RPC only connect is far more secure than a linked server ) anyway I digress. You will always see your own server listed under servers. If you have remote calls then you'll have remote servers - if you don't need remote calls then you don't need the connection. as far as I know replication requires registration of subscribers and distributors - just don't have a suitable system to hand just now to check.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply