Wednesday, March 21, 2012

Replication between 2 SBS (small business server) Trusts

I have SQL running on SBS Server A. It is a publisher and a distributor of a
database that has 1 subscriber a SQL Server running on SBS Server 2. How doe
s
one replicate in a untrusted enviroment.
there was also a free ware dll that allowed sql to invoke the ras dialer..
does anyone have the valid url to this?-- Current Standings (taken from my post on the SBS Site) --
I posted on the SQL server site and was referred to Q321822. This Q article
had only 2 paragraphs that mentioned connection between 2 non-trusted
domains. essentially it suggested creating a server agent account on both
machines. it says you 'must set up pass through authentication'. There is wa
s
some data missing from the article.
1) How do you set up 'pass through authentication" via a SQL Agent Account?
2) Assuming 'Pass Through' is enabled, how does one reference the SBS Server
?
a) 'Local Area Connection' IP Address (not likely) 192.168.0.2 (private)
b) Local Server Name. MyServer
c) FQDN MyCompany.MyServer.
d) Public Resolvable Domain Name MyCompany.com
i) With extension .com
ii) Without extension
e) Network Connection IP Address of Server 68.XXX.XXX.217 (Public)
None of the above options worked for me, response "Server doesn't exsist or
Access denied" (which is it? MDAC doesn't even know if the Server Exists?
What’s with that?)
I found the information sources lacking. None seemed to illustrate a Point A
to Point Z scenario on SBS. This is not a Version 1 product and being that
trusts are not allowed it's conceivable that many companies would be
attempting non-trusted replication.
PS, I've checked Kbase, SQL BOL, 4 MVP sites, Newsgroups, Online Concierge
and SSWUG. I was exposed to answer bits, in addition to the above mentioned
options, there was mentioned RPC over TCP, RPC over UDP, Linked server
options, Remote server options, SSL options, replication via Backup and
Restore, replication via output files, Replication via terminal services
etc..
Now, I'm a person of reasonable intelligence, willing to the put the time
and effort into research, but am I wrong here when I suggest that the
documentation is all over the map? I will be posting this reply in both the
SQL Connectivity and SQL Replication newsgroups. In my opinion Microsoft doe
s
a great job of documenting the scope and detail of it's technologies but
often falls short when it comes to implementation documentation. They are 2
distinct types of technical writing. I love Microsoft products and take the
time to scribe my opinion in hopes that it will yield stronger product line.
With that said, I ask again for a -concise, thorough, list of steps on how
to set up a push transaction based SQL replication subscription between 2
Non-trusted Small Business Servers?
"Mario Michela" wrote:

> I have SQL running on SBS Server A. It is a publisher and a distributor of
a
> database that has 1 subscriber a SQL Server running on SBS Server 2. How d
oes
> one replicate in a untrusted enviroment.
> there was also a free ware dll that allowed sql to invoke the ras dialer..
> does anyone have the valid url to this?

No comments:

Post a Comment