Using Reporting Services 2000 with Visual Studios 2005
in [Reports]
|
From: Bruce L-C [MVP] on 30 Jan 2006 10:30 Deploying to the customer, they need a SQL Server 2005 license. No visual studio license. SQL Server 2000 license is not addequate. If they want RS 2005 reports they have to have a SQL Server 2005 license. You can deploy RS 2005 on SQL Server 2000 but you still need the SQL Server 2005 license. So, the point here, don't worry about Visual Studio, worry about SQL Server licensing. -- Bruce Loehle-Conger MVP SQL Server Reporting Services "Steve" <Steve(a)discussions.microsoft.com> wrote in message news:2B3C5395-252B-465D-A481-DC72C0F417B5(a)microsoft.com... > Bruce, > > Thanks for the info. I was real excited when I first saw your message but > then as I thought about it some more I figured there was something that I > was > not clear of in my prior message that may be important here. My client > does > not have Visual Studio - I have that on my machine and I develop for them > on > my machine and then move it to their machine. They are licensed for > SQL2000. > Would then need to have a license for VS2005 if I were to use RS2005 on > their server? > Thanks again. > > > "Bruce L-C [MVP]" wrote: > >> RS 2005 comes with a version of VS 2005 just for the designer. No extra >> purchase is needed. Yes, the license if for SQL Server 2005. >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "Steve" <Steve(a)discussions.microsoft.com> wrote in message >> news:EC78353A-1262-4237-91C4-72085566D109(a)microsoft.com... >> >I think i know the answer to this, but just on the off chance I will >> >ask. >> > The 2005 license you mentioned that we would need if we wanted to use >> > RS2005 >> > is for SQL and not VS2005. Is that correct? My client is not willing >> > to >> > pay >> > for the SQL2005 license at this point so this option is not available >> > to >> > me. >> > From your message I am pretty sure you were talking about the SQL >> > license, >> > but thought I would double check. >> > >> > Thanks for your help on this. >> > >> > "Bruce L-C [MVP]" wrote: >> > >> >> No. You have to use the RS 2000 report designer, which requires VS >> >> 2003.You >> >> can run VS 2003 and VS 2005 side by side (I do). >> >> >> >> Also, keep in mind, that if you want to upgrade RS to 2005 you can >> >> leave >> >> SQL >> >> Server DB at 2000 (however you do need a 2005 license). This is how I >> >> am >> >> currently running. >> >> >> >> >> >> -- >> >> Bruce Loehle-Conger >> >> MVP SQL Server Reporting Services >> >> >> >> >> >> >> >> "Steve" <Steve(a)discussions.microsoft.com> wrote in message >> >> news:01AF147A-41BD-4726-B522-914F47AA95CC(a)microsoft.com... >> >> > We are using SQL2000 with Reporting Services 2000. I would like to >> >> > be >> >> > able >> >> > to use Visual Studios 2005 to create my reports. After creating the >> >> > reports >> >> > and uploading the report to Reporting Services2000 we get the >> >> > following >> >> > error: >> >> > >> >> > >> >> > >> >> > >> >> > The report definition is not valid. Please verify that the report >> >> > definition >> >> > uses the current report definition namespace (i.e. >> >> > 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition'). >> >> > (rsNotACurrentReportDefinition) >> >> > >> >> > >> >> > When I look at my rdl I can see that my namespace is: >> >> > <Report >> >> > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" >> >> > xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> >> >> > >> >> > When I try to change the /2005/01/ to /2003/10/ I get an different >> >> > error. >> >> > >> >> > Is there a way of telling VS2005 to create the rdl for use with >> >> > RP2000? >> >> > >> >> > Thanks... >> >> > >> >> >> >> >> >> >> >> >>
From: Steve on 30 Jan 2006 12:06 That is what I was afraid of -- but it was what I needed to know. Thanks again for all your help on this. - Steve "Bruce L-C [MVP]" wrote: > Deploying to the customer, they need a SQL Server 2005 license. No visual > studio license. SQL Server 2000 license is not addequate. If they want RS > 2005 reports they have to have a SQL Server 2005 license. You can deploy RS > 2005 on SQL Server 2000 but you still need the SQL Server 2005 license. So, > the point here, don't worry about Visual Studio, worry about SQL Server > licensing. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Steve" <Steve(a)discussions.microsoft.com> wrote in message > news:2B3C5395-252B-465D-A481-DC72C0F417B5(a)microsoft.com... > > Bruce, > > > > Thanks for the info. I was real excited when I first saw your message but > > then as I thought about it some more I figured there was something that I > > was > > not clear of in my prior message that may be important here. My client > > does > > not have Visual Studio - I have that on my machine and I develop for them > > on > > my machine and then move it to their machine. They are licensed for > > SQL2000. > > Would then need to have a license for VS2005 if I were to use RS2005 on > > their server? > > Thanks again. > > > > > > "Bruce L-C [MVP]" wrote: > > > >> RS 2005 comes with a version of VS 2005 just for the designer. No extra > >> purchase is needed. Yes, the license if for SQL Server 2005. > >> > >> > >> -- > >> Bruce Loehle-Conger > >> MVP SQL Server Reporting Services > >> > >> "Steve" <Steve(a)discussions.microsoft.com> wrote in message > >> news:EC78353A-1262-4237-91C4-72085566D109(a)microsoft.com... > >> >I think i know the answer to this, but just on the off chance I will > >> >ask. > >> > The 2005 license you mentioned that we would need if we wanted to use > >> > RS2005 > >> > is for SQL and not VS2005. Is that correct? My client is not willing > >> > to > >> > pay > >> > for the SQL2005 license at this point so this option is not available > >> > to > >> > me. > >> > From your message I am pretty sure you were talking about the SQL > >> > license, > >> > but thought I would double check. > >> > > >> > Thanks for your help on this. > >> > > >> > "Bruce L-C [MVP]" wrote: > >> > > >> >> No. You have to use the RS 2000 report designer, which requires VS > >> >> 2003.You > >> >> can run VS 2003 and VS 2005 side by side (I do). > >> >> > >> >> Also, keep in mind, that if you want to upgrade RS to 2005 you can > >> >> leave > >> >> SQL > >> >> Server DB at 2000 (however you do need a 2005 license). This is how I > >> >> am > >> >> currently running. > >> >> > >> >> > >> >> -- > >> >> Bruce Loehle-Conger > >> >> MVP SQL Server Reporting Services > >> >> > >> >> > >> >> > >> >> "Steve" <Steve(a)discussions.microsoft.com> wrote in message > >> >> news:01AF147A-41BD-4726-B522-914F47AA95CC(a)microsoft.com... > >> >> > We are using SQL2000 with Reporting Services 2000. I would like to > >> >> > be > >> >> > able > >> >> > to use Visual Studios 2005 to create my reports. After creating the > >> >> > reports > >> >> > and uploading the report to Reporting Services2000 we get the > >> >> > following > >> >> > error: > >> >> > > >> >> > > >> >> > > >> >> > > >> >> > The report definition is not valid. Please verify that the report > >> >> > definition > >> >> > uses the current report definition namespace (i.e. > >> >> > 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition'). > >> >> > (rsNotACurrentReportDefinition) > >> >> > > >> >> > > >> >> > When I look at my rdl I can see that my namespace is: > >> >> > <Report > >> >> > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" > >> >> > xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> > >> >> > > >> >> > When I try to change the /2005/01/ to /2003/10/ I get an different > >> >> > error. > >> >> > > >> >> > Is there a way of telling VS2005 to create the rdl for use with > >> >> > RP2000? > >> >> > > >> >> > Thanks... > >> >> > > >> >> > >> >> > >> >> > >> > >> > >> > > >
First
|
Prev
|
Pages: 1 2 Prev: How to suppress a field if it is null Next: Trying to Initialize Reporting Services |