Can I write SSRS 2008 reports to run on SQL 2005 SSRS?

Is it possible to write SSRS 2008 reports to run on an existing SSRS 2005 server?

If yes, what do I need to do to be able to write SSRS 2008 reports on my developer PC that will run on the SQL 2005 Server (which also has SSRS 2005 installed on it)?

I installed Visual Studio 2008 beta on the development PC and it appears that it needs SSRS installed on it too. So I installed SQL 2008 SSRS (SQL Server Reporting Services) and SQL 2008 Workstation Components onto the developer PC. Next I run the SQL 2008 "Reporting Services Configuration" tool. When I click on the "Web Service URL" section it hangs indefinitely and I have to force it closed.

The developer PC is Windows Vista Business.

Any suggestions on making this work, or any other information that you can think of that would allow me to use Visual Studio 2008 and the SQL 2008 "Report Designer Preview" tool to develop SSRS reports that will run on the SQL 2005 SSRS server?

Thanks!

-ErikR

Hi Erik,

SQL Server 2008 Reporting Services questions can be posted to the new Katmai forum.

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1624&SiteID=1

To answer your question, RS 2008 reports do not run on an RS 2005 server. The 2008 designers will not output 2005 RDL, so you won't be able to do this.

Hope that helps,

-Lukasz

|||

For a lack of response I attempted it anyway. (Tried it before the 1 response came in.)

Installed Visual Studio 2008 on the development PC and the SQL 2008 Reporting Services peice on the Development PC.

Attempted to use the Reporting Services Configuration tool to point it to the SQL 2005 SSRS server and it hung, but after numerous attempts it ended up upgrading the SSRS 2005 SQL database so that the 2005 SSRS would no longer work correctly. The SQL 2005 server was all fine, but the actual Reporting Server databse was "upgraded" and wouldn't work with SSRS on the SQL 2005 SSRS server.

To fix it I had to go into the Reporting Services Configuration tool on the 2005 SSRS server and create a new database. After that it worked again. Of course since it was a new database, none of the reports I had on there before were listed in the new database. But I didn't have to "re-install" anything to get SSRS working again...just had to configure it on a "new" database.

Hope that helps someone.

-ErikR

Can I write SSRS 2008 reports to run on SQL 2005 SSRS?

Is it possible to write SSRS 2008 reports to run on an existing SSRS 2005 server?

If yes, what do I need to do to be able to write SSRS 2008 reports on my developer PC that will run on the SQL 2005 Server (which also has SSRS 2005 installed on it)?

I installed Visual Studio 2008 beta on the development PC and it appears that it needs SSRS installed on it too. So I installed SQL 2008 SSRS (SQL Server Reporting Services) and SQL 2008 Workstation Components onto the developer PC. Next I run the SQL 2008 "Reporting Services Configuration" tool. When I click on the "Web Service URL" section it hangs indefinitely and I have to force it closed.

The developer PC is Windows Vista Business.

Any suggestions on making this work, or any other information that you can think of that would allow me to use Visual Studio 2008 and the SQL 2008 "Report Designer Preview" tool to develop SSRS reports that will run on the SQL 2005 SSRS server?

Thanks!

-ErikR

Hi Erik,

SQL Server 2008 Reporting Services questions can be posted to the new Katmai forum.

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1624&SiteID=1

To answer your question, RS 2008 reports do not run on an RS 2005 server. The 2008 designers will not output 2005 RDL, so you won't be able to do this.

Hope that helps,

-Lukasz

|||

For a lack of response I attempted it anyway. (Tried it before the 1 response came in.)

Installed Visual Studio 2008 on the development PC and the SQL 2008 Reporting Services peice on the Development PC.

Attempted to use the Reporting Services Configuration tool to point it to the SQL 2005 SSRS server and it hung, but after numerous attempts it ended up upgrading the SSRS 2005 SQL database so that the 2005 SSRS would no longer work correctly. The SQL 2005 server was all fine, but the actual Reporting Server databse was "upgraded" and wouldn't work with SSRS on the SQL 2005 SSRS server.

To fix it I had to go into the Reporting Services Configuration tool on the 2005 SSRS server and create a new database. After that it worked again. Of course since it was a new database, none of the reports I had on there before were listed in the new database. But I didn't have to "re-install" anything to get SSRS working again...just had to configure it on a "new" database.

Hope that helps someone.

-ErikR

Can I write SSRS 2008 reports to run on SQL 2005 SSRS?

Is it possible to write SSRS 2008 reports to run on an existing SSRS 2005 server?

If yes, what do I need to do to be able to write SSRS 2008 reports on my developer PC that will run on the SQL 2005 Server (which also has SSRS 2005 installed on it)?

I installed Visual Studio 2008 beta on the development PC and it appears that it needs SSRS installed on it too. So I installed SQL 2008 SSRS (SQL Server Reporting Services) and SQL 2008 Workstation Components onto the developer PC. Next I run the SQL 2008 "Reporting Services Configuration" tool. When I click on the "Web Service URL" section it hangs indefinitely and I have to force it closed.

The developer PC is Windows Vista Business.

Any suggestions on making this work, or any other information that you can think of that would allow me to use Visual Studio 2008 and the SQL 2008 "Report Designer Preview" tool to develop SSRS reports that will run on the SQL 2005 SSRS server?

Thanks!

-ErikR

Hi Erik,

SQL Server 2008 Reporting Services questions can be posted to the new Katmai forum.

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1624&SiteID=1

To answer your question, RS 2008 reports do not run on an RS 2005 server. The 2008 designers will not output 2005 RDL, so you won't be able to do this.

Hope that helps,

-Lukasz

|||

For a lack of response I attempted it anyway. (Tried it before the 1 response came in.)

Installed Visual Studio 2008 on the development PC and the SQL 2008 Reporting Services peice on the Development PC.

Attempted to use the Reporting Services Configuration tool to point it to the SQL 2005 SSRS server and it hung, but after numerous attempts it ended up upgrading the SSRS 2005 SQL database so that the 2005 SSRS would no longer work correctly. The SQL 2005 server was all fine, but the actual Reporting Server databse was "upgraded" and wouldn't work with SSRS on the SQL 2005 SSRS server.

To fix it I had to go into the Reporting Services Configuration tool on the 2005 SSRS server and create a new database. After that it worked again. Of course since it was a new database, none of the reports I had on there before were listed in the new database. But I didn't have to "re-install" anything to get SSRS working again...just had to configure it on a "new" database.

Hope that helps someone.

-ErikR

Can I Upload a URL or Shortcut to the SSRS Home Page?

I have a simple WSS 2.0 SharePoint site for my SSRS deployment which I would like to link my users to from the SSRS home page. Is it possible to add a link or shortcut to my SSRS home page without embedding it inside of a document or report?OK, I figured it out -- sort of. Uploading a URL shortcut did not work, I got errors when trying to click on the short-cut. My solution was to create a simple HTML page with a redirect to the SharePoint portal site. That seems to works but displays it in the same window and not a new window. If the user clicks on the link from SharePoint to go back to SSRS then they can get cascading frames, one inside the other. That is a minor problem which can be avoided if they just use their BACK button.

Can I Update a SQL Database...

We have a SSRS report that needs to update a specific table in the SQL db it
is using to let us know when an invoice has been printed, and we'd like to
flag that specific invoice (or set of invoices). Is this possible?
I had thought about creating a stored procedure that gets called that really
doesn't return any required data, but could update the db, or custom code.
What would be the better approach? I've never connected/written to a db via
custom code before so any articles/samples you may know about and can provide
links to would be greatly appreciated.
Michael COn Oct 11, 11:44 am, Michael C <Micha...@.discussions.microsoft.com>
wrote:
> We have a SSRS report that needs to update a specific table in the SQL db it
> is using to let us know when an invoice has been printed, and we'd like to
> flag that specific invoice (or set of invoices). Is this possible?
> I had thought about creating a stored procedure that gets called that really
> doesn't return any required data, but could update the db, or custom code.
> What would be the better approach? I've never connected/written to a db via
> custom code before so any articles/samples you may know about and can provide
> links to would be greatly appreciated.
> Michael C
I have to agree that the idea you mentioned would be the best
alternative for performance and ease of change; however, if you want
to go the custom code route, here's a link that might be helpful.
http://msdn2.microsoft.com/en-us/library/ms155798.aspx
Of course, you would place the custom code in Layout view >> Report
drop-down >> Report Properties... >> Code. As far as I know, it
accepts pretty standard VB.NET code w/a few minor limitations. Hope
this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks E!
As it turns out (I guess I miss understood the request) I need to try and
capture only the ones that are actually sent to the printer! Now I'm back to
square one with no idea how I'm going to do that. Any suggestions of how to
capture a print command in SSRS?
Michael C.
"EMartinez" wrote:
> On Oct 11, 11:44 am, Michael C <Micha...@.discussions.microsoft.com>
> wrote:
> > We have a SSRS report that needs to update a specific table in the SQL db it
> > is using to let us know when an invoice has been printed, and we'd like to
> > flag that specific invoice (or set of invoices). Is this possible?
> >
> > I had thought about creating a stored procedure that gets called that really
> > doesn't return any required data, but could update the db, or custom code.
> > What would be the better approach? I've never connected/written to a db via
> > custom code before so any articles/samples you may know about and can provide
> > links to would be greatly appreciated.
> >
> > Michael C
>
> I have to agree that the idea you mentioned would be the best
> alternative for performance and ease of change; however, if you want
> to go the custom code route, here's a link that might be helpful.
> http://msdn2.microsoft.com/en-us/library/ms155798.aspx
> Of course, you would place the custom code in Layout view >> Report
> drop-down >> Report Properties... >> Code. As far as I know, it
> accepts pretty standard VB.NET code w/a few minor limitations. Hope
> this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Can I run SSRS reports from my VB6 application?

Hello,
I'd like to run some SSRS reports from my VB6 application. Is this
possible? If so, could someone direct me to a good tutorial to do so?
Currently I have an installation of SQL 2000 with Reporting Services, on a
Win2K3 server box.
Thanks!
RickJust use hyperlinks and point to the report server folder and file.
Example link:
http://rsserver/ReportServer?/Folder/ItemListing
rsserver would be your report SQL server name, Folder would be the name of
the folder where your report rdl file is and the ItemListing would be
replaced with the name of your report (without the .rdl).
HTH,
David
"Rico" <me@.you.com> wrote in message news:11kui.69479$Io4.17369@.edtnps89...
> Hello,
> I'd like to run some SSRS reports from my VB6 application. Is this
> possible? If so, could someone direct me to a good tutorial to do so?
> Currently I have an installation of SQL 2000 with Reporting Services, on a
> Win2K3 server box.
> Thanks!
> Rick
>|||Thanks David, but I need to manage subscriptions from my application, so
that's why I wanted to know if there was a dll or something that I could use
in VB6. I know there's a webservice for .net, but don't know of anything
for VB6.
Rick
"David C" <dlchase@.lifetimeinc.com> wrote in message
news:eWMy5yf2HHA.4400@.TK2MSFTNGP06.phx.gbl...
> Just use hyperlinks and point to the report server folder and file.
> Example link:
> http://rsserver/ReportServer?/Folder/ItemListing
> rsserver would be your report SQL server name, Folder would be the name of
> the folder where your report rdl file is and the ItemListing would be
> replaced with the name of your report (without the .rdl).
> HTH,
> David
> "Rico" <me@.you.com> wrote in message
> news:11kui.69479$Io4.17369@.edtnps89...
>> Hello,
>> I'd like to run some SSRS reports from my VB6 application. Is this
>> possible? If so, could someone direct me to a good tutorial to do so?
>> Currently I have an installation of SQL 2000 with Reporting Services, on
>> a Win2K3 server box.
>> Thanks!
>> Rick
>>
>

Can I obtain a reference to a report item?

SSRS 2005
This question is loosely related to the one I posed in "Can report content
be generated dynamically?"
I would like to make sure that the text boxes in the report footer are
always formatted the same way...same font face, font size, same size,
position, etc. But I also want to allow for the fact that these standard
settings may change over time.
I know I could create a custom code assembly and use expressions to set the
attributes of the text boxes. For example, for each textbox I could set the
FontSize property like this:
=Code.OakRptLib.FooterFontSize()
This approach works but it is a little clumsey.
I would prefer to be able to pass a reference to the textbox to a function
in my custom code assembly so that I could set all of the standard settings
using one function call.
For example I would set the text by setting the Value property like this:
=Code.OakRptLib.BuildPageFooterLeft(ref)
Where "ref" would be a reference to the textbox and would be used by
BuildPageFooterLeft() to set all of the other textbox settings (font, textbox
size, position, etc.).
Is there a way to do this? I cannot find a way to pass a reference to a
textbox object to my custom code assembly.
Thanks!
--
Chris, SSSIWhy not write a utility that just updates all your reports and changes the
footers to be whatever standard you define? You could use a web service to
get the reports in the reports collection, then you can export the rdl file
as an XML file (since it IS XML), next have a XML DOM object point to that,
query down to the PageFooter->ReportItems collection. Now loop for all
TextBox items, and you can respecify how you want the standard look and feel
to be for all the textbox attributes.
To see how this is laid out, I highly reccommend XML Notepad 2006 from
Microsoft. You can download it from their web site. Do a search for it. They
just put it out to download awhile back. It has been missing for quite a
number of years as they have made great improvements to it.
=-Chris
"Chris G." <ChrisG@.nospam.nospam> wrote in message
news:4DCEE1FA-0D17-4C0C-BCD5-DD393305F4D1@.microsoft.com...
> SSRS 2005
> This question is loosely related to the one I posed in "Can report content
> be generated dynamically?"
> I would like to make sure that the text boxes in the report footer are
> always formatted the same way...same font face, font size, same size,
> position, etc. But I also want to allow for the fact that these standard
> settings may change over time.
> I know I could create a custom code assembly and use expressions to set
> the
> attributes of the text boxes. For example, for each textbox I could set
> the
> FontSize property like this:
> =Code.OakRptLib.FooterFontSize()
> This approach works but it is a little clumsey.
> I would prefer to be able to pass a reference to the textbox to a function
> in my custom code assembly so that I could set all of the standard
> settings
> using one function call.
> For example I would set the text by setting the Value property like this:
> =Code.OakRptLib.BuildPageFooterLeft(ref)
> Where "ref" would be a reference to the textbox and would be used by
> BuildPageFooterLeft() to set all of the other textbox settings (font,
> textbox
> size, position, etc.).
> Is there a way to do this? I cannot find a way to pass a reference to a
> textbox object to my custom code assembly.
> Thanks!
> --
> Chris, SSSI|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Chris,
>>Why not write a utility that just updates all your reports and changes the
>>footers to be whatever standard you define?
I have thought of doing that as well. The reasons I have not taken that
approach are:
1. More effort at this point than is warranted by the constraints of the
project
2. It is a design time solution and not a run time solution. We will have a
single suite of reports that support multiple clients, and a run time
solution permits more flexibility for each client. Yes we could have copies
of reports for each client and tools to deploy them when updates are made,
but again that is beyond the scope of this project at this time.
Thanks a lot for your ideas and any further advice would be greatly
appreciated!
--
Chris, SSSI
"Chris Conner" wrote:
> Why not write a utility that just updates all your reports and changes the
> footers to be whatever standard you define? You could use a web service to
> get the reports in the reports collection, then you can export the rdl file
> as an XML file (since it IS XML), next have a XML DOM object point to that,
> query down to the PageFooter->ReportItems collection. Now loop for all
> TextBox items, and you can respecify how you want the standard look and feel
> to be for all the textbox attributes.
> To see how this is laid out, I highly reccommend XML Notepad 2006 from
> Microsoft. You can download it from their web site. Do a search for it. They
> just put it out to download awhile back. It has been missing for quite a
> number of years as they have made great improvements to it.
> =-Chris
>
> "Chris G." <ChrisG@.nospam.nospam> wrote in message
> news:4DCEE1FA-0D17-4C0C-BCD5-DD393305F4D1@.microsoft.com...
> > SSRS 2005
> >
> > This question is loosely related to the one I posed in "Can report content
> > be generated dynamically?"
> >
> > I would like to make sure that the text boxes in the report footer are
> > always formatted the same way...same font face, font size, same size,
> > position, etc. But I also want to allow for the fact that these standard
> > settings may change over time.
> >
> > I know I could create a custom code assembly and use expressions to set
> > the
> > attributes of the text boxes. For example, for each textbox I could set
> > the
> > FontSize property like this:
> >
> > =Code.OakRptLib.FooterFontSize()
> >
> > This approach works but it is a little clumsey.
> >
> > I would prefer to be able to pass a reference to the textbox to a function
> > in my custom code assembly so that I could set all of the standard
> > settings
> > using one function call.
> >
> > For example I would set the text by setting the Value property like this:
> > =Code.OakRptLib.BuildPageFooterLeft(ref)
> >
> > Where "ref" would be a reference to the textbox and would be used by
> > BuildPageFooterLeft() to set all of the other textbox settings (font,
> > textbox
> > size, position, etc.).
> >
> > Is there a way to do this? I cannot find a way to pass a reference to a
> > textbox object to my custom code assembly.
> >
> > Thanks!
> >
> > --
> > Chris, SSSI
>
>|||Hi Wei,
Chris Connor's reply was interesting and appreciated, but it did not really
answer my questions...it proposed an alternative approach. Could you please
reread my original post and in particular answer these questions?:
"I would prefer to be able to pass a reference to the textbox to a function
in my custom code assembly so that I could set all of the standard settings
using one function call.
...
Is there a way to do this? I cannot find a way to pass a reference to a
textbox object to my custom code assembly."
Thanks!
-- Chris
--
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Chris,
I have read your original post. And my understanding is that you may try to
deploy a report and the report user could modify the textbox layout via
some parameter. If I am offset, please let me know.
Based on my research, you may not get the reference to change the Height
and Width of a ReportItem. They are readonly.
You may try to use the Reporting Services Web Services to render a
Reporting from the XML DOM object and you could made the XML modification
in your program.
This seems to be the only way you could do.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights

Can I install SSRS2005 onto SQL SERVER 2000?

Please Help me!
Can I install SSRS 2005 on my SQL SERVER 2000 ? If yes then How? and If
no , then Why not? Is it provide the functionality of SSRS 2005,After
installation?
TIA......To my limited knowledge... Reporting services is a component of sql
server, so installing it is equivalent to installing sql server 2005,
and would require a license for sql 2005 as well as your license for
sql 2000.
given this you may as well upgrade your whole setup to sql server 2005.
assuming that you have some reason not to do this. I don't think the
reporting services database can run on a sql 2000 server, but can't be
sure of this.
ajmera.puneet@.gmail.com wrote:
> Please Help me!
> Can I install SSRS 2005 on my SQL SERVER 2000 ? If yes then How? and If
> no , then Why not? Is it provide the functionality of SSRS 2005,After
> installation?
> TIA......|||As far as licensing is concerned. Any box that has RS 2005 installed has to
have a SQL Server 2005 license for that box (remember, the database used for
metadata/object data does not have to reside on the same box as RS 2005). So
that is the important concept, anywhere you install RS 2005 server
components you must have a SQL Server 2005 license.
That being said, you can use SQL Server 2000 as the object/metadata store
for RS 2005 (I have done this, it is fully supported). Some people do this
because databases upgrades tend to be slower/more cautious.
How is easy. Make sure you have IIS running on your box. Get a SQL Server
2005 media, install RS 2005. If on the same machine it is very easy to just
accept defaults. Note that you do need to have dba rights to SQL Server
during the install (it will be installing two databases).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<someone_else_of_course@.hotmail.co.uk> wrote in message
news:1153819129.075502.129720@.i42g2000cwa.googlegroups.com...
> To my limited knowledge... Reporting services is a component of sql
> server, so installing it is equivalent to installing sql server 2005,
> and would require a license for sql 2005 as well as your license for
> sql 2000.
> given this you may as well upgrade your whole setup to sql server 2005.
> assuming that you have some reason not to do this. I don't think the
> reporting services database can run on a sql 2000 server, but can't be
> sure of this.
>
> ajmera.puneet@.gmail.com wrote:
>> Please Help me!
>> Can I install SSRS 2005 on my SQL SERVER 2000 ? If yes then How? and If
>> no , then Why not? Is it provide the functionality of SSRS 2005,After
>> installation?
>> TIA......
>|||Bruce L-C [MVP] wrote:
> As far as licensing is concerned. Any box that has RS 2005 installed has to
> have a SQL Server 2005 license for that box (remember, the database used for
> metadata/object data does not have to reside on the same box as RS 2005). So
> that is the important concept, anywhere you install RS 2005 server
> components you must have a SQL Server 2005 license.
> That being said, you can use SQL Server 2000 as the object/metadata store
> for RS 2005 (I have done this, it is fully supported). Some people do this
> because databases upgrades tend to be slower/more cautious.
> How is easy. Make sure you have IIS running on your box. Get a SQL Server
> 2005 media, install RS 2005. If on the same machine it is very easy to just
> accept defaults. Note that you do need to have dba rights to SQL Server
> during the install (it will be installing two databases).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <someone_else_of_course@.hotmail.co.uk> wrote in message
> news:1153819129.075502.129720@.i42g2000cwa.googlegroups.com...
> > To my limited knowledge... Reporting services is a component of sql
> > server, so installing it is equivalent to installing sql server 2005,
> > and would require a license for sql 2005 as well as your license for
> > sql 2000.
> >
> > given this you may as well upgrade your whole setup to sql server 2005.
> >
> > assuming that you have some reason not to do this. I don't think the
> > reporting services database can run on a sql 2000 server, but can't be
> > sure of this.
> >
> >
> > ajmera.puneet@.gmail.com wrote:
> >> Please Help me!
> >> Can I install SSRS 2005 on my SQL SERVER 2000 ? If yes then How? and If
> >> no , then Why not? Is it provide the functionality of SSRS 2005,After
> >> installation?
> >> TIA......
> >
Thanks,
One more question that , Is there any need of data migration from 2000
to 2005?
or I can use DB on sql server 2000 as it is with RS2005?
Plz, Help me .If yes then how? No , then Why?|||I'm not sure what to tell you more. RS 2005 can use SQL Server 2000
databases as its data store. If you are licensed then you are good to go.
Just install RS 2005 (the box needs IIS installed already) and do not
install SQL Server 2005 DB. Just do Reporting Services.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<ajmera.puneet@.gmail.com> wrote in message
news:1153977631.436292.317750@.i42g2000cwa.googlegroups.com...
> Bruce L-C [MVP] wrote:
>> As far as licensing is concerned. Any box that has RS 2005 installed has
>> to
>> have a SQL Server 2005 license for that box (remember, the database used
>> for
>> metadata/object data does not have to reside on the same box as RS 2005).
>> So
>> that is the important concept, anywhere you install RS 2005 server
>> components you must have a SQL Server 2005 license.
>> That being said, you can use SQL Server 2000 as the object/metadata store
>> for RS 2005 (I have done this, it is fully supported). Some people do
>> this
>> because databases upgrades tend to be slower/more cautious.
>> How is easy. Make sure you have IIS running on your box. Get a SQL Server
>> 2005 media, install RS 2005. If on the same machine it is very easy to
>> just
>> accept defaults. Note that you do need to have dba rights to SQL Server
>> during the install (it will be installing two databases).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <someone_else_of_course@.hotmail.co.uk> wrote in message
>> news:1153819129.075502.129720@.i42g2000cwa.googlegroups.com...
>> > To my limited knowledge... Reporting services is a component of sql
>> > server, so installing it is equivalent to installing sql server 2005,
>> > and would require a license for sql 2005 as well as your license for
>> > sql 2000.
>> >
>> > given this you may as well upgrade your whole setup to sql server 2005.
>> >
>> > assuming that you have some reason not to do this. I don't think the
>> > reporting services database can run on a sql 2000 server, but can't be
>> > sure of this.
>> >
>> >
>> > ajmera.puneet@.gmail.com wrote:
>> >> Please Help me!
>> >> Can I install SSRS 2005 on my SQL SERVER 2000 ? If yes then How? and
>> >> If
>> >> no , then Why not? Is it provide the functionality of SSRS 2005,After
>> >> installation?
>> >> TIA......
>> >
>
> Thanks,
> One more question that , Is there any need of data migration from 2000
> to 2005?
> or I can use DB on sql server 2000 as it is with RS2005?
> Plz, Help me .If yes then how? No , then Why?
>|||There is a useful aticle on this subject at:
https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
So, assuming that it is possible to use SSRS 2005 with SQL Server 2000,
my question is, does the SQL Server 2000 installation have to be on the
same box?
What I'd ideally like to do is put SSRS 2005 on our web server box and
use our SQL 2000 box to store the SSRS metadata AND the application
data that SSRS will be reporting on.
Any replies gratefully received!
Bruce L-C [MVP] wrote:
> I'm not sure what to tell you more. RS 2005 can use SQL Server 2000
> databases as its data store. If you are licensed then you are good to go.
> Just install RS 2005 (the box needs IIS installed already) and do not
> install SQL Server 2005 DB. Just do Reporting Services.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <ajmera.puneet@.gmail.com> wrote in message
> news:1153977631.436292.317750@.i42g2000cwa.googlegroups.com...
> >
> > Bruce L-C [MVP] wrote:
> >> As far as licensing is concerned. Any box that has RS 2005 installed has
> >> to
> >> have a SQL Server 2005 license for that box (remember, the database used
> >> for
> >> metadata/object data does not have to reside on the same box as RS 2005).
> >> So
> >> that is the important concept, anywhere you install RS 2005 server
> >> components you must have a SQL Server 2005 license.
> >>
> >> That being said, you can use SQL Server 2000 as the object/metadata store
> >> for RS 2005 (I have done this, it is fully supported). Some people do
> >> this
> >> because databases upgrades tend to be slower/more cautious.
> >>
> >> How is easy. Make sure you have IIS running on your box. Get a SQL Server
> >> 2005 media, install RS 2005. If on the same machine it is very easy to
> >> just
> >> accept defaults. Note that you do need to have dba rights to SQL Server
> >> during the install (it will be installing two databases).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> <someone_else_of_course@.hotmail.co.uk> wrote in message
> >> news:1153819129.075502.129720@.i42g2000cwa.googlegroups.com...
> >> > To my limited knowledge... Reporting services is a component of sql
> >> > server, so installing it is equivalent to installing sql server 2005,
> >> > and would require a license for sql 2005 as well as your license for
> >> > sql 2000.
> >> >
> >> > given this you may as well upgrade your whole setup to sql server 2005.
> >> >
> >> > assuming that you have some reason not to do this. I don't think the
> >> > reporting services database can run on a sql 2000 server, but can't be
> >> > sure of this.
> >> >
> >> >
> >> > ajmera.puneet@.gmail.com wrote:
> >> >> Please Help me!
> >> >> Can I install SSRS 2005 on my SQL SERVER 2000 ? If yes then How? and
> >> >> If
> >> >> no , then Why not? Is it provide the functionality of SSRS 2005,After
> >> >> installation?
> >> >> TIA......
> >> >
> >
> >
> > Thanks,
> > One more question that , Is there any need of data migration from 2000
> > to 2005?
> > or I can use DB on sql server 2000 as it is with RS2005?
> > Plz, Help me .If yes then how? No , then Why?
> >|||I've answered you several times. Heck, reading my previous answers I could
come up with the answer to this post.
It is fully supported. Now I say that and you want to know how it is
different. It is not different. Buy a licnese and install RS 2005 exactly as
you would using a SQL Server 2005 database but instead you give it a SQL
Server 2000 server. That is it. NO difference. You have to have a SQL Server
2005 license for the box running RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jonny" <rob.sykes@.virgin.net> wrote in message
news:1156510085.177774.19660@.m73g2000cwd.googlegroups.com...
> There is a useful aticle on this subject at:
> https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
> So, assuming that it is possible to use SSRS 2005 with SQL Server 2000,
> my question is, does the SQL Server 2000 installation have to be on the
> same box?
> What I'd ideally like to do is put SSRS 2005 on our web server box and
> use our SQL 2000 box to store the SSRS metadata AND the application
> data that SSRS will be reporting on.
> Any replies gratefully received!
>
> Bruce L-C [MVP] wrote:
>> I'm not sure what to tell you more. RS 2005 can use SQL Server 2000
>> databases as its data store. If you are licensed then you are good to go.
>> Just install RS 2005 (the box needs IIS installed already) and do not
>> install SQL Server 2005 DB. Just do Reporting Services.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <ajmera.puneet@.gmail.com> wrote in message
>> news:1153977631.436292.317750@.i42g2000cwa.googlegroups.com...
>> >
>> > Bruce L-C [MVP] wrote:
>> >> As far as licensing is concerned. Any box that has RS 2005 installed
>> >> has
>> >> to
>> >> have a SQL Server 2005 license for that box (remember, the database
>> >> used
>> >> for
>> >> metadata/object data does not have to reside on the same box as RS
>> >> 2005).
>> >> So
>> >> that is the important concept, anywhere you install RS 2005 server
>> >> components you must have a SQL Server 2005 license.
>> >>
>> >> That being said, you can use SQL Server 2000 as the object/metadata
>> >> store
>> >> for RS 2005 (I have done this, it is fully supported). Some people do
>> >> this
>> >> because databases upgrades tend to be slower/more cautious.
>> >>
>> >> How is easy. Make sure you have IIS running on your box. Get a SQL
>> >> Server
>> >> 2005 media, install RS 2005. If on the same machine it is very easy to
>> >> just
>> >> accept defaults. Note that you do need to have dba rights to SQL
>> >> Server
>> >> during the install (it will be installing two databases).
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> <someone_else_of_course@.hotmail.co.uk> wrote in message
>> >> news:1153819129.075502.129720@.i42g2000cwa.googlegroups.com...
>> >> > To my limited knowledge... Reporting services is a component of sql
>> >> > server, so installing it is equivalent to installing sql server
>> >> > 2005,
>> >> > and would require a license for sql 2005 as well as your license for
>> >> > sql 2000.
>> >> >
>> >> > given this you may as well upgrade your whole setup to sql server
>> >> > 2005.
>> >> >
>> >> > assuming that you have some reason not to do this. I don't think the
>> >> > reporting services database can run on a sql 2000 server, but can't
>> >> > be
>> >> > sure of this.
>> >> >
>> >> >
>> >> > ajmera.puneet@.gmail.com wrote:
>> >> >> Please Help me!
>> >> >> Can I install SSRS 2005 on my SQL SERVER 2000 ? If yes then How?
>> >> >> and
>> >> >> If
>> >> >> no , then Why not? Is it provide the functionality of SSRS
>> >> >> 2005,After
>> >> >> installation?
>> >> >> TIA......
>> >> >
>> >
>> >
>> > Thanks,
>> > One more question that , Is there any need of data migration from 2000
>> > to 2005?
>> > or I can use DB on sql server 2000 as it is with RS2005?
>> > Plz, Help me .If yes then how? No , then Why?
>> >
>|||Bruce, thanks for your reply. I did figure out that SSRS 2005 is
compatible with SQL 2000 and that license-wise we would still need to
purchase the full SQL 2005 license.
The main thrust of my question was whether SQL Server has to reside on
the same box as SSRS or can SSRS point to a database on a different box
for its metadata?
Bruce L-C [MVP] wrote:
> I've answered you several times. Heck, reading my previous answers I could
> come up with the answer to this post.
> It is fully supported. Now I say that and you want to know how it is
> different. It is not different. Buy a licnese and install RS 2005 exactly as
> you would using a SQL Server 2005 database but instead you give it a SQL
> Server 2000 server. That is it. NO difference. You have to have a SQL Server
> 2005 license for the box running RS 2005.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "jonny" <rob.sykes@.virgin.net> wrote in message
> news:1156510085.177774.19660@.m73g2000cwd.googlegroups.com...
> > There is a useful aticle on this subject at:
> >
> > https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
> >
> > So, assuming that it is possible to use SSRS 2005 with SQL Server 2000,
> > my question is, does the SQL Server 2000 installation have to be on the
> > same box?
> >
> > What I'd ideally like to do is put SSRS 2005 on our web server box and
> > use our SQL 2000 box to store the SSRS metadata AND the application
> > data that SSRS will be reporting on.
> >
> > Any replies gratefully received!
> >
> >
> > Bruce L-C [MVP] wrote:
> >
> >> I'm not sure what to tell you more. RS 2005 can use SQL Server 2000
> >> databases as its data store. If you are licensed then you are good to go.
> >> Just install RS 2005 (the box needs IIS installed already) and do not
> >> install SQL Server 2005 DB. Just do Reporting Services.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> <ajmera.puneet@.gmail.com> wrote in message
> >> news:1153977631.436292.317750@.i42g2000cwa.googlegroups.com...
> >> >
> >> > Bruce L-C [MVP] wrote:
> >> >> As far as licensing is concerned. Any box that has RS 2005 installed
> >> >> has
> >> >> to
> >> >> have a SQL Server 2005 license for that box (remember, the database
> >> >> used
> >> >> for
> >> >> metadata/object data does not have to reside on the same box as RS
> >> >> 2005).
> >> >> So
> >> >> that is the important concept, anywhere you install RS 2005 server
> >> >> components you must have a SQL Server 2005 license.
> >> >>
> >> >> That being said, you can use SQL Server 2000 as the object/metadata
> >> >> store
> >> >> for RS 2005 (I have done this, it is fully supported). Some people do
> >> >> this
> >> >> because databases upgrades tend to be slower/more cautious.
> >> >>
> >> >> How is easy. Make sure you have IIS running on your box. Get a SQL
> >> >> Server
> >> >> 2005 media, install RS 2005. If on the same machine it is very easy to
> >> >> just
> >> >> accept defaults. Note that you do need to have dba rights to SQL
> >> >> Server
> >> >> during the install (it will be installing two databases).
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> <someone_else_of_course@.hotmail.co.uk> wrote in message
> >> >> news:1153819129.075502.129720@.i42g2000cwa.googlegroups.com...
> >> >> > To my limited knowledge... Reporting services is a component of sql
> >> >> > server, so installing it is equivalent to installing sql server
> >> >> > 2005,
> >> >> > and would require a license for sql 2005 as well as your license for
> >> >> > sql 2000.
> >> >> >
> >> >> > given this you may as well upgrade your whole setup to sql server
> >> >> > 2005.
> >> >> >
> >> >> > assuming that you have some reason not to do this. I don't think the
> >> >> > reporting services database can run on a sql 2000 server, but can't
> >> >> > be
> >> >> > sure of this.
> >> >> >
> >> >> >
> >> >> > ajmera.puneet@.gmail.com wrote:
> >> >> >> Please Help me!
> >> >> >> Can I install SSRS 2005 on my SQL SERVER 2000 ? If yes then How?
> >> >> >> and
> >> >> >> If
> >> >> >> no , then Why not? Is it provide the functionality of SSRS
> >> >> >> 2005,After
> >> >> >> installation?
> >> >> >> TIA......
> >> >> >
> >> >
> >> >
> >> > Thanks,
> >> > One more question that , Is there any need of data migration from 2000
> >> > to 2005?
> >> > or I can use DB on sql server 2000 as it is with RS2005?
> >> > Plz, Help me .If yes then how? No , then Why?
> >> >
> >|||RS can have it on the same box or on a different box. I haven't installed it
that way but lots of people have. You can also have web farm configuration,
several RS all using the same database. That requires enterprise version.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jonny" <rob.sykes@.virgin.net> wrote in message
news:1156513351.443872.70820@.p79g2000cwp.googlegroups.com...
> Bruce, thanks for your reply. I did figure out that SSRS 2005 is
> compatible with SQL 2000 and that license-wise we would still need to
> purchase the full SQL 2005 license.
> The main thrust of my question was whether SQL Server has to reside on
> the same box as SSRS or can SSRS point to a database on a different box
> for its metadata?
>
> Bruce L-C [MVP] wrote:
>> I've answered you several times. Heck, reading my previous answers I
>> could
>> come up with the answer to this post.
>> It is fully supported. Now I say that and you want to know how it is
>> different. It is not different. Buy a licnese and install RS 2005 exactly
>> as
>> you would using a SQL Server 2005 database but instead you give it a SQL
>> Server 2000 server. That is it. NO difference. You have to have a SQL
>> Server
>> 2005 license for the box running RS 2005.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "jonny" <rob.sykes@.virgin.net> wrote in message
>> news:1156510085.177774.19660@.m73g2000cwd.googlegroups.com...
>> > There is a useful aticle on this subject at:
>> >
>> > https://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
>> >
>> > So, assuming that it is possible to use SSRS 2005 with SQL Server 2000,
>> > my question is, does the SQL Server 2000 installation have to be on the
>> > same box?
>> >
>> > What I'd ideally like to do is put SSRS 2005 on our web server box and
>> > use our SQL 2000 box to store the SSRS metadata AND the application
>> > data that SSRS will be reporting on.
>> >
>> > Any replies gratefully received!
>> >
>> >
>> > Bruce L-C [MVP] wrote:
>> >
>> >> I'm not sure what to tell you more. RS 2005 can use SQL Server 2000
>> >> databases as its data store. If you are licensed then you are good to
>> >> go.
>> >> Just install RS 2005 (the box needs IIS installed already) and do not
>> >> install SQL Server 2005 DB. Just do Reporting Services.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> <ajmera.puneet@.gmail.com> wrote in message
>> >> news:1153977631.436292.317750@.i42g2000cwa.googlegroups.com...
>> >> >
>> >> > Bruce L-C [MVP] wrote:
>> >> >> As far as licensing is concerned. Any box that has RS 2005
>> >> >> installed
>> >> >> has
>> >> >> to
>> >> >> have a SQL Server 2005 license for that box (remember, the database
>> >> >> used
>> >> >> for
>> >> >> metadata/object data does not have to reside on the same box as RS
>> >> >> 2005).
>> >> >> So
>> >> >> that is the important concept, anywhere you install RS 2005 server
>> >> >> components you must have a SQL Server 2005 license.
>> >> >>
>> >> >> That being said, you can use SQL Server 2000 as the object/metadata
>> >> >> store
>> >> >> for RS 2005 (I have done this, it is fully supported). Some people
>> >> >> do
>> >> >> this
>> >> >> because databases upgrades tend to be slower/more cautious.
>> >> >>
>> >> >> How is easy. Make sure you have IIS running on your box. Get a SQL
>> >> >> Server
>> >> >> 2005 media, install RS 2005. If on the same machine it is very easy
>> >> >> to
>> >> >> just
>> >> >> accept defaults. Note that you do need to have dba rights to SQL
>> >> >> Server
>> >> >> during the install (it will be installing two databases).
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> <someone_else_of_course@.hotmail.co.uk> wrote in message
>> >> >> news:1153819129.075502.129720@.i42g2000cwa.googlegroups.com...
>> >> >> > To my limited knowledge... Reporting services is a component of
>> >> >> > sql
>> >> >> > server, so installing it is equivalent to installing sql server
>> >> >> > 2005,
>> >> >> > and would require a license for sql 2005 as well as your license
>> >> >> > for
>> >> >> > sql 2000.
>> >> >> >
>> >> >> > given this you may as well upgrade your whole setup to sql server
>> >> >> > 2005.
>> >> >> >
>> >> >> > assuming that you have some reason not to do this. I don't think
>> >> >> > the
>> >> >> > reporting services database can run on a sql 2000 server, but
>> >> >> > can't
>> >> >> > be
>> >> >> > sure of this.
>> >> >> >
>> >> >> >
>> >> >> > ajmera.puneet@.gmail.com wrote:
>> >> >> >> Please Help me!
>> >> >> >> Can I install SSRS 2005 on my SQL SERVER 2000 ? If yes then How?
>> >> >> >> and
>> >> >> >> If
>> >> >> >> no , then Why not? Is it provide the functionality of SSRS
>> >> >> >> 2005,After
>> >> >> >> installation?
>> >> >> >> TIA......
>> >> >> >
>> >> >
>> >> >
>> >> > Thanks,
>> >> > One more question that , Is there any need of data migration from
>> >> > 2000
>> >> > to 2005?
>> >> > or I can use DB on sql server 2000 as it is with RS2005?
>> >> > Plz, Help me .If yes then how? No , then Why?
>> >> >
>> >
>