I installed Reporting Services onto my SQL 2000 Developer edition on
windows XP.
I can create reports in visual studio .net .
However I do not have a Report Manager in Start->All
Programs->Microsoft SQL Server-> Reporting Services
I am going through the samples so I can use Reporting Services in the
current project I am working on.
This sample requires Reports Manager
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_tutorials_v1_575g.asp
Is there anyway I can do this using Windows XP with Sql 2k Developer?
Also is it right that I shouldn't have the Report Manager icon on XP
or perhaps my installation went wrong ?
Thanks,
yurpsReport Manager is a web site (ASP.Net application). There is no icon or menu
for it. Try going to //localhost in IE. The default when installing is that
Report Manager becomes your default website. Also, if you look at SQL Server
you should see two db. ReportServer and ReportServerTempDB
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"magister" <yurps@.yahoo.co.uk> wrote in message
news:984bebc3.0501031053.2ff7af87@.posting.google.com...
> I installed Reporting Services onto my SQL 2000 Developer edition on
> windows XP.
> I can create reports in visual studio .net .
> However I do not have a Report Manager in Start->All
> Programs->Microsoft SQL Server-> Reporting Services
> I am going through the samples so I can use Reporting Services in the
> current project I am working on.
> This sample requires Reports Manager
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_tutorials_v1_575g.asp
> Is there anyway I can do this using Windows XP with Sql 2k Developer?
> Also is it right that I shouldn't have the Report Manager icon on XP
> or perhaps my installation went wrong ?
> Thanks,
> yurps|||Thanks for the reply.
No I don't have these in //localhost or the 2 db ReportServer &
ReportServerTempDB
Should these be installed on winXP Pro sql 2k developer ?
I will run thru the install again, maybe I need to reboot.
Thanks,
Matt|||Most likely you do not have IIS running. IIS needs to be running prior to
the install in order to install the server components.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"yurps" <yurps@.yahoo.co.uk> wrote in message
news:1104784807.181616.141330@.f14g2000cwb.googlegroups.com...
> Thanks for the reply.
> No I don't have these in //localhost or the 2 db ReportServer &
> ReportServerTempDB
> Should these be installed on winXP Pro sql 2k developer ?
> I will run thru the install again, maybe I need to reboot.
> Thanks,
> Matt
>|||Most definately not, I uninstalled Reporting Services. I checked the
webserver was sending pages, and then reinstalled reporting services.
No go! No Reports or ReportServer folders in Inetsvr/wwwroot or
virtual directories in the IIS management console.
I am installing Reporting Services Evaluation Edition would this be a
factor.
Also I don't have my op system running on the C:\ drive it is on D:\
Also my sql server isn't on local it has a name...
Any ideas. I'm really stumped. or perhaps I need to reinstall
everything. 8(
Bruce L-C [MVP] wrote:
> Most likely you do not have IIS running. IIS needs to be running
prior to
> the install in order to install the server components.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "yurps" <yurps@.yahoo.co.uk> wrote in message
> news:1104784807.181616.141330@.f14g2000cwb.googlegroups.com...
> > Thanks for the reply.
> >
> > No I don't have these in //localhost or the 2 db ReportServer &
> > ReportServerTempDB
> >
> > Should these be installed on winXP Pro sql 2k developer ?
> >
> > I will run thru the install again, maybe I need to reboot.
> > Thanks,
> > Matt
> >|||You are not getting any error messages?
If SQL Server is not running as the default instance that could be causing a
problem. I seem to remember that you have to do something different if this
is the case. My guess is that it would be similar as if you had SQL Server
on a different server. Evaluation edition should be working with developer
edition of SQL Server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"yurps" <yurps@.yahoo.co.uk> wrote in message
news:1104788095.554304.294910@.z14g2000cwz.googlegroups.com...
> Most definately not, I uninstalled Reporting Services. I checked the
> webserver was sending pages, and then reinstalled reporting services.
> No go! No Reports or ReportServer folders in Inetsvr/wwwroot or
> virtual directories in the IIS management console.
> I am installing Reporting Services Evaluation Edition would this be a
> factor.
> Also I don't have my op system running on the C:\ drive it is on D:\
> Also my sql server isn't on local it has a name...
> Any ideas. I'm really stumped. or perhaps I need to reinstall
> everything. 8(
> Bruce L-C [MVP] wrote:
> > Most likely you do not have IIS running. IIS needs to be running
> prior to
> > the install in order to install the server components.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "yurps" <yurps@.yahoo.co.uk> wrote in message
> > news:1104784807.181616.141330@.f14g2000cwb.googlegroups.com...
> > > Thanks for the reply.
> > >
> > > No I don't have these in //localhost or the 2 db ReportServer &
> > > ReportServerTempDB
> > >
> > > Should these be installed on winXP Pro sql 2k developer ?
> > >
> > > I will run thru the install again, maybe I need to reboot.
> > > Thanks,
> > > Matt
> > >
>|||Well I uninstalled SQL, that's the only way to make it run as a default
instance, if you don't set it up that way.
...but unfortunately that didn't do, still no /Reports or
/ReportServer
virtual directories.
Errors ? the only entry in Event Viewer for Application id
8128 :
Using 'xpstar.dll' version '2000.80.760' to execute extended stored
procedure 'sp_MSgetversion'.
Hope this all does waste all the time it was meant to save.
Thanks,
Matt
Bruce L-C [MVP] wrote:
> You are not getting any error messages?
> If SQL Server is not running as the default instance that could be
causing a
> problem. I seem to remember that you have to do something different
if this
> is the case. My guess is that it would be similar as if you had SQL
Server
> on a different server. Evaluation edition should be working with
developer
> edition of SQL Server.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "yurps" <yurps@.yahoo.co.uk> wrote in message
> news:1104788095.554304.294910@.z14g2000cwz.googlegroups.com...
> > Most definately not, I uninstalled Reporting Services. I checked
the
> > webserver was sending pages, and then reinstalled reporting
services.
> > No go! No Reports or ReportServer folders in Inetsvr/wwwroot or
> > virtual directories in the IIS management console.
> >
> > I am installing Reporting Services Evaluation Edition would this be
a
> > factor.
> >
> > Also I don't have my op system running on the C:\ drive it is on
D:\
> >
> > Also my sql server isn't on local it has a name...
> >
> > Any ideas. I'm really stumped. or perhaps I need to reinstall
> > everything. 8(
> >
> > Bruce L-C [MVP] wrote:
> > > Most likely you do not have IIS running. IIS needs to be running
> > prior to
> > > the install in order to install the server components.
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "yurps" <yurps@.yahoo.co.uk> wrote in message
> > > news:1104784807.181616.141330@.f14g2000cwb.googlegroups.com...
> > > > Thanks for the reply.
> > > >
> > > > No I don't have these in //localhost or the 2 db ReportServer &
> > > > ReportServerTempDB
> > > >
> > > > Should these be installed on winXP Pro sql 2k developer ?
> > > >
> > > > I will run thru the install again, maybe I need to reboot.
> > > > Thanks,
> > > > Matt
> > > >
> >|||Hmm, the version seems wrong. What version do you get if you do a select
@.@.version? You need to have sp3a installed on SQL Server and at least the
version mentioned below is not that (but could be the dll has a different
version which is why I asked you to do a select @.@.version).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"yurps" <yurps@.yahoo.co.uk> wrote in message
news:1104798771.519440.231600@.f14g2000cwb.googlegroups.com...
> Well I uninstalled SQL, that's the only way to make it run as a default
> instance, if you don't set it up that way.
> ...but unfortunately that didn't do, still no /Reports or
> /ReportServer
> virtual directories.
> Errors ? the only entry in Event Viewer for Application id
> 8128 :
> Using 'xpstar.dll' version '2000.80.760' to execute extended stored
> procedure 'sp_MSgetversion'.
> Hope this all does waste all the time it was meant to save.
> Thanks,
> Matt
>
> Bruce L-C [MVP] wrote:
> > You are not getting any error messages?
> >
> > If SQL Server is not running as the default instance that could be
> causing a
> > problem. I seem to remember that you have to do something different
> if this
> > is the case. My guess is that it would be similar as if you had SQL
> Server
> > on a different server. Evaluation edition should be working with
> developer
> > edition of SQL Server.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "yurps" <yurps@.yahoo.co.uk> wrote in message
> > news:1104788095.554304.294910@.z14g2000cwz.googlegroups.com...
> > > Most definately not, I uninstalled Reporting Services. I checked
> the
> > > webserver was sending pages, and then reinstalled reporting
> services.
> > > No go! No Reports or ReportServer folders in Inetsvr/wwwroot or
> > > virtual directories in the IIS management console.
> > >
> > > I am installing Reporting Services Evaluation Edition would this be
> a
> > > factor.
> > >
> > > Also I don't have my op system running on the C:\ drive it is on
> D:\
> > >
> > > Also my sql server isn't on local it has a name...
> > >
> > > Any ideas. I'm really stumped. or perhaps I need to reinstall
> > > everything. 8(
> > >
> > > Bruce L-C [MVP] wrote:
> > > > Most likely you do not have IIS running. IIS needs to be running
> > > prior to
> > > > the install in order to install the server components.
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > > "yurps" <yurps@.yahoo.co.uk> wrote in message
> > > > news:1104784807.181616.141330@.f14g2000cwb.googlegroups.com...
> > > > > Thanks for the reply.
> > > > >
> > > > > No I don't have these in //localhost or the 2 db ReportServer &
> > > > > ReportServerTempDB
> > > > >
> > > > > Should these be installed on winXP Pro sql 2k developer ?
> > > > >
> > > > > I will run thru the install again, maybe I need to reboot.
> > > > > Thanks,
> > > > > Matt
> > > > >
> > >
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment