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 not start (initialise) report server status from reporting services configuration ma

I have reporting services installed on my machine and just a couple of days back every thing was working correctly until some thing i have no idea of happened and screwed up every thing. No i can not access report manager and report sever. When i open reporting services configuration manager, the server status is not initialised and results in following error in the computers event log.

Service cannot be started. System.IO.FileLoadException: Could not load file or assembly 'ReportingServicesNativeServer, Version=0.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1)

File name: 'ReportingServicesNativeServer, Version=0.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' --> System.Runtime.InteropServices.COMException (0x800736B1): This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1)

at Microsoft.ReportingServices.Library.ServiceAppDomainController..ctor()

at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)

at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.

Accessing report manager from the browser also throws this exception.

Server Error in '/ReportServer$SQLExpress' Application.

---

Configuration Error

Description:An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message:An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer' because access is denied.

Source Error:

[No relevant source lines]

Source File:c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\web.config Line:0

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

I'm having the same problem and I was just wondering if you managed to get your report server working

|||

Okay so I got it working.

I got this solution fromAaron Stebner's blog.

Create a batch file with the following commands:

cd %SYSTEMROOT%\WinSXS
for /D %%i in (*vc80*) do rd %%i /s /q
del manifests\*vc80* /q
cd policies
for /D %%i in (*vc80*) do del %%i\* /q

Run the batch file

Then run a repair install of SQL reporting services.

And it should come back.

|||

On my side, i got it working by just un-installing and then re-installing reporting services.