Move SQL Server and Analysis Service from C: to D:

Hi all,

We need to move the sql server and analysis Service and report server from C: to D:. Can some one outline the steps how should precede without losing any data? I am new at SQL Database, a detailed outline will be appreciated.

Thanks,

Yankua

Easiest, could be to create backup of all of your databases and re-install all products on another drive.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Move reports created by Report Builder

I have created a number of reports using Report Builder, and I would
like to move them to a new report server 2005 instance (I have
redeployed the underlying model to the new report server) and
associated model. Any easy way to do this?
Thanks,
Paul.Reporting Services Scripter v2
http://www.sqldbatips.com/showarticle.asp?ID=62
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Paul" <prayner@.matrixbancorp.com> wrote in message
news:1134682199.968299.138840@.o13g2000cwo.googlegroups.com...
>I have created a number of reports using Report Builder, and I would
> like to move them to a new report server 2005 instance (I have
> redeployed the underlying model to the new report server) and
> associated model. Any easy way to do this?
> Thanks,
> Paul.
>|||Thanks very much Jasper! Much appreciated.
Paul.

move report to other machine

Hi,
How can I move a report I developed in my computer (in Reporting Services
for SQL Server 2000) to another computer that already has SQL Server 2000
and Reporting Services installed?
Is it with Import/Export, generated scripts, ... ?
Thanks,
Nuno MachadoCopy your RDL file from your computer, to the other computer.
Go to Report Manager on the other computer, and click on the Upload File
button.
Find your RDL file where you copied it to and upload it.
Try your report.
You might have to create new datasources on the other report server. Just
copy whatever settings you have on the first one and do any adjustments you
need to do.
If you can access the other server from your computer (type in
http://whatever/reportserver ), then you don't have to copy the file, just
upload it from your web page. Or try deploying it directly through Visual
Studio, if you have the right access rights.
Kaisa M: Lindahl
"Nuno Machado" <nuno.machado@.vpconsulting.pt> wrote in message
news:er%23rSxCHGHA.1180@.TK2MSFTNGP09.phx.gbl...
> Hi,
> How can I move a report I developed in my computer (in Reporting Services
> for SQL Server 2000) to another computer that already has SQL Server 2000
> and Reporting Services installed?
> Is it with Import/Export, generated scripts, ... ?
> Thanks,
> Nuno Machado
>

move report server to new machine

Can someone tell me how I can move report server web sites into a new machine without reinstall it?

I like to keep the current report server database intact, it’s residing on a third server.

I copied the report server file folders including bin (dlls) into the new machine and set up in the new machine the Reportserver and Reports web sites pointing to these two folders while keeping the report server database still residing on the third machine, but the new site did not work, I got "Event source Report Server does not exist. (rsEventLogSourceNotFound)" error

Any advice will be greatly appreciated.

Thanks

Jerry

Well, the short answer is you can't. :) You'll need to install RS on the new machne. Licensing requires that if your RS and SQL are on different machines, you will need a seperate license for each.|||

Thanks James.

Well my next quest is: when I install RS on new machine with the license, I think I should install the new RS database on the same SQL server/database as the old RS server does, then will the newly installed RS DB overwrite the existing RS DB? or it will just makes use it without change anything in it?

Thanks a lot!

Jerry

|||It will never overwrite your RS database. Since you are doing a RS only install, you will only be able to use the "files-only" option (you will see this in the installation wizard). Post-install, you need to use the configuration tool to either create the RS databases, or set RS to connect to your old databases. The decision is up to you, but you will need to do it manually.|||Thanks a lot James, I will try.

move project to another developer

When another developer open my report project in his machine, he could not
look at the report on design view. The user id on data source is a SQL user
id, not Windows ID. How do I fix the problem?Has the other developer installed the Reporting Service client utilities
from the CD?
--
Mary Bray [SQL Server MVP]
Please reply only to newsgroups
"Jason Wang" <JasonWang@.discussions.microsoft.com> wrote in message
news:9ABB6ED4-7A06-48F5-9A69-E5341D06AA86@.microsoft.com...
> When another developer open my report project in his machine, he could not
> look at the report on design view. The user id on data source is a SQL
> user
> id, not Windows ID. How do I fix the problem?

MS Reporting Services 2000 Error ?

hi

when i try to use Reporting Services to render a report from aspx page

(web app) (vb.net) by usingReportingServices.dll (by add referennces)

i am not using (web referennces)

i get this erorr :

==================

System.Web.Services.Protocols.SoapException: The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. > Microsoft.ReportingServices.Diagnostics.Utilities.RSException .

note:

=====

- i have windows 2003 server ent.

- sql 2000 sp3 .

- MS Reporting Services 2000 sp2 .

- i am login as administrator .

pls tell me what i can do ?

thank you all

Hi,

as you did not post any code, I can give you a common suggestion. If you use impersonation, you will have to use the credentials of the actual user and add it to the instantiated proxy of the webservice. This will make the call to the webservice under the credentials and the permissions of the impersonated user.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Correct me if I'm wrong, but if you don't do this then it uses the identity of the app pool under which the website runs which by default is network service for the default app pool|||yep.