Reporting Services in Sql Server 2005 - how to access?

Hello,
I have worked with Reporting services (only a few times - still a beginner)
for sql server 2000, and I access it through Visual Studio 2003. My place
upgraded VS to VS2005, and I don't see an icon for reporting services.
Still using Sql Server 2000 though. But our MSDN subscriptoin finally gave
us Sql Server 2005 Enterprise(not installed yet).
So my question is if Reporting services comes with Sql Server 2005
Enterprise? If so, how to access?
While I am at it, is there a way to access Reporting Services for sql Server
2000 from VS2005 or am I limited to VS2003 for that?
Thanks,
RichRS 2000 is a framework 1.1 product (VS 2003 is also framework 1.1). RS 2005
is a framework 2.0 app (as VS 2005 is). RS 2000 report designer cannot be
hosted in VS 2005. The RS 2005 report designer is part of the SQL Server
2005 install media. If you have VS 2005 installed it will integrate with it.
If you do not have VS 2005 installed then it installs a version of VS 2005
just for the report designer (so if you don't not have VS 2005 you do not
have to buy it).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:C3541818-7B91-45D3-BCA8-A7AE292A7A6A@.microsoft.com...
> Hello,
> I have worked with Reporting services (only a few times - still a
> beginner)
> for sql server 2000, and I access it through Visual Studio 2003. My place
> upgraded VS to VS2005, and I don't see an icon for reporting services.
> Still using Sql Server 2000 though. But our MSDN subscriptoin finally
> gave
> us Sql Server 2005 Enterprise(not installed yet).
> So my question is if Reporting services comes with Sql Server 2005
> Enterprise? If so, how to access?
> While I am at it, is there a way to access Reporting Services for sql
> Server
> 2000 from VS2005 or am I limited to VS2003 for that?
> Thanks,
> Rich|||Thanks for your reply. I think we have the delux MSDN subscription. Gives
us everything. So yes, we have VS2005 installed. After a big ToDo (next
month) we will install Sql Server 2005. So, I am understanding then, that RS
2005 will install as part of the sql Server 2005 (enterprise) install? Well,
I guess I will find out. I hope RS2005 isn't quite as finicky as RS2003
(sometimes I can't preview reports from within the designer with RS2003 - get
weird error messages).
Rich
"Bruce L-C [MVP]" wrote:
> RS 2000 is a framework 1.1 product (VS 2003 is also framework 1.1). RS 2005
> is a framework 2.0 app (as VS 2005 is). RS 2000 report designer cannot be
> hosted in VS 2005. The RS 2005 report designer is part of the SQL Server
> 2005 install media. If you have VS 2005 installed it will integrate with it.
> If you do not have VS 2005 installed then it installs a version of VS 2005
> just for the report designer (so if you don't not have VS 2005 you do not
> have to buy it).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:C3541818-7B91-45D3-BCA8-A7AE292A7A6A@.microsoft.com...
> > Hello,
> >
> > I have worked with Reporting services (only a few times - still a
> > beginner)
> > for sql server 2000, and I access it through Visual Studio 2003. My place
> > upgraded VS to VS2005, and I don't see an icon for reporting services.
> > Still using Sql Server 2000 though. But our MSDN subscriptoin finally
> > gave
> > us Sql Server 2005 Enterprise(not installed yet).
> >
> > So my question is if Reporting services comes with Sql Server 2005
> > Enterprise? If so, how to access?
> >
> > While I am at it, is there a way to access Reporting Services for sql
> > Server
> > 2000 from VS2005 or am I limited to VS2003 for that?
> >
> > Thanks,
> > Rich
>
>|||You have to select to install RS on the server (just like you have to select
the other services like integration services, analysis services,etc). The
designer is a client install.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:5C71BA15-6565-467F-87E2-F839F731920C@.microsoft.com...
> Thanks for your reply. I think we have the delux MSDN subscription.
> Gives
> us everything. So yes, we have VS2005 installed. After a big ToDo (next
> month) we will install Sql Server 2005. So, I am understanding then, that
> RS
> 2005 will install as part of the sql Server 2005 (enterprise) install?
> Well,
> I guess I will find out. I hope RS2005 isn't quite as finicky as RS2003
> (sometimes I can't preview reports from within the designer with RS2003 -
> get
> weird error messages).
> Rich
> "Bruce L-C [MVP]" wrote:
>> RS 2000 is a framework 1.1 product (VS 2003 is also framework 1.1). RS
>> 2005
>> is a framework 2.0 app (as VS 2005 is). RS 2000 report designer cannot be
>> hosted in VS 2005. The RS 2005 report designer is part of the SQL Server
>> 2005 install media. If you have VS 2005 installed it will integrate with
>> it.
>> If you do not have VS 2005 installed then it installs a version of VS
>> 2005
>> just for the report designer (so if you don't not have VS 2005 you do not
>> have to buy it).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:C3541818-7B91-45D3-BCA8-A7AE292A7A6A@.microsoft.com...
>> > Hello,
>> >
>> > I have worked with Reporting services (only a few times - still a
>> > beginner)
>> > for sql server 2000, and I access it through Visual Studio 2003. My
>> > place
>> > upgraded VS to VS2005, and I don't see an icon for reporting services.
>> > Still using Sql Server 2000 though. But our MSDN subscriptoin finally
>> > gave
>> > us Sql Server 2005 Enterprise(not installed yet).
>> >
>> > So my question is if Reporting services comes with Sql Server 2005
>> > Enterprise? If so, how to access?
>> >
>> > While I am at it, is there a way to access Reporting Services for sql
>> > Server
>> > 2000 from VS2005 or am I limited to VS2003 for that?
>> >
>> > Thanks,
>> > Rich
>>|||Thank you for that tip. I am glad that I asked. So after I install RS on
the server, then I guess I run setup on the workstation and select client
tools or something?
"Bruce L-C [MVP]" wrote:
> You have to select to install RS on the server (just like you have to select
> the other services like integration services, analysis services,etc). The
> designer is a client install.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:5C71BA15-6565-467F-87E2-F839F731920C@.microsoft.com...
> > Thanks for your reply. I think we have the delux MSDN subscription.
> > Gives
> > us everything. So yes, we have VS2005 installed. After a big ToDo (next
> > month) we will install Sql Server 2005. So, I am understanding then, that
> > RS
> > 2005 will install as part of the sql Server 2005 (enterprise) install?
> > Well,
> > I guess I will find out. I hope RS2005 isn't quite as finicky as RS2003
> > (sometimes I can't preview reports from within the designer with RS2003 -
> > get
> > weird error messages).
> >
> > Rich
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> RS 2000 is a framework 1.1 product (VS 2003 is also framework 1.1). RS
> >> 2005
> >> is a framework 2.0 app (as VS 2005 is). RS 2000 report designer cannot be
> >> hosted in VS 2005. The RS 2005 report designer is part of the SQL Server
> >> 2005 install media. If you have VS 2005 installed it will integrate with
> >> it.
> >> If you do not have VS 2005 installed then it installs a version of VS
> >> 2005
> >> just for the report designer (so if you don't not have VS 2005 you do not
> >> have to buy it).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:C3541818-7B91-45D3-BCA8-A7AE292A7A6A@.microsoft.com...
> >> > Hello,
> >> >
> >> > I have worked with Reporting services (only a few times - still a
> >> > beginner)
> >> > for sql server 2000, and I access it through Visual Studio 2003. My
> >> > place
> >> > upgraded VS to VS2005, and I don't see an icon for reporting services.
> >> > Still using Sql Server 2000 though. But our MSDN subscriptoin finally
> >> > gave
> >> > us Sql Server 2005 Enterprise(not installed yet).
> >> >
> >> > So my question is if Reporting services comes with Sql Server 2005
> >> > Enterprise? If so, how to access?
> >> >
> >> > While I am at it, is there a way to access Reporting Services for sql
> >> > Server
> >> > 2000 from VS2005 or am I limited to VS2003 for that?
> >> >
> >> > Thanks,
> >> > Rich
> >>
> >>
> >>
>
>|||Yep.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:736D9C89-D8D0-46DE-A67C-750002DF8251@.microsoft.com...
> Thank you for that tip. I am glad that I asked. So after I install RS on
> the server, then I guess I run setup on the workstation and select client
> tools or something?
> "Bruce L-C [MVP]" wrote:
>> You have to select to install RS on the server (just like you have to
>> select
>> the other services like integration services, analysis services,etc). The
>> designer is a client install.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:5C71BA15-6565-467F-87E2-F839F731920C@.microsoft.com...
>> > Thanks for your reply. I think we have the delux MSDN subscription.
>> > Gives
>> > us everything. So yes, we have VS2005 installed. After a big ToDo
>> > (next
>> > month) we will install Sql Server 2005. So, I am understanding then,
>> > that
>> > RS
>> > 2005 will install as part of the sql Server 2005 (enterprise) install?
>> > Well,
>> > I guess I will find out. I hope RS2005 isn't quite as finicky as
>> > RS2003
>> > (sometimes I can't preview reports from within the designer with
>> > RS2003 -
>> > get
>> > weird error messages).
>> >
>> > Rich
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> RS 2000 is a framework 1.1 product (VS 2003 is also framework 1.1). RS
>> >> 2005
>> >> is a framework 2.0 app (as VS 2005 is). RS 2000 report designer cannot
>> >> be
>> >> hosted in VS 2005. The RS 2005 report designer is part of the SQL
>> >> Server
>> >> 2005 install media. If you have VS 2005 installed it will integrate
>> >> with
>> >> it.
>> >> If you do not have VS 2005 installed then it installs a version of VS
>> >> 2005
>> >> just for the report designer (so if you don't not have VS 2005 you do
>> >> not
>> >> have to buy it).
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:C3541818-7B91-45D3-BCA8-A7AE292A7A6A@.microsoft.com...
>> >> > Hello,
>> >> >
>> >> > I have worked with Reporting services (only a few times - still a
>> >> > beginner)
>> >> > for sql server 2000, and I access it through Visual Studio 2003. My
>> >> > place
>> >> > upgraded VS to VS2005, and I don't see an icon for reporting
>> >> > services.
>> >> > Still using Sql Server 2000 though. But our MSDN subscriptoin
>> >> > finally
>> >> > gave
>> >> > us Sql Server 2005 Enterprise(not installed yet).
>> >> >
>> >> > So my question is if Reporting services comes with Sql Server 2005
>> >> > Enterprise? If so, how to access?
>> >> >
>> >> > While I am at it, is there a way to access Reporting Services for
>> >> > sql
>> >> > Server
>> >> > 2000 from VS2005 or am I limited to VS2003 for that?
>> >> >
>> >> > Thanks,
>> >> > Rich
>> >>
>> >>
>> >>
>>