I got Distribution Agent failure

I got Distribution Agent failure
however everything working correctly, it's allways red x on distribution
agent.
I have transactional replecation between two virtual computer, i replecate
all tabels from my database, everything work correct however i got red X on
replication monitor, on distributer agene. Also i did'nt find any errors in
history of distributor agent.
When i change some rows on publisher and after this run agent i see the
changes?
Any ideas ?
Message posted via http://www.droptable.com
Please try running sp_MSload_replication_status.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks Paul.
After running this procedure i got : The command(s) completed successfully.
and the return value is 0.
it doesn't print anything else.
Message posted via http://www.droptable.com
|||But does the red circle disappear when you refresh the replication agents?
Rgds,
Paul Ibison
|||O yeeeeeeeeeee. u r great.
However what happen wheb i was run this procedure, please explain.
Thanks. .
Message posted via http://www.droptable.com
|||The replication monitor gets its info from
tempdb.dbo.MSreplication_agent_status and this procedure refreshes this
table. You might notice that a reboot also solves the issue - when you
restart the sql server service the msdb is recreated from the model database
so it has the same effect.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Sorry - meant the tempdb gets recreated, not the msdb...
paul
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:eVqGZyCaFHA.3712@.TK2MSFTNGP09.phx.gbl...
> The replication monitor gets its info from
> tempdb.dbo.MSreplication_agent_status and this procedure refreshes this
> table. You might notice that a reboot also solves the issue - when you
> restart the sql server service the msdb is recreated from the model
> database so it has the same effect.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>

I can't Start\Stop\Pause SQL Server or SQL Agent from Remote SSMS

Hello,
I do all of my SQL Server administration remotely from my workstation and
i noticed that the green running status symbol was blank on one of my MS SQL
2005 servers. I also noticed that when i right click on the server name my
options for start stop and pause are disabled. I can see all of the tables
and run my queries without any issues. If i log onto the server itself i can
see the status symbols and start\stop\pause the services for the Server and
Agent. Does anyone know why i wouldnt be able to remotely do this or see the
status of the server services? Thanks in advance for the help!
jrunowski (jrunowski@.discussions.microsoft.com) writes:
> I do all of my SQL Server administration remotely from my workstation
> and i noticed that the green running status symbol was blank on one of
> my MS SQL 2005 servers. I also noticed that when i right click on the
> server name my options for start stop and pause are disabled. I can see
> all of the tables and run my queries without any issues. If i log onto
> the server itself i can see the status symbols and start\stop\pause the
> services for the Server and Agent. Does anyone know why i wouldnt be
> able to remotely do this or see the status of the server services?
Normally, you can only stop and start services on the local machine. This
is not specific to SQL Server, but applies to Windows in general. I guess
that you can configure a machine so that services can be stopped and
started from a remote computer, but it sonds like a dare security-wise.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx