Cannot delete Maintenance Plan job

Hi
I had a Maintenance Plan with a scheduled job setup in SQL 2005. I have
deleted the Plan without deleting the scheduled job. Now I cannot delete the
job without the Plan. Any help will be great appreciated.
I have deleted the job by setting up another maintenance plan. After the new
maintenance plan ran, the orphaned job was deleted. Sorry, I think I should
have posted this on another newsgroup. Thanks!
"Yuhong" wrote:

> Hi
> I had a Maintenance Plan with a scheduled job setup in SQL 2005. I have
> deleted the Plan without deleting the scheduled job. Now I cannot delete the
> job without the Plan. Any help will be great appreciated.

Cannot create a connection to data source

Why is it that sometimes I get this error and sometimes not after I deploy the same shared data souce to my Report Server?

Even if I try deleting the datasouce through Report Manager the redeploy it from VS 2005, it still errors out when I run my report. I am able to run my report fine in VS.

An error has occurred during report processing.

Cannot create a connection to data source 'mydatasourcenamehere'.

For more information about this error navigate to the report server on the local server machine, or enable remote error

Most likely the data source is configured to use Windows Integrated Security. When deployed to the report server (machine A), accessing the report from (machine B) will run into the double-hop issue when the report tries to access a data source on machine C.

-- Robert

|||

I struggled with this problem for a few hours until I figured out that I had a file system permission problem. The user running the report must have write permissions on the ../Reports directory. Once I made this change in IIS, the report ran with no errors.

I suppose this permission is required because new .aspx pages have to be created to represent the report instance in the web site's file system.

HTH,

tqheel

Cannot create a connection to data source

Why is it that sometimes I get this error and sometimes not after I deploy the same shared data souce to my Report Server?

Even if I try deleting the datasouce through Report Manager the redeploy it from VS 2005, it still errors out when I run my report. I am able to run my report fine in VS.

An error has occurred during report processing.

Cannot create a connection to data source 'mydatasourcenamehere'.

For more information about this error navigate to the report server on the local server machine, or enable remote error

Most likely the data source is configured to use Windows Integrated Security. When deployed to the report server (machine A), accessing the report from (machine B) will run into the double-hop issue when the report tries to access a data source on machine C.

-- Robert

|||

I struggled with this problem for a few hours until I figured out that I had a file system permission problem. The user running the report must have write permissions on the ../Reports directory. Once I made this change in IIS, the report ran with no errors.

I suppose this permission is required because new .aspx pages have to be created to represent the report instance in the web site's file system.

HTH,

tqheel