I had the same issue today. Everything was running fine for a long time and all of a sudden the job stopped working today. Just deleted and recreated the credential...

Check if this helps. I had come come accross this when I was searching for some other problem.

http://www.sqlreportingservices.net/Ask/5536.aspx

Have you configured the windows firewall for the reporting service and the port 80?

when you say that the config file is not taking values, do you mean when you are running the package in sql agent job?

If you are trying to read the ldf file then its going to be difficult. There is some sql command to do read the ldf file, but the output doenst...

What you seem to be doing seems to be a regular process. In this case I would agree with Shataram about using ssis. You may find it far easier to...

You need to use linked servers. Add the secondary server as linked server in the primary one. Read a little about linked server you will get an idea.

Your query...

Although you have disabled the firewall I still suggest you to do to the following. Windows server 2008 has all these firewall issues

1) turn on the firewall

2) Go to the...

Jeffery I agree with you on the data file part. The data file is going to grow when your process runs again.

Many times I prefer to move the data...

Shrinking data file is useful only if you have delete or truncate operations going on in your database. Most of the time production databases do not delete data. So shrinking...

Yes. It dint cause any performance problem otherwise it would have been detected long time back. My only concern was that the server was not compromised.

Hi,

Around 20 days back one of the dba's in our team installed a monitoring software trial version to test. this is the same time when the commands started appearing in...

Right now I dont have any performance issues. but I still need to knwo the reason this is happening.

Yes the front end applications are .net. You mean to say that someone from application is running it and sending the trace back to the client? If that is the...

if the performance slow then you need to may have to do lot of other things too. Analyse and optimise your query and check if they have they utilise...