Replication of SQL Server In Clustered Environment

We are running 2 SQL Server and both run in failover clustered Environment.
The Problem is now we need to Replicate a Database from one Virtual SQL Sever to the other.

The Second one (clusterd environment)is stroing their database localy while the First One (clustered environment)is storing database in a shared storage.
Note that Both Server are used for sperate purpose , but we now need to set replication on the Other Clustered Setup for Reporting Purpose.

Will it work if we configure replication from One SQL Server Clustered Setup to the Other Clstered Setup.
If yes, then please let me know how it can be done ?

Thanks

Setup replication on cluster environment is no different than non-cluster environment. Remeber to use SQL Server virtual server name instead of a particular node name, also you need make sure snapshot folder is in the shared storage (doesn't depends on a particular node).

Thanks,

Zhiqiang Feng

Replication Monitor disappears

All,
I have setup transactional replication in our dev environment with
publisher, distributor and subscriber on same box for testing and it was
running fine for some time. When I was setting up replication I had SQL
Service logged on using local system account and sql agent login was dev
admin account.
Yesterday when we have restarted the server, sql service came fine but SQL
Agent did not start. when I tried to start agent it manually it errored
saying login donot have permissions.
When I have checked Agent login, its using same dev admin login which should
have all permissions. Finally I was able to start the SQL Agent service by
retyping dev admin and password from services.
This time though SQL Agent started Replication monitor disappeared from
Enterprise manager. Any suggesstions why it happened..?
This could be a rights issue. Connect to the problem server using the sa
account and see if it shows up.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"SQL Replicatio Guy" <SQL Replicatio Guy@.discussions.microsoft.com> wrote in
message news:F6019804-2776-4532-836D-C51156354A45@.microsoft.com...
> All,
> I have setup transactional replication in our dev environment with
> publisher, distributor and subscriber on same box for testing and it was
> running fine for some time. When I was setting up replication I had SQL
> Service logged on using local system account and sql agent login was dev
> admin account.
> Yesterday when we have restarted the server, sql service came fine but SQL
> Agent did not start. when I tried to start agent it manually it errored
> saying login donot have permissions.
> When I have checked Agent login, its using same dev admin login which
should
> have all permissions. Finally I was able to start the SQL Agent service by
> retyping dev admin and password from services.
> This time though SQL Agent started Replication monitor disappeared from
> Enterprise manager. Any suggesstions why it happened..?
>
>
|||Yes, I am sure its rights issue but not sure why my replication monitor did
not come up after I have started the SQL Agent service with dev admin account.
FYI If it helps-
SQL Agent started only when I have retyped dev admin and password.
Regards
"Hilary Cotter" wrote:

> This could be a rights issue. Connect to the problem server using the sa
> account and see if it shows up.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "SQL Replicatio Guy" <SQL Replicatio Guy@.discussions.microsoft.com> wrote in
> message news:F6019804-2776-4532-836D-C51156354A45@.microsoft.com...
> should
>
>

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-on
with it. Kindly help me.
Thanks,
shyam
Hi 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 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...
>
>

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...
>
>

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-on
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 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
>
>

Replication in cluster environment problem

1) I have the Active/Passive cluster environment (using Microsoft cluster service).
2) SQL2000 is installed on the cluster (Virtual instance).
3) Virtual instance of SQL Server is used as Publisher in Transactional replication with updatable subscribers.
4) Subscribers are passing updates to subscriber using MSMQ
5) The problem is : after I establish replication , the Queue Agent fails with following error (Failed to initiate search for MSMQs)Did you define your MSMQ for your queue agent? My guess is not. That's why you got the error.|||I have defined MSMQ resource at "Cluster Managager".
The settings that i was used were taken from microsoft article.
MSMQ have dependeny the same "Network name" as SQL Server.
So if the question "Did you define your MSMQ for your queue agent"
is about that , the answer is yes.
Probably i have not understood your question.