database that has 1 subscriber a SQL Server running on SBS Server 2. How does
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?
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
|||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
>
>
|||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.[vbcol=seagreen]
> 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:
|||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...
> account
> Account?
> Server?
> (private)
> or
> A
> mentioned
> the
> does
> 2
> the
> line.
>
>
sql
No comments:
Post a Comment