| Groups | Blog | Home |
sql server reporting services : Sql Reporting Services and Web Server 2003 Paradox
First, you don't have to use Web Server 2003. You can use Windows Advance
Server 2003 and have both installed. The issue with Web Server is that it is a special version that is specifically for web pages. This has absolutely nothing to do with IIS and SQL Server on the same box. Many people are doing this. Any cost savings of using Web Server will evaporate due to licensing issues with RS. RS requires a SQL Server license on the box it is installed on. So if you separate RS from the database used for its object caching and metadata you have to have another SQL Server license. So, key points: 1. RS can be installed separately from SQL Server but you still need a SQL Server license on both boxes 2. SQL Server and IIS coexist quite nicely. Use Windows Advanced Server 2003 (or Enterpise but that is probably overkill). 3. RS is a asp.net application (RS 2005 is an asp.net 2.0 application). -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Paul M via SQLMonster.com" <u9105@uwe> wrote in message news:58c887afbf536@uwe... > 'With the introduction of Windows Web Server 2003 > you cannot have SQL Server installed on the same machine (big time > security > issue) > it must remain separate on it own server > then how is a customer to run SQL Reporting Services letting them directly > on > SQL Server? > Is there a way to install just the Reporting Services either 2000 or 2005 > on > the Web Server? > Is there some kind of SQL Report Objects for the web server since the > correct > model would be to keep the Web Server and SQL Server separate. > Web Server 2003 won't even allow SQL Server on the same machine and vice > versa. > How do you get around this paradox?' > > -- > Message posted via SQLMonster.com > http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200512/1
RS does not have to be on the same box as your app. You can integrate with
RS on another box. Your options are: 1. Install IIS on the server which has SQL Server and install RS on that box. No additional license needed. 2. Install RS on Web Server 2003. Note RS 2005 requires this: For Reporting Services, you need Microsoft Internet Information Services (IIS) 5.0 or later, and ASP.NET 2.0 or later. Note option #2 is a little more complicated to install but is fully supported. RS goes on Web Server 2003 and its database goes wherever you have either SQL 2000 or SQL 2005 (it can use either). Also, note for option #2 you need another SQL Server license. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Paul M via SQLMonster.com" <u9105@uwe> wrote in message news:58c91457e6cd2@uwe... > What if your don't have the option of using Advanced Server 2003? > > Bruce L-C [MVP] wrote: >>First, you don't have to use Web Server 2003. You can use Windows Advance >>Server 2003 and have both installed. The issue with Web Server is that it >>is >>a special version that is specifically for web pages. This has absolutely >>nothing to do with IIS and SQL Server on the same box. Many people are >>doing >>this. Any cost savings of using Web Server will evaporate due to licensing >>issues with RS. RS requires a SQL Server license on the box it is >>installed >>on. So if you separate RS from the database used for its object caching >>and >>metadata you have to have another SQL Server license. >> >>So, key points: >>1. RS can be installed separately from SQL Server but you still need a SQL >>Server license on both boxes >>2. SQL Server and IIS coexist quite nicely. Use Windows Advanced Server >>2003 >>(or Enterpise but that is probably overkill). >>3. RS is a asp.net application (RS 2005 is an asp.net 2.0 application). >> >>> 'With the introduction of Windows Web Server 2003 >>> you cannot have SQL Server installed on the same machine (big time >>[quoted text clipped - 13 lines] >>> versa. >>> How do you get around this paradox?' > > -- > Message posted via SQLMonster.com > http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200512/1
When you install IIS you need to install it as an application server so it
has asp.net (and not just plain iis). -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Paul M via SQLMonster.com" <u9105@uwe> wrote in message news:58c978bcbbf22@uwe... > ok we did option 1 > 1. Install IIS on the server which has SQL Server and install RS on that > box. No additional license needed. > > > and recieve this error > > System.Web.Services.Protocols.SoapException: The report server > installation > is not initialized. Check the documentation for more information. ---> > Microsoft.ReportingServices.Diagnostics.Utilities. > ReportServerNotActivatedException: The report server installation is not > initialized. Check the documentation for more information. --- End of > inner > exception stack trace --- at Microsoft.ReportingServices.WebServer. > ReportingService.CreateDataSource(String DataSource, String Parent, > Boolean > Overwrite, DataSourceDefinition Definition, Property[] Properties) > > > why is it saying it is not initialized? > > > > Bruce L-C [MVP] wrote: >>RS does not have to be on the same box as your app. You can integrate with >>RS on another box. >>Your options are: >>1. Install IIS on the server which has SQL Server and install RS on that >>box. No additional license needed. >>2. Install RS on Web Server 2003. Note RS 2005 requires this: For >>Reporting >>Services, you need Microsoft Internet Information Services (IIS) 5.0 or >>later, and ASP.NET 2.0 or later. >> >>Note option #2 is a little more complicated to install but is fully >>supported. RS goes on Web Server 2003 and its database goes wherever you >>have either SQL 2000 or SQL 2005 (it can use either). Also, note for >>option >>#2 you need another SQL Server license. >> >>> What if your don't have the option of using Advanced Server 2003? >>> >>[quoted text clipped - 24 lines] >>>>> versa. >>>>> How do you get around this paradox?' > > -- > Message posted via SQLMonster.com > http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200512/1
What OS is your SQL Server running under?
-- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Paul M via SQLMonster.com" <u9105@uwe> wrote in message news:58c9a5ccf641e@uwe... > Ok but i have no idea how to install it as an Application Server can you > provide some link or documentation on how to do this? > > Bruce L-C [MVP] wrote: >>When you install IIS you need to install it as an application server so it >>has asp.net (and not just plain iis). >> >>> ok we did option 1 >>> 1. Install IIS on the server which has SQL Server and install RS on that >>[quoted text clipped - 37 lines] >>>>>>> versa. >>>>>>> How do you get around this paradox?' > > -- > Message posted via SQLMonster.com > http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200512/1
When it was installing the pre-requisites it would have errored out if it
did not have IIS and asp.net installed. If you didn't get an error you should be OK. What version of RS are you installing (RS 2005 or RS 2000?) -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Paul M via SQLMonster.com" <u9105@uwe> wrote in message news:58c9d1ae8c16e@uwe... > 2000 > > Bruce L-C [MVP] wrote: >>What OS is your SQL Server running under? >> >>> Ok but i have no idea how to install it as an Application Server can you >>> provide some link or documentation on how to do this? >>[quoted text clipped - 7 lines] >>>>>>>>> versa. >>>>>>>>> How do you get around this paradox?' > > -- > Message posted via SQLMonster.com > http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200512/1
I suggest you start a new subject. Something like Error Installing RS 2000.
Include information like the OS, error message etc. Is the OS 2000 pro or 2000 Server? Anyway, include all that and start a new thread. I don't know what else to tell you for your current problem. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Paul M via SQLMonster.com" <u9105@uwe> wrote in message news:58ca078dd6be6@uwe... > rs 2000 > > Bruce L-C [MVP] wrote: >>When it was installing the pre-requisites it would have errored out if it >>did not have IIS and asp.net installed. If you didn't get an error you >>should be OK. >> >>What version of RS are you installing (RS 2005 or RS 2000?) >> >>> 2000 >>> >>[quoted text clipped - 5 lines] >>>>>>>>>>> versa. >>>>>>>>>>> How do you get around this paradox?' > > -- > Message posted via SQLMonster.com > http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200512/1
'With the introduction of Windows Web Server 2003
you cannot have SQL Server installed on the same machine (big time security issue) it must remain separate on it own server then how is a customer to run SQL Reporting Services letting them directly on SQL Server? Is there a way to install just the Reporting Services either 2000 or 2005 on the Web Server? Is there some kind of SQL Report Objects for the web server since the correct model would be to keep the Web Server and SQL Server separate. Web Server 2003 won't even allow SQL Server on the same machine and vice versa. How do you get around this paradox?' -- Message posted via SQLMonster.com
What if your don't have the option of using Advanced Server 2003?
[quoted text, click to view] Bruce L-C [MVP] wrote: >First, you don't have to use Web Server 2003. You can use Windows Advance >Server 2003 and have both installed. The issue with Web Server is that it is >a special version that is specifically for web pages. This has absolutely >nothing to do with IIS and SQL Server on the same box. Many people are doing >this. Any cost savings of using Web Server will evaporate due to licensing >issues with RS. RS requires a SQL Server license on the box it is installed >on. So if you separate RS from the database used for its object caching and >metadata you have to have another SQL Server license. > >So, key points: >1. RS can be installed separately from SQL Server but you still need a SQL >Server license on both boxes >2. SQL Server and IIS coexist quite nicely. Use Windows Advanced Server 2003 >(or Enterpise but that is probably overkill). >3. RS is a asp.net application (RS 2005 is an asp.net 2.0 application). > >> 'With the introduction of Windows Web Server 2003 >> you cannot have SQL Server installed on the same machine (big time >[quoted text clipped - 13 lines] >> versa. >> How do you get around this paradox?' -- Message posted via SQLMonster.com
ok we did option 1
1. Install IIS on the server which has SQL Server and install RS on that box. No additional license needed. and recieve this error System.Web.Services.Protocols.SoapException: The report server installation is not initialized. Check the documentation for more information. ---> Microsoft.ReportingServices.Diagnostics.Utilities. ReportServerNotActivatedException: The report server installation is not initialized. Check the documentation for more information. --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer. ReportingService.CreateDataSource(String DataSource, String Parent, Boolean Overwrite, DataSourceDefinition Definition, Property[] Properties) why is it saying it is not initialized? [quoted text, click to view] Bruce L-C [MVP] wrote: >RS does not have to be on the same box as your app. You can integrate with >RS on another box. >Your options are: >1. Install IIS on the server which has SQL Server and install RS on that >box. No additional license needed. >2. Install RS on Web Server 2003. Note RS 2005 requires this: For Reporting >Services, you need Microsoft Internet Information Services (IIS) 5.0 or >later, and ASP.NET 2.0 or later. > >Note option #2 is a little more complicated to install but is fully >supported. RS goes on Web Server 2003 and its database goes wherever you >have either SQL 2000 or SQL 2005 (it can use either). Also, note for option >#2 you need another SQL Server license. > >> What if your don't have the option of using Advanced Server 2003? >> >[quoted text clipped - 24 lines] >>>> versa. >>>> How do you get around this paradox?' -- Message posted via SQLMonster.com
Ok but i have no idea how to install it as an Application Server can you
provide some link or documentation on how to do this? [quoted text, click to view] Bruce L-C [MVP] wrote: >When you install IIS you need to install it as an application server so it >has asp.net (and not just plain iis). > >> ok we did option 1 >> 1. Install IIS on the server which has SQL Server and install RS on that >[quoted text clipped - 37 lines] >>>>>> versa. >>>>>> How do you get around this paradox?' -- Message posted via SQLMonster.com
2000
[quoted text, click to view] Bruce L-C [MVP] wrote: >What OS is your SQL Server running under? > >> Ok but i have no idea how to install it as an Application Server can you >> provide some link or documentation on how to do this? >[quoted text clipped - 7 lines] >>>>>>>> versa. >>>>>>>> How do you get around this paradox?' -- Message posted via SQLMonster.com
rs 2000
[quoted text, click to view] Bruce L-C [MVP] wrote: >When it was installing the pre-requisites it would have errored out if it >did not have IIS and asp.net installed. If you didn't get an error you >should be OK. > >What version of RS are you installing (RS 2005 or RS 2000?) > >> 2000 >> >[quoted text clipped - 5 lines] >>>>>>>>>> versa. >>>>>>>>>> How do you get around this paradox?' -- Message posted via SQLMonster.com
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |