Wednesday, March 7, 2012

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

No comments:

Post a Comment