Showing posts with label sql2000. Show all posts
Showing posts with label sql2000. Show all posts

Wednesday, March 7, 2012

Reportingsvcs 2005 and SQL 2000?

Will reporting services 2005 work with SQL2000
regards
CraigYes it does work with SQL 2000.
"NewsGr" wrote:
> Will reporting services 2005 work with SQL2000
> regards
> Craig
>
>|||Yes. When you upgrade just pick Reporting Services and it will leave SQL
Server alone. Note you still need the 2005 license. This is what I did.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"NewsGr" <Ciava@.nospam.net> wrote in message
news:eomPly76FHA.3276@.TK2MSFTNGP10.phx.gbl...
> Will reporting services 2005 work with SQL2000
> regards
> Craig
>
>|||In addition, you can use the RS Configuration utility (in the SQL Server
program group) to change the database at later time.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uN$KnL86FHA.1484@.tk2msftngp13.phx.gbl...
> Yes. When you upgrade just pick Reporting Services and it will leave SQL
> Server alone. Note you still need the 2005 license. This is what I did.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "NewsGr" <Ciava@.nospam.net> wrote in message
> news:eomPly76FHA.3276@.TK2MSFTNGP10.phx.gbl...
>> Will reporting services 2005 work with SQL2000
>> regards
>> Craig
>>
>

ReportingServices2000 and RS2005 client report desgin tools?

We have a project that is going to report from a sql2000 server utilizing
Reporting Services(RS). So the natural thing to use is RS2000, (i assume
based on licensing). I am confused concerning client report development
tools for each version.
For RS2000 -
1) The designer requires some version of 2003.net (vb,vs,etc..)?
2) One cannot use RS2005 tools?
For RS2005
1) Does this require VS2005?
2) Is there a tool built into the Sql Studio Management suite that can be
used instead of VS2005?
3) What about using 2003.net, is this an option?
TIA
CDRS 2000. True
RS 2005: It comes with a version of VS 2005 for the designer so no
additional purchase/install necessary. If you have VS 2005 installed it will
install in that but otherwise it installs a version just for the designer.
And, no, vs 2003 will not work.
RS 2000 is 1.1 framework and RS 2005 is 2.0 framework which is a big reason
for the VS version dependency.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"CD" <mcdye1@.hotmail.REMOVETHIS.com> wrote in message
news:eHLxnSTPGHA.1460@.TK2MSFTNGP10.phx.gbl...
> We have a project that is going to report from a sql2000 server utilizing
> Reporting Services(RS). So the natural thing to use is RS2000, (i assume
> based on licensing). I am confused concerning client report development
> tools for each version.
> For RS2000 -
> 1) The designer requires some version of 2003.net (vb,vs,etc..)?
> 2) One cannot use RS2005 tools?
>
> For RS2005
> 1) Does this require VS2005?
> 2) Is there a tool built into the Sql Studio Management suite that can be
> used instead of VS2005?
> 3) What about using 2003.net, is this an option?
> TIA
> CD
>