Report Designer installation location

We are installing Reporting Services 2000 on a new SQL Server 2000 box and
get a message indicating that Visual Studio 2003 needs to be installed,
otherwise it will install RS2000 without Report Designer.
We currently have RS2000 installed on a SQL Server box with VS2003 and it
works fine.
This time we would like to do it differently and install RS2000 on a SQL
Server 2000 box, but install VS2003 on a development workstation. How can we
do this and still get Report Designer installed on the workstation? Don't we
need RD to get all the RS controls, etc?
Thanks,
SteveOn Aug 1, 12:50 pm, Steve <MyNoS...@.NoSpam.org> wrote:
> We are installing Reporting Services 2000 on a new SQL Server 2000 box and
> get a message indicating that Visual Studio 2003 needs to be installed,
> otherwise it will install RS2000 without Report Designer.
> We currently have RS2000 installed on a SQL Server box with VS2003 and it
> works fine.
> This time we would like to do it differently and install RS2000 on a SQL
> Server 2000 box, but install VS2003 on a development workstation. How can we
> do this and still get Report Designer installed on the workstation? Don't we
> need RD to get all the RS controls, etc?
> Thanks,
> Steve
If I recall, the Report Designer for the 2000 version requires Visual
Studio to be installed on the same box. This is not the case in SSRS
2005, since it installs the Business Intelligence Development Studio
Environment (which includes the Report Designer) as long as SQL Server
2005 is on the local box. Most likely, you will need to install VS
2003. Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Report Builder Cube deploys to the wrong location!!

I have built a cube successfully however, it deploys succcessfully but to the wrong location. I have MSSQL.1, MSSQL.2 and MSSQL.3 and I Reporting Services in is MSSQL.3 but the cube is deploying to MSSQL.2/OLAP and I can't access it from there. I have tried changing the server name and specifiying the server/instance but it fails. I'm at my wits end! HELP!

Debra

The directories you've outlined are all correct and the cube has deployed to the correct location. With all components installed the locations should be as follows:

MSSQL - SQL 2000 Database Engine|||I am trying to access it by clicking on "report builder" from the reports webpage http://localhost/reports. Instead of seeing the cube in the selection box, there is a message saying therre are no cubes available and that in order to use report builder at least one cube must be published to the report server. Again, I am able to "successfully" deploy (using either localhost or my server name) but for some reason report builder can't "see" it. Are there some setting I need to modify for report builder?|||

Report builder does not connect directly to a cube. It connects to a Report Model which is different.

Once you've created a cube you first need to create a data source to point to that cube. you can do this by clicking the "New Data Source" button on the toolbar in report manager. Give it a name, select "Microsoft Analysis Services" as the connection type and put something like

Initial Catalog=Adventure Works DW;Data Source=<server>[\<instance>];

in the connection string box. Once you click ok to create the data source go to the properties page of the data source and click the "Generate Model" button. Once you've created the default model you'll be able to launch report builder and access the cube using the model.

Report models can also be created an modified using the BI development studio.

repltype

Hi
I am doing replication first time .i am having 4 master tables which want to
replicate to remote location through vpn connectivity.and the tables contain
around 5 lakhs of master records.i want to replicate each modified
datas.which type of replication i have to use here, snapshot,transactional or
merge.waiting for valid
suggestion,please help
Thanks
I don't know what a lakh is but it shouldn't change things much - it sounds
like transactional replication is what you need. Just to confirm - this'll be
fine if the subscriber doesn't need to update the data.
HTH,
Paul Ibison

replication--alternate snapshot location folder-- question

Hello.
I am needing to setup replication for some
pretty big tables. My distributor has
limited space on it. I was wondering if I
can redirect the snapshot location folder
using the options under properties. Answer
is yes, but my question is once the snap
shot has been done and moved over to the
subsriber, is this data then removed from
the original snapshot location? Does it
need to get back to this directory at a
later time for any part of syncing? Or is
it once the snapshot is done and has been
applied, I can go remove that snapshot
location without worries?
Thanks,
I just checked this for you - copying then deleting the original snapshot
files before running the merge agent, and synchronization worked without any
issues.
Regards,
Paul Ibison
|||In article <#sYdrSAfEHA.396
@.TK2MSFTNGP12.phx.gbl>,
Paul.Ibison@.Pygmalion.Com says...
> I just checked this for you - copying then deleting the original snapshot
> files before running the merge agent, and synchronization worked without any
> issues.
> Regards,
> Paul Ibison
>
>
yes, i was able to do this as well. Thanks
for looking at this.. i actually had really
good luck this weekend with using an
alternate snapshot location. One thing I
noticed is that you have to stage the
snapshot agents out a little bit. i was
running too many at once and it would cause
some problems.
thanks,
comb