I can't access any report from within the .net environment. It appears that
I can't connect to the database, but when I use the connection configuration
tool I get another error... I can create new queries, but I can't view them
from within .net or from my http://localhosts/reports location.
It states "No report servers were found on the specified machines". These
reports worked a few weeks ago, until an update was done via the update tool,
and vooalaa. I tried uninstalling the updates but to no avail.
[quoted text, click to view] "EMartinez" wrote:
> On Feb 27, 4:51 pm, Michael.Proyecto7
> <Michael.Proyec...@discussions.microsoft.com> wrote:
> > This is probably something trivial, but I'm from an Oracle Unix environment
> > and I have no idea how to solve this in windows server 2003 with SQL Server
> > 2005 sp1... it happens whenever I run any report.
> >
> > An unexpected error occurred in Report Processing. (rsInternalError) Get
> > Online Help Specified cast is not valid.
>
> Please post some of the query and/or report expressions. Just from
> looking at the error, it might be that you need to convert a value to
> a consistent datatype.
>
> Enrique Martinez
> Sr. SQL Server Developer
>
On Feb 28, 7:52 am, Michael.Proyecto7
[quoted text, click to view] <MichaelProyec...@discussions.microsoft.com> wrote:
> I can't access any report from within the .net environment. It appears that
> I can't connect to the database, but when I use the connection configuration
> tool I get another error... I can create new queries, but I can't view them
> from within .net or from myhttp://localhosts/reportslocation.
>
> It states "No report servers were found on the specified machines". These
> reports worked a few weeks ago, until an update was done via the update tool,
> and vooalaa. I tried uninstalling the updates but to no avail.
>
> "EMartinez" wrote:
> > On Feb 27, 4:51 pm, Michael.Proyecto7
> > <Michael.Proyec...@discussions.microsoft.com> wrote:
> > > This is probably something trivial, but I'm from an Oracle Unix environment
> > > and I have no idea how to solve this in windows server 2003 with SQL Server
> > > 2005 sp1... it happens whenever I run any report.
>
> > > An unexpected error occurred in Report Processing. (rsInternalError) Get
> > > Online Help Specified cast is not valid.
>
> > Please post some of the query and/or report expressions. Just from
> > looking at the error, it might be that you need to convert a value to
> > a consistent datatype.
>
> > Enrique Martinez
> > Sr. SQL Server Developer
You probably want to check to see if you web server (IIS) has been
turned off. Right click my computer, go to Manage then open Service
and Applications and Internet Information Services. Right click it and
either start it or re-start it. This might be the problem.
Regards,
Enrique Martinez
Sr. SQL Server Developer