I use p2p replication for my reporting server, this also enable me to have a failover server in the event of disaster on my prod server.

Works well but have the...

Hi

Have you enabled dbmail within Surface Area config?

Also how have you defined your smtp server, I have had in the past where "in some instances" you need to fully...

Hey

check out the post below.

http://support.softartisans.com/kbview_825.aspx

Have you looked at the post below?

http://www.mombu.com/microsoft/sql-server-replication/t-sql2005-snapshot-agent-wont-start-477016.html

Report Builder is a Click once application and its possible that it is using your IIS settings (check your proxy settings)

Also, check IIS Admin to see if you have anonymous...

What is the exact error? Access denied??

JL

Hey

Did you follow the MS article?

http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

You will need change the startup parameters, if you didnt do this then you will need to edit the registry "HRLM\Software\Microsoft\MSSQLServer\MSSQLServer\Parameters"

JL

CHECKDB uses its own internal snapshot when the operation is in process.

From BOL

Internal Database Snapshot

DBCC CHECKDB uses an internal database snapshot for the transactional consistency needed to perform these checks....

See a few articles out there saying its an issue with SP2 and to work around it until a CU is available you need to use the cleanup SPs from...

Hi

Thanks for the reply. There are no denies, just grants at the moment.

Im just trying to tidy up an existing SSRS system that a prev DBa left (all single...

You can use the cmdshell to then run osql that allows you to execute another .sql file

See Dave's blog

[/url]

and

osql /U sa /P password /d pubs /S SERVERNAME /Q "sp_of_choice"...

Have you installed SP3 and the latest CU?

There are some mem leak fixes included.

Have you tried setting one up and using the "Script Configuration" option within the Log Shipping GUI?

I have attached a "mock" one.

On the server and client try

START | RUN

regsvr32 msxml6.dll

then

regsvr32 msxml4.dll

then

regsvr32 msxml.dll

Have you tried creating a domain account (if using a domain). This account will need AD permission to browse the AD users/groups.

To change the account details use the "Reporting Service...