Re: Replication Monitor disappears

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:F6019804-2776-4532-836D-C51156354A45@xxxxxxxxxxxxxxxx
> 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..??
>
>
>
>


.

Relevant Pages

  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... issues, such as a server that might have IIS running on the same machine, ... applicable to SQL 2000 environment, ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • RE: MP Install issue
    ... Where in the installation are you talking about specifying the account rather ... > MPDB ERROR - CONNECTION PARAMETERS ... > SQL Server Name: servername ... > with a trusted SQL Server connection. ...
    (microsoft.public.sms.setup)
  • Re: SQL Express Fails with Hardware Error
    ... The LocalSystem account is a built-in account, ... which the SQL Service runs. ... MCSE, CCEA, Microsoft MVP - Terminal Server ... Minimum Hardware Requirement (Warning) ...
    (microsoft.public.sqlserver.setup)
  • Re: Distributed Query - Linked Servers?
    ... In the case of SQL style accounts, it doesn't seem very secure to me, because the password will be transmitted over the network. ... it should also be able to work by setting up a credential and proxy account on Server1. ... In this case it could work with NTLM authentication. ... we just need to verify that the 2 sql server instances are under sql server and windows authentication mode and the sql account you use has the permission on the 2 sql server instances. ...
    (microsoft.public.sqlserver.server)
  • Connection problem in Visual Studio 2008 C# with SQL Server 2008 Express
    ... I did manage to install VS08 with SQL ... Server 2008 Express, as I indicate in this post here: ... to make a new connection for a new programming project (so we're ... under the account of the application pool's identity while a WinForm ...
    (microsoft.public.sqlserver.setup)