Showing posts with label saying. Show all posts
Showing posts with label saying. Show all posts

Wednesday, March 28, 2012

RSExecutionLog_Update.dtsx error!!

Hi,

When I execute the RSExecutionLog_Update.dtsx, I get an error saying "The task "Set Time period" cannot run on this edition of Integration Services. It requires higher level edition". I am using the Proffesional Edition of SQL2005 and the Integration Services Version is 9.00.1399.00. I have configured the target database RSExecutionLog correctly. Wat could be the problem?

TIA

Is this a script task that is specifically generating this error? You can tell by looking in the execution progress to see which task is creating the error.

I am receiving this error on script tasks and I wanted to see if you have found a work-around or a solution to the error.

|||

As far as I know there is no Professional Editio of SQL 2005. We have Express, Workgroup, Standard and Enterprise.

Donald

|||

Donald:

Thanks for responding.

I am encountering this error when I run a script task, Error: The task "ScriptTask" cannot run on this edition of Integration Services. It requires a higher level edition.

We are running SQL Server Enterprise Edition so SSIS should be included. Do you have any thoughts?

|||

Is it possible that you have installed only the tools, but not selected to install SSIS itself?

Donald

RSExecutionLog_Update.dtsx error!!

Hi,

When I execute the RSExecutionLog_Update.dtsx, I get an error saying "The task "Set Time period" cannot run on this edition of Integration Services. It requires higher level edition". I am using the Proffesional Edition of SQL2005 and the Integration Services Version is 9.00.1399.00. I have configured the target database RSExecutionLog correctly. Wat could be the problem?

TIA

Is this a script task that is specifically generating this error? You can tell by looking in the execution progress to see which task is creating the error.

I am receiving this error on script tasks and I wanted to see if you have found a work-around or a solution to the error.

|||

As far as I know there is no Professional Editio of SQL 2005. We have Express, Workgroup, Standard and Enterprise.

Donald

|||

Donald:

Thanks for responding.

I am encountering this error when I run a script task, Error: The task "ScriptTask" cannot run on this edition of Integration Services. It requires a higher level edition.

We are running SQL Server Enterprise Edition so SSIS should be included. Do you have any thoughts?

|||

Is it possible that you have installed only the tools, but not selected to install SSIS itself?

Donald

sql

Tuesday, March 20, 2012

rs.Render issue

I am trying to run a report from command line using the "rs" utility in
Reporting Services 2005 and I get an error saying that Render is not a member
of 'Microsoft.SqlServer.ReportingServices2005.ReportingService2005'. Anyone
any ideas what I am missing? Thanks for any help.Please help!! I am stuck.
"KMP" wrote:
> I am trying to run a report from command line using the "rs" utility in
> Reporting Services 2005 and I get an error saying that Render is not a member
> of 'Microsoft.SqlServer.ReportingServices2005.ReportingService2005'. Anyone
> any ideas what I am missing? Thanks for any help.|||The version of rs.exe that ships with SQL 2005 is configured to run against
the new 2005 management SOAP endpoint by default. The old 2000 endpoint is
still supported. Just add -e mgmt2000 to the command line to use the old
endpoint. You can get more information on this option by running rs.exe /?
or in the MSDN help files.
"KMP" wrote:
> I am trying to run a report from command line using the "rs" utility in
> Reporting Services 2005 and I get an error saying that Render is not a member
> of 'Microsoft.SqlServer.ReportingServices2005.ReportingService2005'. Anyone
> any ideas what I am missing? Thanks for any help.|||That was it. Thank you so much.
I don't understand the endpoint stuff. Can you point me to the right place
where I can find more about endpoints (very basic stuff I guess)?
"PRA Group" wrote:
> The version of rs.exe that ships with SQL 2005 is configured to run against
> the new 2005 management SOAP endpoint by default. The old 2000 endpoint is
> still supported. Just add -e mgmt2000 to the command line to use the old
> endpoint. You can get more information on this option by running rs.exe /?
> or in the MSDN help files.
>
> "KMP" wrote:
> > I am trying to run a report from command line using the "rs" utility in
> > Reporting Services 2005 and I get an error saying that Render is not a member
> > of 'Microsoft.SqlServer.ReportingServices2005.ReportingService2005'. Anyone
> > any ideas what I am missing? Thanks for any help.

Friday, March 9, 2012

RS Post installation problem

When RS completed installation a message was dispalyed saying that the
installation was successful, but that RS was unable to initialise.
Now whenever I try to access the http://servername/reports site, I get the
following error.
"
Compilation Error
Description: An error occurred during the compilation of a resource required
to service this request. Please review the following specific error details
and modify your source code appropriately.
Compiler Error Message: CS0016: Could not write to output file
'c:\WINNT\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET
Files\reports\dc088531\5500274e\yip07jmq.dll' -- 'Access is denied. '
"
I think both problems are security/permissions related.
The sever is running Win2k3. I actually had it running fine previously, but
cannot replicate the successful installation on other servers or this one
upon reinstallation.
I have tried giving up to administrator rights to the ASPNET account with no
success.
Advice on resolving this issue would be greatly appreciated.I just tried a reinstall to get the warning message at the end of
installation. It reads:
"Setup has installed Microsoft SQL server 2000 Reporting Services
Successfully. Click Finish to exit.
Setup could not initialize the report server. You must manually initialize
the report server before using it for the first time. For more information,
see the Reporting Services setup documentation"
I have yet to find anything in the setup documentation, so help would be
greatly appreciated.
Thanks and regards,
Alex McKellar.
"TriggerFish" <apples@.oranges.com> wrote in message
news:4134102d@.info-mid...
> When RS completed installation a message was dispalyed saying that the
> installation was successful, but that RS was unable to initialise.
> Now whenever I try to access the http://servername/reports site, I get the
> following error.
> "
> Compilation Error
> Description: An error occurred during the compilation of a resource
required
> to service this request. Please review the following specific error
details
> and modify your source code appropriately.
> Compiler Error Message: CS0016: Could not write to output file
> 'c:\WINNT\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET
> Files\reports\dc088531\5500274e\yip07jmq.dll' -- 'Access is denied. '
> "
> I think both problems are security/permissions related.
> The sever is running Win2k3. I actually had it running fine previously,
but
> cannot replicate the successful installation on other servers or this one
> upon reinstallation.
> I have tried giving up to administrator rights to the ASPNET account with
no
> success.
> Advice on resolving this issue would be greatly appreciated.
>|||For future reference and anyone who might read this later, I found the
problem.
The Network Service of the server on which RS in installed needs access to
the %systemroot%\temp directory. It also appeared to me that it needed
access to any "temp" directory environment variables that have been setup on
the server. I had two and once I gave access to both, all worked fine.
FYI for anyone that is interested.
Regards,
Alex.
"TriggerFish" <apples@.oranges.com> wrote in message
news:4134154c$1@.info-mid...
> I just tried a reinstall to get the warning message at the end of
> installation. It reads:
> "Setup has installed Microsoft SQL server 2000 Reporting Services
> Successfully. Click Finish to exit.
> Setup could not initialize the report server. You must manually
initialize
> the report server before using it for the first time. For more
information,
> see the Reporting Services setup documentation"
> I have yet to find anything in the setup documentation, so help would be
> greatly appreciated.
> Thanks and regards,
> Alex McKellar.
>
> "TriggerFish" <apples@.oranges.com> wrote in message
> news:4134102d@.info-mid...
> > When RS completed installation a message was dispalyed saying that the
> > installation was successful, but that RS was unable to initialise.
> >
> > Now whenever I try to access the http://servername/reports site, I get
the
> > following error.
> >
> > "
> > Compilation Error
> > Description: An error occurred during the compilation of a resource
> required
> > to service this request. Please review the following specific error
> details
> > and modify your source code appropriately.
> >
> > Compiler Error Message: CS0016: Could not write to output file
> > 'c:\WINNT\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET
> > Files\reports\dc088531\5500274e\yip07jmq.dll' -- 'Access is denied. '
> > "
> >
> > I think both problems are security/permissions related.
> >
> > The sever is running Win2k3. I actually had it running fine previously,
> but
> > cannot replicate the successful installation on other servers or this
one
> > upon reinstallation.
> >
> > I have tried giving up to administrator rights to the ASPNET account
with
> no
> > success.
> >
> > Advice on resolving this issue would be greatly appreciated.
> >
> >
>