do you have integration services installed on your machine? this just happend to me where I was trying to run an SSIS package without installing integration services.

Use the command Mani given and once done restart sql services.. then delete the old files from the old directory...

Moving tempdb away from the sql binaries drive is always the good thing and must be done in any busy environment.

Also depending on how busy your server is, if your...

If you transfer the logins using the SP_HELP_REVLOGIN stored procedure, you would not get orphaned users as it recreates the logins with the original SID

Link to the sp script:

If you transfer the logins using the SP_HELP_REVLOGIN stored procedure, you would not get orphaned users as it recreates the logins with the original SID

Link to the sp script:

I am not sure about any 3rd party tools but we use the built in RSEXECUTIONLOG db/admin reports for monitoring the executions.

More details at http://technet.microsoft.com/en-us/library/aa964131.aspx

check if the SMTP server and unattended execution accounts are set properly using the reporting services configuration tool.

More details in http://msdn2.microsoft.com/en-us/library/ms159155.aspx

actually the issue was with corrupted installation of IIS and ASP.NET.

What I did to resolve this was Uninstall IIS, ASP.NET from windows then uninstall sql server. reinstall in the same...

Thank you all for the responses. after going through all your responses I am able to setup the reports I wanted to.

Thanks all again

as you said the server has 16gb of ram and if /awe and /pae are enabled in boot.ini then did you check if "lockpagesinmemory" setting granted for the service account...

sorry... i did not pay attention to the "(for instance)"

you are right when you remote desktop into another server and open EM, it...

-its not the browser. you should be opening the enterprise manager (EM) through start>programfiles>ms sqlserver>EM.

- if you have multiple sql servers then you can open the EM on another...

- Do you have sufficient permissions to create  package?

- if you think there is a problem with MMC console throwing an error, can you try registering this server in...

Thanks for the reply Krishna,

Error logs does not have any information

he tried restoring the distribution database but it does not contain any valid info.

I will ask him to check syspublications

What would be your expectation from the person whom you want to hire?