Remote Deployment

What's the easiest way to deploy a project to a remote server? Keep in mind there won't be any machine level access to the server housing the sql server.

Your question is bit short.
If you are talking about deployment of Analysis Services project you have several ways.

1. Change your BI Dev project properties to tell it to deploy to remote machine.

2. Use Deployment utility.

3. deploy your project first to the local Analysis Server and then use Synchronization or Backup/Restore to move data and metadata to a remote server.

I am sure you can be quite creative and find other ways to deploy your solution.

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

Remote Deployment

I have developed and tested few reports using SQL Server 2000 Reproting
Service.
Now I want to deploy it with my Web Application Setup. Please advice
how can I do
that. I don't have access to remote server as it is on their local
intranet. Client simply
don't want us to access their machines. Is there any solution?
Thank you,
Best Regards
Tanweer BadamiYou can use Reporting Services Scripter to generate deployment scripts. You
can then supply them as is, or modify the batch file so you can pass in the
Report Server name as part of your setup (or simply use them as a basis for
your own deployment scripts)
Download Reporting Services Scripter
http://www.sqldbatips.com/showarticle.asp?ID=62
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Robert" <trbadami@.gmail.com> wrote in message
news:1137481899.124207.258680@.g43g2000cwa.googlegroups.com...
>I have developed and tested few reports using SQL Server 2000 Reproting
> Service.
> Now I want to deploy it with my Web Application Setup. Please advice
> how can I do
> that. I don't have access to remote server as it is on their local
> intranet. Client simply
> don't want us to access their machines. Is there any solution?
> Thank you,
> Best Regards
> Tanweer Badami
>|||Thanks alot Smith, I will try that and get back to you asap.
Best Regards
Tanweer Badami|||wow, I deployed it successfully. Reporting Service Scripter is a great
utility.
Thank a lot Smith.
Best Regards
Tanweer Badami|||HI I find difficulty in deploying
I have to pass the password name after running scripts.
"Robert" wrote:
> wow, I deployed it successfully. Reporting Service Scripter is a great
> utility.
> Thank a lot Smith.
> Best Regards
> Tanweer Badami
>

Remote Database Deployment

We have an application using a SQL 2005 database which we need to deploy to a client. The only we can find of deploying the structure and the data is to perform a backup on the source server and a restore on the destination server.

Is this really the best/only way to deploy a database? I'd appreciate any pointers.

Thanks in advance

LazyGenius wrote:

We have an application using a SQL 2005 database which we need to deploy to a client. The only we can find of deploying the structure and the data is to perform a backup on the source server and a restore on the destination server.

Is this really the best/only way to deploy a database? I'd appreciate any pointers.

Thanks in advance

If you're using SQL 2005 you don't even need to backup/restore. You can just Xcopy your mdf (and optionally ldf) files and do an attach.

|||

It all seems a bit "DOS" to me but thanks for the quick reply. We have a small utility program to attach the database so I guess we'll just use that.

Thanks again

|||

Hey you asked for a better way of doing it. Think of the time that it would take to backup and restore a large database. Compare that with detaching it, making a copy, and attaching that copy on the other end.

Remote connection to Analysis Service giving problem.

Hi,

I am stuck up with one of the deployment scenario. I have web application through which we can invoke reports. Reports are developed in SQL Server 2005 Reporting Service.

The reporting service project sets data source connection with Analysis Services database.

If we have all this on the same machine, we are able to integrate and see the results end to end.

However we are stuck up with the following deployment scenario.

Say our web application is on A machine
SQL Server 2005 database on B machine
SQL Server 2005 Analysis Services on C machine
SQL Server 2005 Reporting Services on D machine.

so analysis services C machine pointing to database on B machine. and reporting services D machine pointing to analysis services C machine.

So in Reporting Service project when we set the data source connection to a remote Analysis services machine (C)
it gives us the following error that "A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running."

Is this a known issue? I searched on google and this forum but dint get much help. I did check that for analysis service remote connection is enabled.

What exact steps do I have to follow?

First of all is this scenario ok that analysis services and reporting services on different machine?

This is very urgent for our project. Please help me find the solution.

Thanks in advance!

Note: I have posted a similar post in Reporting Services forum.

Ann.

This problem relates to the fact that two separate servers cannot identity a user without that you use Kerberos for authentication. If you have a network with Active Directory it is configuration issue. This feature is already in place.

Search on Windows 2003, Active Directory and Kerberos.

Mosha have a post on this regarding SSAS2005 here:

http://www.mosha.com/msolap/articles/kerberos_delegation.htm

HTH

Thomas Ivarsson