Groups | Blog | Home
all groups > sql server reporting services > may 2005 >

sql server reporting services : Use of Visual studio 2005 with sql 2000 reporting server?


niclas
5/3/2005 12:00:00 AM
If Microsoft decides to not support sql 2000 rs the reporting services
is not to any use for us.

We are an ISV that develops solutions for our customers. Our customers
are not going to directly jump on the sql 2005 bandwagon. We need the
personalization and memership api:s from vs2005, in ASP.NET. The
reporting services 1.1 is great. But if we can't develop ASP.NET 2.0
solutions and use reporting services 1.1, on sql 2000, then the
reporting services have to go.

We are using MS technology in our solutions. If MS decides to prevent us
from using RS by not supporting the RS 1.1 from vs2005. We have to start
looking for other reporting applications.

I beleave that our situation is not unique. ASP.Net and .Net framework
still supports sql 2000. Why does vs2005 only support rs 2.0?

Regards

[quoted text, click to view]
Bruce L-C [MVP]
5/3/2005 8:44:48 AM
The RS 2000 cannot use VS 2005. RS uses the 1.1 framework, not the 2.0
framework. I assume that is what you were asking. Another issue will be RS
2005. Microsoft realizes that people do not rev the version of the database
very quickly. My understanding is that RS 2005 will require the SQL Server
2005 license but it can be deployed to use SQL 2000 for its object store. RS
2005 uses the 2.0 framework and VS 2005. My suggestion is to plan to use RS
2005 when it comes out. There are a lot of capabilities coming out with RS
2005 that I don't think you would want to do without for 2 years
(multi-select parameters, client side sorting, etc).


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Bruce L-C [MVP]
5/3/2005 10:53:19 AM
What the report designer runs in is a totally separate issue from whether
you can use it in your environment. There is nothing to prevent you from
using RS 2000. You have to develop the report in VS 2003 but that is no big
deal. VS 2003 and VS 2005 will run side by side. VS 2005 will be the host
for RS 2005 but if you want to stick with the current RS then fine, do so..
Also, you are incorrect with your statement that you can't develop asp.net
2.0 solutions and use RS 1.1. You can integrate an ASP.net 2.0 application
with RS 2000 via either URL integration or SOAP (web services). That doesn't
change. The two RS websites have to use the 1.1 framework but IIS supports
this (some sites having 2.0 framework and some 1.1).

Another point on integration, the new webform control in VS 2005 might be
able to be used with RS 2000 reports but I am not certain of that. If so
then your integration options get even better. If not then all the current
integration methods open to you today continue for you in the future.

So, except for some small cost ($100 for VB.Net to have a VS 2003 for the
report designer to run in), some extra disk space for having both VS 2003
and VS 2005 installed nothing really changes.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services



[quoted text, click to view]

niclas
5/3/2005 11:35:05 AM
Hello!

How do we configure visual studio 2005 to publish reports to a SQL 2000
reporting server?

Our entire product line are going to get upgraded to .Net framework 2.0
and we plan to use visual studo 2005. Our reportingserver is sql 2000
based and will be on that platform for atleast 2 years. How do we
configure Visual studio 2005.

AddThis Social Bookmark Button