how can i install reporting services 2005

Hi,
I installed sql server 2005 enterprise edition and visual studion 2005
professional.
but i am unable to create any projects. how can i create a report project '
(i cant find a business intelligence project anyw here
thanks in advanceYou need to install the BI client tools from the SQL Server CD/DVD.
Note that you did not need VS 2005 unless you are writing custom assemblies
or using VS specific tools (like the new controls found in VS 2005).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RP" <RP@.discussions.microsoft.com> wrote in message
news:D06128B6-9838-47EE-A853-3BAD7187B66F@.microsoft.com...
> Hi,
> I installed sql server 2005 enterprise edition and visual studion 2005
> professional.
> but i am unable to create any projects. how can i create a report project
> '
> (i cant find a business intelligence project anyw here
> thanks in advance|||Bruce,
Can you tell me what options i have to select when installing sql server to
select BIclient tools ?
Thanks
"Bruce L-C [MVP]" wrote:
> You need to install the BI client tools from the SQL Server CD/DVD.
> Note that you did not need VS 2005 unless you are writing custom assemblies
> or using VS specific tools (like the new controls found in VS 2005).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RP" <RP@.discussions.microsoft.com> wrote in message
> news:D06128B6-9838-47EE-A853-3BAD7187B66F@.microsoft.com...
> > Hi,
> > I installed sql server 2005 enterprise edition and visual studion 2005
> > professional.
> > but i am unable to create any projects. how can i create a report project
> > '
> > (i cant find a business intelligence project anyw here
> > thanks in advance
>
>|||I haven't installed it for awhile but it was obvious at the time.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RP" <RP@.discussions.microsoft.com> wrote in message
news:410BFD9A-F285-434A-985B-D18837488701@.microsoft.com...
> Bruce,
> Can you tell me what options i have to select when installing sql server
> to
> select BIclient tools ?
> Thanks
> "Bruce L-C [MVP]" wrote:
>> You need to install the BI client tools from the SQL Server CD/DVD.
>> Note that you did not need VS 2005 unless you are writing custom
>> assemblies
>> or using VS specific tools (like the new controls found in VS 2005).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "RP" <RP@.discussions.microsoft.com> wrote in message
>> news:D06128B6-9838-47EE-A853-3BAD7187B66F@.microsoft.com...
>> > Hi,
>> > I installed sql server 2005 enterprise edition and visual studion 2005
>> > professional.
>> > but i am unable to create any projects. how can i create a report
>> > project
>> > '
>> > (i cant find a business intelligence project anyw here
>> > thanks in advance
>>

How can I have a local copy of SQL server database?

I want to have a local copy of my SQL server database on a laptop (windows 2000 professional) so that I can demo the project on the client's site. I'm not sure if I can do it by MSDE. And is that possible to write the data back to SQL server after changin
g the local copy? Thanks a lot.
Ada Wang
You can for instance take a backup of the database and restore it on the other machine. Or use sp_detach_db
and sp_attach_db. Watch out for orphaned logins, though (read about sp_change_users_login in Books Online). If
you restore from your laptop to the server, it will overwrite the whole database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"ada" <anonymous@.discussions.microsoft.com> wrote in message
news:EFE651B5-A3E3-45A5-BB4C-07EBAF682314@.microsoft.com...
> I want to have a local copy of my SQL server database on a laptop (windows 2000 professional) so that I can
demo the project on the client's site. I'm not sure if I can do it by MSDE. And is that possible to write the
data back to SQL server after changing the local copy? Thanks a lot.
> Ada Wang