Re: Replication between 2 SBS (small business server) Trusts
From: Mario Michela (MarioMichela_at_discussions.microsoft.com)
Date: 09/01/04
- Next message: Vivek Sharma: "Re: Change Unique ID to non unique ID in replicated table"
- Previous message: Bjarne Steen Hansen: "64-bit to 32-bit SQL Server replication"
- In reply to: Paul Ibison: "Re: Replication between 2 SBS (small business server) Trusts"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 1 Sep 2004 14:15:04 -0700
Yes the article is good in many respects, i learned a lot, perhaps a bit too
much in that it introduced several differernt approches. ok, now you mention
alaising using the client utility? there are only 3 boxes, can you give me an
example of what to put in them. remember this is a push from the publisher.
so wouldn't the publisher connect to the client server? MS is mixing
mediphores. Am i wrong to assume that data flows from a server (publisher)
using a distributer to a client (subscriber). This can't be that difficult.
currently i have created a domain user (admin rights) on both servers, both
have the same username and password. I"ve also gone into routing/ip
routing/nat/basic firewall and in the public ip address added the following:
Desc of Svc: SQLServer
On public Interface
Using TCP
Incoming Port: 1433
Priv IP:192.168.10.2
OutGoing port: 1433
--------------------------
Desc of Svc: SQLServer UDP
On public Interface
Using UDP
Incoming Port: 1434
Priv IP:192.168.10.2
OutGoing port: 1434
I've been trying to test my creating a UDL. (both servers have an Admin
account, both have the same password -so windows authenticed).
now because the documentation can't seem to use consistant mediphoores. i've
done every on both server in a despirate attempt to shotgun my way into
success (not the best way to go about things but look at what i've got to
work with.)
ok now on to ailases. (again i will build identicle alaises on both machines
untill advised otherwise).
Server Alais: aawwserver (machine/server name)
Server Name: aawwserver
Dynamically Determine port.
is there a wizard or some sort of tool i should be using for this?
i can't believe that this entire process up till this point is covered in a
single paragraph.
At one point I had the whole set up using a vpn (not practicle) but the
transaction agent failed because it couldn't drop a function because it was
being used by replication(funny i never dropped it? why should the
replication agent) so i removed replication and attempted to start from
scratch. I've been at this for aprox 40 hours non-stop not including the 4
days prior. if this is what is concidered a reasonable implimemtation I have
to question the product. So for the sake of my sanity Please Please, provide
an example. using the following 'aliases' (sorry i couldn't resist)
-Example Name-
Publisher:
Machine Name: srvPub
Public IP: 0.0.0.1
Private IP: 0.0.0.2
database: DBPub
Domain: DomPub.com
sql Agent Acct: agtRep
sql Agent Password: agt@Rep
------------------------------------
Subscriber:
Machine Name: srvSub
Public IP: 0.0.0.3
Private IP: 0.0.0.4
database: DBSub
Domain: DomSub.com
sql Agent Acct: agtRep
sql Agent Password: agt@Rep
The Challange:
Can anyone take the variables I've listed and form them into a coherent set
of instructions.
This has been more stressfull then having to sing the national anthem naked
at the olympics..
Thanks you so very much, for your assistance. .
"Paul Ibison" wrote:
> Mario,
> much of this article applies to your situation, although admittedly it's not
> immediately obvious :)
> Remember to set up the alias using the client network utility, rather than
> the IP address.
> Try using sql server authentication rather than pass-through.
> Set up FTP forthe initial snapshot if it isn't a nosync one.
> If you want things a little easier, you can use a VPN.
> HTH,
> Paul Ibison
>
>
> "Mario Michela" <MarioMichela@discussions.microsoft.com> wrote in message
> news:75DB0BE3-9379-4C57-BC35-3E62104060E7@microsoft.com...
> > ooops i spoke too soon..
> >
> > 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 was 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
> does
> > 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?
> >
> >
> >
> >
> >
> > "Paul Ibison" wrote:
> >
> > > Mario,
> > > have a look at this article: http://support.microsoft.com/?id=321822
> > > (HOW TO: Replicate Between Computers Running SQL Server in Non-Trusted
> > > Domains or Across the Internet).
> > > HTH,
> > > Paul Ibison
> > >
> > >
> > >
>
>
>
- Next message: Vivek Sharma: "Re: Change Unique ID to non unique ID in replicated table"
- Previous message: Bjarne Steen Hansen: "64-bit to 32-bit SQL Server replication"
- In reply to: Paul Ibison: "Re: Replication between 2 SBS (small business server) Trusts"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
