Tuesday, February 21, 2012

Replication in Local System-HOW?

Hi,
I'm new to Replication and before i start doing it in the LIVE environment,i
need to learn it first and test the same on my Local machine.I'm aware
that,if the Registration is done as "LOCAL",the Repliaction will not
work.But,unfortunately,the registration on my machine is Local.Can some one
suggest as how should i start playing with Replication and have some hands-o
n
with it. Kindly help me.
Thanks,
shyamHi Shyam
I think you're referring to the message that Enterprise Manager pops up when
you try to use the Replication dialogs, right?
If so, all you need to do is unregister the instances in Enterprise Manager
& re-register it using the computer name, rather than "local" or " . ".. It
should work from there.
I use Replication regularly on default instances, whilst logged onto the
local machine this way...
Regards,
Greg Linwood
SQL Server MVP
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:1FADD217-846F-4332-BC5D-4E020BC0DDB2@.microsoft.com...
> Hi,
> I'm new to Replication and before i start doing it in the LIVE
> environment,i
> need to learn it first and test the same on my Local machine.I'm aware
> that,if the Registration is done as "LOCAL",the Repliaction will not
> work.But,unfortunately,the registration on my machine is Local.Can some
> one
> suggest as how should i start playing with Replication and have some
> hands-on
> with it. Kindly help me.
> Thanks,
> shyam|||Hi Greg,
Thanks for the tip.Missed that idea,will give a try on this and get back if
i have any clarifications..
Regards,
Shyam
"Greg Linwood" wrote:

> Hi Shyam
> I think you're referring to the message that Enterprise Manager pops up wh
en
> you try to use the Replication dialogs, right?
> If so, all you need to do is unregister the instances in Enterprise Manage
r
> & re-register it using the computer name, rather than "local" or " . ".. I
t
> should work from there.
> I use Replication regularly on default instances, whilst logged onto the
> local machine this way...
> Regards,
> Greg Linwood
> SQL Server MVP
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:1FADD217-846F-4332-BC5D-4E020BC0DDB2@.microsoft.com...
>
>

No comments:

Post a Comment