Deployment Server Properties

I am just starting into using the SQL 2005 tools and was trying to run my first model. I set up the Data sources and Data Source Views and Created a decision tree mining structure.

The properties for the deployment have the server as (local) and the database name that is valid. I am running SQLServer Express on my local PC and have verified that it is up and running.

When I try and do a Build and deploy, I get the following error:

"The project could not be deployed to the '(local)' server because of the following connection problems: A connection cannot be made. Enssure the server is running...."

Any idea what I'm doing wrong? I can deploy if I change the deployment to look at the server the data is on (a remote SQL 2005 server), but I would rather have it on my local machine. Maybe that is not a good idea. If not, please tell me.

Thanks in advance.

-Frank

Your mining model and associated objects need to be deployed to an Analysis Services 2005 instance, not to the relational database server. Since SQL Server 2005 Express does not include Analysis Services, you'll need to deploy to another server that's running Standard Edition or above and has a running instance of Analysis Services.|||

Ahh, that makes sense. Thanks.

-Frank

Deployment of Reports and Data Sources

What is the best way to deploy reports to production considering the fact that different developers would be working on different reports and different data sources. Also consider that the data sources connect to local machines of the developers during report creation and a different database server on deployment.

One way is to use VS2005 to deploy it to production but I am not sure if that is the way to go?

Any ideas?

Thanks

I'd probably create an RSS script which will publish the report to the whatever server it needs to and then actually "fixes up" the report to point to a "production datasource" which already exists on the production box. This "production datasource" points to the correct database on the server.

Use the CreateReport() API to publish the report, and here's a quick sample on fixing up the datasource on a report:

DataSourceReference reference = new DataSourceReference();
DataSource[] dsarray = new DataSource[1];
DataSource ds = new DataSource();
reference.Reference = "/Data Sources/AdventureWorks";
ds.Item = (DataSourceReference)reference;
ds.Name = "AdventureWorks";
dsarray[0] = ds;
rs.SetItemDataSources("/AdventureWorks Sample Reports/Company Sales", dsarray)

It bascially sets the datasource of the Company Sales report to point to the AdventureWorks datasource int he /Data Sources folder.

The nice thing about this idea is that if you have only a few different databases to deal with, you could actually write the RSS script to that it acts on all reports in filesystem folder, and then does some thinking and points each report to the correct "production" data source during the "fix up" phase...

Deploying a report

I am new to Reporting services and have created just a layout page.

no datasets or data sources are present. This is just a cover page.

I need to show this page through a url. Can i deploy this on my local machine rather than showing some-one through the preview mode.

What would be the local host configuration settings.

Thanks.

Do you have the report catalog databased and report server installed on your local machine?

If so and you'd like to deploy from visual studio, go to your project properties, find the target url property and put in "http://localhost/reportserver". Next right click and try "Deploy".

You can also easily deploy from SQL Server Management Studio.|||

Hello,

I dont think I have the reportserver installed on my machine.

When i try doing the localhost/reportserver it shows an error saying underlying connection failed.

I tried deploying from SQL server management studio trying bto make sense of the $MYSORIAN. that failed too http://aspalliance.com/819

Any help documentation etc?

thanks

|||

Hi, I assume you are using BI to build your report. If so, right click on the project and select properties and setup Deployment parameters as follows:

TargetReportFolder TestReport (your report folder name if you want to store the report in a separate folder other than

default Home folder)

TargetServerURL http://ReportServerPC/ReportServer(If the report server was installed using default settings)

or

http://ReportServerPC/ReportServer$NameoftheReportServer(If the report server was installed as named instance)

For example if the name of your report server instance is ABC and it was installed on a server 123 then it would be

http://123/ReportServer$ABC

Please note you have to use https, if the report server is configured to use SSL.

After setting up the parameters, right click on your report and select deploy.

Hope this helps!

|||

Hello,

In this setup how would i be able to replace local host. I do not know if the ReportServer is installed on my machine and i do not ahve access to any other server.

TargetServerURL http://ReportServerPC/ReportServer(If the report server was installed using default settings)

Thanks

|||

Hi,

There are couple ways you can check whether you have report server on your machine or not.

Check your program files folder: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services Check in your IIS management console whether you have a virtual directory called ReportServer under default website Copy the url http://localhost/ReportServer paste into your web browser and if you can see the folders in ReportServer web folder then you have reporting services on your PC.

Deploy to Production Server

Hi guys

I have some SSRS reports, shared data sources, data source views and a data model that I need to deploy into production. But I work in a very large firm and we cannot use the Visual Studio interface - I have to provide another team with the files and instructions for installation. Has anyone done this before or have any ideas?

Cheers

XOR

XOR

If you cant use VS.NET you can send them the rdls and ask them to navigate to the Report Maanger and upload the rdls into the directory, if it does not already exist, they will have to create the directory which they can do through the report manager interface also

HTH

|||Thanks HTH, do you know if this action can be scripted at all?|||

XOR

Check out this article, havent tried it myself but it may help you

http://msdn2.microsoft.com/en-us/library/ms159720.aspx

deploy SQL2000 database to other server

hi,
I am sorting data from all different sources, xml, access, text..etc
to my own sql2000 server. (computer name is "testingmachine")
atfter I clean up the database, I will give the final database to the
client and install in their server (computer name is "SQLS")
1) what's the best way to move database structure and data over to
their server? there are few different methods, which one is the best
solution in my situation. thank you!
PS. I use *.adp ("access running time" as frontend client interface)
thank you!
This KB article should give you a few methods. You can decide which way is
best for your situation:
http://support.microsoft.com/default...46&Product=sql
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Bob Yang" <bobyang3@.hotmail.com> wrote in message
news:35582154.0406301458.2553431b@.posting.google.c om...
> hi,
> I am sorting data from all different sources, xml, access, text..etc
> to my own sql2000 server. (computer name is "testingmachine")
> atfter I clean up the database, I will give the final database to the
> client and install in their server (computer name is "SQLS")
> 1) what's the best way to move database structure and data over to
> their server? there are few different methods, which one is the best
> solution in my situation. thank you!
>
> PS. I use *.adp ("access running time" as frontend client interface)
> thank you!

deploy SQL2000 database to other server

hi,
I am sorting data from all different sources, xml, access, text..etc
to my own sql2000 server. (computer name is "testingmachine")
atfter I clean up the database, I will give the final database to the
client and install in their server (computer name is "SQLS")
1) what's the best way to move database structure and data over to
their server? there are few different methods, which one is the best
solution in my situation. thank you!
PS. I use *.adp ("access running time" as frontend client interface)
thank you!This KB article should give you a few methods. You can decide which way is
best for your situation:
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546&Product=sql
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Bob Yang" <bobyang3@.hotmail.com> wrote in message
news:35582154.0406301458.2553431b@.posting.google.com...
> hi,
> I am sorting data from all different sources, xml, access, text..etc
> to my own sql2000 server. (computer name is "testingmachine")
> atfter I clean up the database, I will give the final database to the
> client and install in their server (computer name is "SQLS")
> 1) what's the best way to move database structure and data over to
> their server? there are few different methods, which one is the best
> solution in my situation. thank you!
>
> PS. I use *.adp ("access running time" as frontend client interface)
> thank you!

deploy SQL2000 database to other server

hi,
I am sorting data from all different sources, xml, access, text..etc
to my own sql2000 server. (computer name is "testingmachine")
atfter I clean up the database, I will give the final database to the
client and install in their server (computer name is "SQLS")
1) what's the best way to move database structure and data over to
their server? there are few different methods, which one is the best
solution in my situation. thank you!
PS. I use *.adp ("access running time" as frontend client interface)
thank you!This KB article should give you a few methods. You can decide which way is
best for your situation:
http://support.microsoft.com/defaul...546&Product=sql
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Bob Yang" <bobyang3@.hotmail.com> wrote in message
news:35582154.0406301458.2553431b@.posting.google.com...
> hi,
> I am sorting data from all different sources, xml, access, text..etc
> to my own sql2000 server. (computer name is "testingmachine")
> atfter I clean up the database, I will give the final database to the
> client and install in their server (computer name is "SQLS")
> 1) what's the best way to move database structure and data over to
> their server? there are few different methods, which one is the best
> solution in my situation. thank you!
>
> PS. I use *.adp ("access running time" as frontend client interface)
> thank you!

Deploy so that data sources are not viewable

Is there a way to configure a RS data source (in VS.NET) to be not visible
as default when deployed?
Thanks,
BryanI don't know of a way to do this. I go to Report Manager and have the data
source not show up in list view (go to the properties to set this). I know
of no way to do this from VS.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bryan Bullard" <reply@.to.group.com> wrote in message
news:e1xiZ%23qGFHA.2356@.TK2MSFTNGP12.phx.gbl...
> Is there a way to configure a RS data source (in VS.NET) to be not visible
> as default when deployed?
> Thanks,
> Bryan
>|||Maybe its possible to run this as a build step:
update ReportServer.dbo.Catalog
set Hidden = 1
where Type = 5
Is this safe?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:O0%23nvNrGFHA.3912@.TK2MSFTNGP10.phx.gbl...
>I don't know of a way to do this. I go to Report Manager and have the data
> source not show up in list view (go to the properties to set this). I know
> of no way to do this from VS.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bryan Bullard" <reply@.to.group.com> wrote in message
> news:e1xiZ%23qGFHA.2356@.TK2MSFTNGP12.phx.gbl...
>> Is there a way to configure a RS data source (in VS.NET) to be not
>> visible
>> as default when deployed?
>> Thanks,
>> Bryan
>>
>|||I don't know. See as how when you are installing no-one has rights to it
until you give them rights I have never felt the need to not just use the
Report Manager.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bryan Bullard" <reply@.to.group.com> wrote in message
news:ODL4h3rGFHA.2744@.tk2msftngp13.phx.gbl...
> Maybe its possible to run this as a build step:
> update ReportServer.dbo.Catalog
> set Hidden = 1
> where Type = 5
> Is this safe?
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:O0%23nvNrGFHA.3912@.TK2MSFTNGP10.phx.gbl...
> >I don't know of a way to do this. I go to Report Manager and have the
data
> > source not show up in list view (go to the properties to set this). I
know
> > of no way to do this from VS.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Bryan Bullard" <reply@.to.group.com> wrote in message
> > news:e1xiZ%23qGFHA.2356@.TK2MSFTNGP12.phx.gbl...
> >> Is there a way to configure a RS data source (in VS.NET) to be not
> >> visible
> >> as default when deployed?
> >>
> >> Thanks,
> >> Bryan
> >>
> >>
> >
> >
>|||Good point. Thanks for your reply.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ul3HEDsGFHA.3628@.TK2MSFTNGP15.phx.gbl...
>I don't know. See as how when you are installing no-one has rights to it
> until you give them rights I have never felt the need to not just use the
> Report Manager.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bryan Bullard" <reply@.to.group.com> wrote in message
> news:ODL4h3rGFHA.2744@.tk2msftngp13.phx.gbl...
>> Maybe its possible to run this as a build step:
>> update ReportServer.dbo.Catalog
>> set Hidden = 1
>> where Type = 5
>> Is this safe?
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:O0%23nvNrGFHA.3912@.TK2MSFTNGP10.phx.gbl...
>> >I don't know of a way to do this. I go to Report Manager and have the
> data
>> > source not show up in list view (go to the properties to set this). I
> know
>> > of no way to do this from VS.
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "Bryan Bullard" <reply@.to.group.com> wrote in message
>> > news:e1xiZ%23qGFHA.2356@.TK2MSFTNGP12.phx.gbl...
>> >> Is there a way to configure a RS data source (in VS.NET) to be not
>> >> visible
>> >> as default when deployed?
>> >>
>> >> Thanks,
>> >> Bryan
>> >>
>> >>
>> >
>> >
>>
>

Deploy Shared Datasource error

Hello,
When I tried to deploy shared data sources, there is an error â'A connection
could not be made to report server to â?¦â' I donâ'tâ' what is wrongâ?¦. Could
anyone please help me to solve this problem?
Thanks in advance
ChiekoCheck the properties of the shared data source from the web folder where it
resides. I'm not sure if this is the norm, but I have to choose Connect
Using: Credentials stored securely in the report server and include a
username and password. For security purposes, use a username that has
read-only access to your database.
Hope that helps!
"chieko" wrote:
> Hello,
> When I tried to deploy shared data sources, there is an error â'A connection
> could not be made to report server to â?¦â' I donâ'tâ' what is wrongâ?¦. Could
> anyone please help me to solve this problem?
> Thanks in advance
> Chieko
>

Deploy a data source via Report Manager

You can deploy both reports and the data sources used by
them in Report Designer. You can also deploy reports by
uploading them in Report Manager. But I can't find a way
to deploy data sources (not creating new data sources)
using Report Manager.
Ideally, when the developers have finished designing and
testing reports, I'd like to have them sending me both rdl
files and rds files so that I can deploy them into
production.
Can I deploy data sources using Report Manager?
JoeHi, data srouces are files with the .rds extension. I think you can deploy
them by uploading them using report manager.
Cédric
"Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
news:86a501c4783b$85c5e8c0$a401280a@.phx.gbl...
> You can deploy both reports and the data sources used by
> them in Report Designer. You can also deploy reports by
> uploading them in Report Manager. But I can't find a way
> to deploy data sources (not creating new data sources)
> using Report Manager.
> Ideally, when the developers have finished designing and
> testing reports, I'd like to have them sending me both rdl
> files and rds files so that I can deploy them into
> production.
> Can I deploy data sources using Report Manager?
> Joe
>|||If you upload a rds file using Report Manager, you just get a file, not a
data source. Are you sure that'll work?
Joe
"Cédric Naudy" <cnaudy@.online.microsoft.com> wrote in message
news:OaWljfKeEHA.332@.TK2MSFTNGP09.phx.gbl...
> Hi, data srouces are files with the .rds extension. I think you can deploy
> them by uploading them using report manager.
> Cédric
> "Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
> news:86a501c4783b$85c5e8c0$a401280a@.phx.gbl...
> > You can deploy both reports and the data sources used by
> > them in Report Designer. You can also deploy reports by
> > uploading them in Report Manager. But I can't find a way
> > to deploy data sources (not creating new data sources)
> > using Report Manager.
> >
> > Ideally, when the developers have finished designing and
> > testing reports, I'd like to have them sending me both rdl
> > files and rds files so that I can deploy them into
> > production.
> >
> > Can I deploy data sources using Report Manager?
> >
> > Joe
> >
>|||Sorry, this is not supported. You cannot create a shared data source on the
server by uploading an RDS file.
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:O46PeAQeEHA.3792@.TK2MSFTNGP09.phx.gbl...
> If you upload a rds file using Report Manager, you just get a file, not a
> data source. Are you sure that'll work?
> Joe
> "Cédric Naudy" <cnaudy@.online.microsoft.com> wrote in message
> news:OaWljfKeEHA.332@.TK2MSFTNGP09.phx.gbl...
> > Hi, data srouces are files with the .rds extension. I think you can
deploy
> > them by uploading them using report manager.
> >
> > Cédric
> >
> > "Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
> > news:86a501c4783b$85c5e8c0$a401280a@.phx.gbl...
> > > You can deploy both reports and the data sources used by
> > > them in Report Designer. You can also deploy reports by
> > > uploading them in Report Manager. But I can't find a way
> > > to deploy data sources (not creating new data sources)
> > > using Report Manager.
> > >
> > > Ideally, when the developers have finished designing and
> > > testing reports, I'd like to have them sending me both rdl
> > > files and rds files so that I can deploy them into
> > > production.
> > >
> > > Can I deploy data sources using Report Manager?
> > >
> > > Joe
> > >
> >
> >
>