Hi,

Please find the screenshot attached in that i opened the status of SSRS i got that data which i posted previously.

Opps sorry, i tried from Surface are configuration only.

And also i tried in configuration tools also but the status is not changing when i am enabling.

Can i reinstall the Tools...

i am able to ping that server through ipaddress.

please find the below attached screen shot, when i am trying to enable the tcp\ip in configuration tools.

Version of sql sql server...

I received this error when i am trying to connect sql server remotely.

Here i have attached error screenshot, please go through with my attachment.

Thank you for providing this information.

By using DBCC opentran command you can find the transaction which is running longer time.

You can detach the db from source and attach on the destination server.

Better to take full backup after truncating log file.

Better to do that deletion at off hours, you may minimize that problem. After deleting tables rebuild the indexes.

It dose not depend on which recovery mode, which you have kept.

http://www.developmentnow.com/g/109_2006_5_0_0_758716/change-object-owner-with-a-wildcard.htm

http://www.simple-talk.com/sql/learn-sql-server/how-to-track-down-deadlocks-using-sql-server-2005-profiler/

Try this,

1. Change secondary db article name and check.

2. Drop index on secondary db.

Thank u and advance hpy new year

4m amar

amarnath_sk@yahoo.co.in

ya i hav done that.

can i see that instance in my admin system,if possible how can i ?