Can MSS 2005 be clustered using VM images i.e. with out a SAN

We would like to do MSS 2005 cluster failover testing with out Application,
however we do not have a SAN (or shared disk storage). Oracle provide the
ablity to create a 10G cluster using 2 Virtual Machines, so we were wondering
if Micrsoosft provides a a similiar solution for MSS 2005 and if so if there
is any documentation?
The lab manual from the course at www.clusterhelp.com does the whole thing
in Virtual Server.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"mikekimber1" <mikekimber1@.discussions.microsoft.com> wrote in message
news:872804DE-56CD-454C-80E1-AD196E043D29@.microsoft.com...
We would like to do MSS 2005 cluster failover testing with out Application,
however we do not have a SAN (or shared disk storage). Oracle provide the
ablity to create a 10G cluster using 2 Virtual Machines, so we were
wondering
if Micrsoosft provides a a similiar solution for MSS 2005 and if so if there
is any documentation?
|||How about a TechNet webcast?
TechNet Support WebCast: How to cluster Microsoft SQL Server 2005 by using
Microsoft Virtual Server
http://support.microsoft.com/kb/891798/en-us
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"mikekimber1" <mikekimber1@.discussions.microsoft.com> wrote in message
news:872804DE-56CD-454C-80E1-AD196E043D29@.microsoft.com...
> We would like to do MSS 2005 cluster failover testing with out
> Application,
> however we do not have a SAN (or shared disk storage). Oracle provide the
> ablity to create a 10G cluster using 2 Virtual Machines, so we were
> wondering
> if Micrsoosft provides a a similiar solution for MSS 2005 and if so if
> there
> is any documentation?
>
|||Geoff, Tom,
Thanjs for this. We will give it a ago.
Regards Mike Kimber
"Geoff N. Hiten" wrote:

> How about a TechNet webcast?
> TechNet Support WebCast: How to cluster Microsoft SQL Server 2005 by using
> Microsoft Virtual Server
> http://support.microsoft.com/kb/891798/en-us
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "mikekimber1" <mikekimber1@.discussions.microsoft.com> wrote in message
> news:872804DE-56CD-454C-80E1-AD196E043D29@.microsoft.com...
>

Can mirroring be implemented using SMO.

I wanted know that is it possible to implement mirroring in C#.NET framework using SMO (I need specifically a web applicaton). which willl provide a naive user the facilities integrated in SSMS. I am using VS.NET 2005 and SQL Server 2005 SP1.
Thanks and Regards,
Adii

Can you please clarify your question.

Database mirroring is a feature provided in "SQL Server 2005 SP1". Can you please elaborate what you mean by "implementing" it?

|||Thanks Sanjay,
I wanted to know that are there any classes or APIs provided, so that I can programmatically achieve mirroring in my application. Does SMO namespace can provide any assistance in this? Please do let me know if you know or find some solution for the same. I have SQL Server 2005 SP1 installed, but I don't want to use SSMS for doing mirroring. I want to provide this facility in my application to the user programmatically.|||I too am very interested in this answer. We are looking to automate some of the setup and configuration and it would be nice to be able to use SMO or some other exposed APIs to do it with.

Can mirroring be implemented using SMO.

I wanted know that is it possible to implement mirroring in C#.NET framework using SMO (I need specifically a web applicaton). which willl provide a naive user the facilities integrated in SSMS. I am using VS.NET 2005 and SQL Server 2005 SP1.
Thanks and Regards,
Adii

Can you please clarify your question.

Database mirroring is a feature provided in "SQL Server 2005 SP1". Can you please elaborate what you mean by "implementing" it?

|||Thanks Sanjay,
I wanted to know that are there any classes or APIs provided, so that I can programmatically achieve mirroring in my application. Does SMO namespace can provide any assistance in this? Please do let me know if you know or find some solution for the same. I have SQL Server 2005 SP1 installed, but I don't want to use SSMS for doing mirroring. I want to provide this facility in my application to the user programmatically.|||I too am very interested in this answer. We are looking to automate some of the setup and configuration and it would be nice to be able to use SMO or some other exposed APIs to do it with.

Can I use the rdls created in Visual Studio in Report builder

Hi,

I have created a report template in Visual Studio 2005.

To get a consistent look for all batch and ad-hoc reports, I want to provide this template( which has some labels/text fields/todays date in the report header etc) to the users using ad-hoc reporting.

But while opening the rdl file developed using VS 2005 in Report Builder I get an error:

Cannot Open this item

This report cannot be opened using Report Builder

One or more unexpected Report Definition Language (RDL) elements of the following type have been removed: DataSet
Microsoft.ReportingServices.ReportBuilder.ReportModel.Report: System.Web.Services.Protocols.SoapException: The operation you are attempting on item "/Data Sources/Adcenter" is not allowed for this item type. > Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item "/Data Sources/Adcenter" is not allowed for this item type.
at Microsoft.ReportingServices.Library.ModelCatalogItem.ModelStorage.GetModelItemIDAndItemSecurity(ModelCatalogItem model)
at Microsoft.ReportingServices.Library.ModelCatalogItem.ModelStorage.LoadModel(ModelCatalogItem model, Boolean getModelDefinition)
at Microsoft.ReportingServices.Library.ModelCatalogItem.LoadModel(CatalogItemContext modelContext, Nullable`1 requiredOperation, Boolean getModelDefinition)
at Microsoft.ReportingServices.Library.ModelCatalogItem.LoadUserModel(CatalogItemContext modelContext, Nullable`1 requiredOperation, String perspectiveID)
at Microsoft.ReportingServices.Library.GetUserModelAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005.GetUserModel(String Model, String Perspective, Byte[]& Definition)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService2005.GetUserModel(String Model, String Perspective, Byte[]& Definition)

I also tried to work it around by saving a file developed using Report Builder and modifying it using VS 2005.But when I open the modified file in Report Builder ,it throws the error:

Cannot Open this item

This report cannot be opened using Report Builder

Value cannot be null.

Please help me in this.

Thanks in advance,

Heya --

No -- desiging a report in Report Builder which was created/modifed in VS2005 Report Designer is not supported...

Before 2005 released I remember trying to get it to work anyway, and if your Report Designer report was really, really simple, it sometimes did -- again., that was before the product RTM'd...

|||

Thanks Russel..

Could you suggest some way I can add images,today's date in a textbox (in the report header) etc in a Report Builder report.The insert option in the Report Builder provides only text boxes,unlike images etc in SQL BI Dev studio 2005.

I tried adding todays date as a calculated field in the report but I have to add it as a column in the table of my tabular report.

Thanks in advance..

|||

SP1 will allow you to insert images into reports in Report Builder (yay!) A community tech preview of SP1 was dropped earlier this week. See Brian's blog for more info:

http://blogs.msdn.com/bwelcker/

I've forgotten the current date function you use in R.B. (GetDate()? Now()?) but it should be as easy as adding this function as a forumla in a textbox.

|||

I just posted an example of how to do this on my blog:

http://blogs.msdn.com/bobmeyers/archive/2006/03/26/561147.aspx

|||

Hi,

I am truying to acheive the same. Please let me know if you found the solution.

Regards,

Prakash

Can I use the rdls created in Visual Studio in Report builder

Hi,

I have created a report template in Visual Studio 2005.

To get a consistent look for all batch and ad-hoc reports, I want to provide this template( which has some labels/text fields/todays date in the report header etc) to the users using ad-hoc reporting.

But while opening the rdl file developed using VS 2005 in Report Builder I get an error:

Cannot Open this item

This report cannot be opened using Report Builder

One or more unexpected Report Definition Language (RDL) elements of the following type have been removed: DataSet
Microsoft.ReportingServices.ReportBuilder.ReportModel.Report: System.Web.Services.Protocols.SoapException: The operation you are attempting on item "/Data Sources/Adcenter" is not allowed for this item type. > Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item "/Data Sources/Adcenter" is not allowed for this item type.
at Microsoft.ReportingServices.Library.ModelCatalogItem.ModelStorage.GetModelItemIDAndItemSecurity(ModelCatalogItem model)
at Microsoft.ReportingServices.Library.ModelCatalogItem.ModelStorage.LoadModel(ModelCatalogItem model, Boolean getModelDefinition)
at Microsoft.ReportingServices.Library.ModelCatalogItem.LoadModel(CatalogItemContext modelContext, Nullable`1 requiredOperation, Boolean getModelDefinition)
at Microsoft.ReportingServices.Library.ModelCatalogItem.LoadUserModel(CatalogItemContext modelContext, Nullable`1 requiredOperation, String perspectiveID)
at Microsoft.ReportingServices.Library.GetUserModelAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005.GetUserModel(String Model, String Perspective, Byte[]& Definition)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService2005.GetUserModel(String Model, String Perspective, Byte[]& Definition)

I also tried to work it around by saving a file developed using Report Builder and modifying it using VS 2005.But when I open the modified file in Report Builder ,it throws the error:

Cannot Open this item

This report cannot be opened using Report Builder

Value cannot be null.

Please help me in this.

Thanks in advance,

Heya --

No -- desiging a report in Report Builder which was created/modifed in VS2005 Report Designer is not supported...

Before 2005 released I remember trying to get it to work anyway, and if your Report Designer report was really, really simple, it sometimes did -- again., that was before the product RTM'd...

|||

Thanks Russel..

Could you suggest some way I can add images,today's date in a textbox (in the report header) etc in a Report Builder report.The insert option in the Report Builder provides only text boxes,unlike images etc in SQL BI Dev studio 2005.

I tried adding todays date as a calculated field in the report but I have to add it as a column in the table of my tabular report.

Thanks in advance..

|||

SP1 will allow you to insert images into reports in Report Builder (yay!) A community tech preview of SP1 was dropped earlier this week. See Brian's blog for more info:

http://blogs.msdn.com/bwelcker/

I've forgotten the current date function you use in R.B. (GetDate()? Now()?) but it should be as easy as adding this function as a forumla in a textbox.

|||

I just posted an example of how to do this on my blog:

http://blogs.msdn.com/bobmeyers/archive/2006/03/26/561147.aspx

|||

Hi,

I am truying to acheive the same. Please let me know if you found the solution.

Regards,

Prakash

Can I Use SQL Server 2005 Developer Edition For Client Tools?

My ISP has me licensed for a production SQL Server 2005 database, yet they
cannot provide me with the client tools that I need, specifically SQL Server
Management Studio and SQL Server Business Intelligence Development Studio.
If I purchase SQL Server 2005 Developer Edition will it have these two tools,
and will I be able to work with my production SQL database? Just for
clarification, I use the Business Intelligence studio to drop my existing
tables, and I migrate from locally-stored ACCESS databases to my production
SQL Server 2005 each night.On Jul 30, 3:46 pm, MIA Mark <MIAM...@.discussions.microsoft.com>
wrote:
> My ISP has me licensed for a production SQL Server 2005 database, yet they
> cannot provide me with the client tools that I need, specifically SQL Server
> Management Studio and SQL Server Business Intelligence Development Studio.
> If I purchase SQL Server 2005 Developer Edition will it have these two tools,
> and will I be able to work with my production SQL database? Just for
> clarification, I use the Business Intelligence studio to drop my existing
> tables, and I migrate from locally-stored ACCESS databases to my production
> SQL Server 2005 each night.
Yes, this should be fine. The licensing might be a bit of a gray area
though; but, I think that the ISP license should cover the production
deployment.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Regards,
Enrique Martinez
Sr. Software Consultant

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?
>> >> >
>> >
>