Deployment Scripts

We are introducing a new infrastructure in work where we use depoyment
scripts rather than tweaking the db with Enterprise Manager. While I can see
the benefits of this it will be time consuming. Are there any tools out
there to automatically generate any kind of DDL script you would want. For
instance I can't find a way in Enterprise Manager/ Query Analyser to
generate logins or stuff related to jobs. Regards, Chris.Chris,
to generate logins, there is the Options tab on the Generate SQL Scripts
dialogue. For jobs, just highlight them all and right-click.
There are other things that aren't scriptable though from the GUI (linked
servers, maintenance plans, diagrams etc). For these I know of workarounds
but no simple tool. BTW in SQL Server 2005 almost anything is scriptable
from the GUI.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Chris wrote:
> We are introducing a new infrastructure in work where we use depoyment
> scripts rather than tweaking the db with Enterprise Manager. While I can s
ee
> the benefits of this it will be time consuming. Are there any tools out
> there to automatically generate any kind of DDL script you would want. For
> instance I can't find a way in Enterprise Manager/ Query Analyser to
> generate logins or stuff related to jobs. Regards, Chris.
>
Kudos to whoever is driving this change. It may seem time consuming
now, but after you get used to it, you'll find that the GUI is actually
harder to use than writing the scripts.
While some things may not be directly scriptable from Enterprise
Manager, virtually EVERYTHING that EM does can be done using scripts,
you just have to learn the commands. One way to observe what goes on
under the covers is to use Profiler to capture the commands issued by EM
when performing various operations.
Tracy McKibben
MCDBA
http://www.realsqlguy.comsql

Deployment Scripts

We are introducing a new infrastructure in work where we use depoyment
scripts rather than tweaking the db with Enterprise Manager. While I can see
the benefits of this it will be time consuming. Are there any tools out
there to automatically generate any kind of DDL script you would want. For
instance I can't find a way in Enterprise Manager/ Query Analyser to
generate logins or stuff related to jobs. Regards, Chris.Chris,
to generate logins, there is the Options tab on the Generate SQL Scripts
dialogue. For jobs, just highlight them all and right-click.
There are other things that aren't scriptable though from the GUI (linked
servers, maintenance plans, diagrams etc). For these I know of workarounds
but no simple tool. BTW in SQL Server 2005 almost anything is scriptable
from the GUI.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Chris wrote:
> We are introducing a new infrastructure in work where we use depoyment
> scripts rather than tweaking the db with Enterprise Manager. While I can see
> the benefits of this it will be time consuming. Are there any tools out
> there to automatically generate any kind of DDL script you would want. For
> instance I can't find a way in Enterprise Manager/ Query Analyser to
> generate logins or stuff related to jobs. Regards, Chris.
>
Kudos to whoever is driving this change. It may seem time consuming
now, but after you get used to it, you'll find that the GUI is actually
harder to use than writing the scripts.
While some things may not be directly scriptable from Enterprise
Manager, virtually EVERYTHING that EM does can be done using scripts,
you just have to learn the commands. One way to observe what goes on
under the covers is to use Profiler to capture the commands issued by EM
when performing various operations.
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Deployment issue - users cannot view reports

Hi All,
I am having some difficulty allowing users to view reports. I have
developed a series of reports on RS and deployed them to Report Manager.
However It is only myself that can view the reports on report mnanager -
whenever anyone else tries to log on and view them they get a blank page -
what am i doing wrong?
Thanks and HAPPY XMAS!!
GregGreg wrote:
> Hi All,
> I am having some difficulty allowing users to view reports. I have
> developed a series of reports on RS and deployed them to Report
> Manager. However It is only myself that can view the reports on
> report mnanager - whenever anyone else tries to log on and view them
> they get a blank page - what am i doing wrong?
>
> Thanks and HAPPY XMAS!!
> Greg
It may sound like a stupid question but ... have you checked their
permissions!
If they can see the Report Manager, but not see any reports, then the
security on the reports is too tight.
As administrator you will be able to click on properties and security
of the various folders and reports and add the appropriate users or
groups.
After that you will need to make sure the Datasources have suitable
logon credentials set too.
Regards (and merry christmas!)
Chris|||Hi chris - thanks for the pointer - ill check it out and get back!
"Chris McGuigan" wrote:
> Greg wrote:
> > Hi All,
> >
> > I am having some difficulty allowing users to view reports. I have
> > developed a series of reports on RS and deployed them to Report
> > Manager. However It is only myself that can view the reports on
> > report mnanager - whenever anyone else tries to log on and view them
> > they get a blank page - what am i doing wrong?
> >
> >
> > Thanks and HAPPY XMAS!!
> >
> > Greg
> It may sound like a stupid question but ... have you checked their
> permissions!
> If they can see the Report Manager, but not see any reports, then the
> security on the reports is too tight.
> As administrator you will be able to click on properties and security
> of the various folders and reports and add the appropriate users or
> groups.
> After that you will need to make sure the Datasources have suitable
> logon credentials set too.
> Regards (and merry christmas!)
> Chris
>|||I have what may be a similar issue. All users on our local intreanet can
view the reports, but people from the outside cannot. They can browse to
the page, and see the list of reports, but when they try to view a report,
they get "The Page cannot be Displayed".
Could this be the same as Greg's problem?
Thanks,
Daniel Williams
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:48094DE4-52C0-4522-A822-352BADD676E4@.microsoft.com...
> Hi All,
> I am having some difficulty allowing users to view reports. I have
> developed a series of reports on RS and deployed them to Report Manager.
> However It is only myself that can view the reports on report mnanager -
> whenever anyone else tries to log on and view them they get a blank page -
> what am i doing wrong?
>
> Thanks and HAPPY XMAS!!
> Greg
>|||This is different. In the current version, Report Manager uses a frame to
access the reports. You probably need to set the ReportServerExternalURL
property. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Daniel Williams" <daniel@.aniworld.com> wrote in message
news:eabjGuP7EHA.2568@.TK2MSFTNGP10.phx.gbl...
> I have what may be a similar issue. All users on our local intreanet can
> view the reports, but people from the outside cannot. They can browse to
> the page, and see the list of reports, but when they try to view a report,
> they get "The Page cannot be Displayed".
> Could this be the same as Greg's problem?
> Thanks,
> Daniel Williams
> "Greg" <Greg@.discussions.microsoft.com> wrote in message
> news:48094DE4-52C0-4522-A822-352BADD676E4@.microsoft.com...
>> Hi All,
>> I am having some difficulty allowing users to view reports. I have
>> developed a series of reports on RS and deployed them to Report Manager.
>> However It is only myself that can view the reports on report mnanager -
>> whenever anyone else tries to log on and view them they get a blank
>> page -
>> what am i doing wrong?
>>
>> Thanks and HAPPY XMAS!!
>> Greg
>|||Hi Daniel
Yes i think Brian is right - What Chris said helped me out - I had not
previously defined the permissions for my user group. Think yours may be a
separate issue.
Thanks Chris!
Greg
"Brian Welcker [MS]" wrote:
> This is different. In the current version, Report Manager uses a frame to
> access the reports. You probably need to set the ReportServerExternalURL
> property. See
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Daniel Williams" <daniel@.aniworld.com> wrote in message
> news:eabjGuP7EHA.2568@.TK2MSFTNGP10.phx.gbl...
> >
> > I have what may be a similar issue. All users on our local intreanet can
> > view the reports, but people from the outside cannot. They can browse to
> > the page, and see the list of reports, but when they try to view a report,
> > they get "The Page cannot be Displayed".
> >
> > Could this be the same as Greg's problem?
> >
> > Thanks,
> > Daniel Williams
> >
> > "Greg" <Greg@.discussions.microsoft.com> wrote in message
> > news:48094DE4-52C0-4522-A822-352BADD676E4@.microsoft.com...
> >> Hi All,
> >>
> >> I am having some difficulty allowing users to view reports. I have
> >> developed a series of reports on RS and deployed them to Report Manager.
> >> However It is only myself that can view the reports on report mnanager -
> >> whenever anyone else tries to log on and view them they get a blank
> >> page -
> >> what am i doing wrong?
> >>
> >>
> >> Thanks and HAPPY XMAS!!
> >>
> >> Greg
> >>
> >
> >
>
>|||You're right. Our problem was that we did not have a
<ReportServerExternalURL> value, so it was trying to use the internal
address when rendering the report. Completely different issue.
Cheers,
Daniel Williams
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:70AA6573-50BB-4D9F-BBE3-13E599B6673F@.microsoft.com...
> Hi Daniel
> Yes i think Brian is right - What Chris said helped me out - I had not
> previously defined the permissions for my user group. Think yours may be
> a
> separate issue.
> Thanks Chris!
> Greg
> "Brian Welcker [MS]" wrote:
>> This is different. In the current version, Report Manager uses a frame to
>> access the reports. You probably need to set the ReportServerExternalURL
>> property. See
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Daniel Williams" <daniel@.aniworld.com> wrote in message
>> news:eabjGuP7EHA.2568@.TK2MSFTNGP10.phx.gbl...
>> >
>> > I have what may be a similar issue. All users on our local intreanet
>> > can
>> > view the reports, but people from the outside cannot. They can browse
>> > to
>> > the page, and see the list of reports, but when they try to view a
>> > report,
>> > they get "The Page cannot be Displayed".
>> >
>> > Could this be the same as Greg's problem?
>> >
>> > Thanks,
>> > Daniel Williams
>> >
>> > "Greg" <Greg@.discussions.microsoft.com> wrote in message
>> > news:48094DE4-52C0-4522-A822-352BADD676E4@.microsoft.com...
>> >> Hi All,
>> >>
>> >> I am having some difficulty allowing users to view reports. I have
>> >> developed a series of reports on RS and deployed them to Report
>> >> Manager.
>> >> However It is only myself that can view the reports on report
>> >> mnanager -
>> >> whenever anyone else tries to log on and view them they get a blank
>> >> page -
>> >> what am i doing wrong?
>> >>
>> >>
>> >> Thanks and HAPPY XMAS!!
>> >>
>> >> Greg
>> >>
>> >
>> >
>>sql

Deploying too many reports causes error in report manager

sql reporting services (sp2)
windows 2003 server
Sql 200 sp4
all on one server (iis & sql server)
I have about 30 reports which I deploy from my local environment to our
reporting server. If I deploy about 10 of the reports everything is fine,
all reports deployed work. However, the more reports I deploy I notice the
slower the report manager screen takes to load. After I deploy about 15 of
my reports I will eventually get an error on report manager screen:
There is an error in XML document (1, 4078)
I have tried to deploy differnent reports to see if it is a specific report
that may be causing this, but this does not seem to be the case.
Any help with this would be greatly appreciated, as I am out of ideas and
resources to figure this out.
Regards,
Troygensx100 wrote:
> sql reporting services (sp2)
> windows 2003 server
> Sql 200 sp4
> all on one server (iis & sql server)
> I have about 30 reports which I deploy from my local environment to our
> reporting server. If I deploy about 10 of the reports everything is fine,
> all reports deployed work. However, the more reports I deploy I notice the
> slower the report manager screen takes to load. After I deploy about 15 of
> my reports I will eventually get an error on report manager screen:
> There is an error in XML document (1, 4078)
> I have tried to deploy differnent reports to see if it is a specific report
> that may be causing this, but this does not seem to be the case.
> Any help with this would be greatly appreciated, as I am out of ideas and
> resources to figure this out.
> Regards,
> Troy
sounds strange ,30 reports not a lot at all .|||gensx100 wrote:
> sql reporting services (sp2)
> windows 2003 server
> Sql 200 sp4
> all on one server (iis & sql server)
> I have about 30 reports which I deploy from my local environment to our
> reporting server. If I deploy about 10 of the reports everything is fine,
> all reports deployed work. However, the more reports I deploy I notice the
> slower the report manager screen takes to load. After I deploy about 15 of
> my reports I will eventually get an error on report manager screen:
> There is an error in XML document (1, 4078)
> I have tried to deploy differnent reports to see if it is a specific report
> that may be causing this, but this does not seem to be the case.
> Any help with this would be greatly appreciated, as I am out of ideas and
> resources to figure this out.
> Regards,
> Troy
Troy, i may test your reports in your environment just
to verify nothing is really wrong with them, if you
wish.
We have our own tool to deploy reports, so this could
be useful - to deploy them at once but slightly
another way...
I just need your .rdls to do so.
Let me know.
Cheers

Deploying to Report Manager error

I have created a report using SSRS 2005. It uses a stored procedure. It executes beautifully when I'm in reporting services. But, when I deploy it to Report Manager, this is the error I am getting.

An error has occurred during report processing.
Query execution failed for data set 'DataSource1'.
An MDX Statement was expected. An MDX expression was specified.

I have 3 parameters in this report. Start Date, End Date & Region. Region is a drop down that contains 2 options. This is a string field being passed into the procedure. Start and end dates are just basic date fields.

I am not using a cube to get my data.

I have deployed to the Report Manager before and have been successful.

Thanks!

With a name like DataSource1 I'm assuming this is a test environment. It's probable that in a previous test a shared data source (connecting to MSAS) with the same name was deployed to the server.

In you report project, make sure that in the deployment properties you have the "Overwrite Data Sources" option set to true. I suspect that when you deploy, only the report is being uploaded and not the new data source that it's using

Deploying reports to remote location

i am new in report service development.
currently I deployed reports on development server by vs.net.
I also aware about how to use report manager to deploy reports on server.
but both approaches need access to report server.
But now i have to deploy them on production server where i am not having
access.
Client ask us for some sort of setup program so that they can deploy them.
How can i do this.These is reporting webservice available at
http://<machine_name>/reportserver/reportservice.asmx
There are some functions provided by this webservice like CreateReport(),
which can be used for publishing reports. You will be required to write a
custom DLL to accomplish this and call the DLL from a setup program
Let me know if you have further queries
Bye
Sumit Pilankar
"vibha" <vibha@.discussions.microsoft.com> wrote in message
news:BD205062-FD5E-4C71-AAD4-D966428D668A@.microsoft.com...
>i am new in report service development.
> currently I deployed reports on development server by vs.net.
> I also aware about how to use report manager to deploy reports on server.
> but both approaches need access to report server.
> But now i have to deploy them on production server where i am not having
> access.
> Client ask us for some sort of setup program so that they can deploy them.
> How can i do this.

Deploying Reports to a different Environment

I am developing some reports and the only way I can deploy the reports to
the production server is via files on a CD.
The project manager would like to encapsulate everything into an .MSI file
for deployment.
Is there any documentation on whether this can be done? or how to go about
deploying reports when all I have is a bunch of files
Thanks
BobYou can deploy using RM from VS or through scripts. Best way for you is to
create scripts and put it in a batch file.
Amarnath,MCTS
"Bob" wrote:
> I am developing some reports and the only way I can deploy the reports to
> the production server is via files on a CD.
> The project manager would like to encapsulate everything into an .MSI file
> for deployment.
> Is there any documentation on whether this can be done? or how to go about
> deploying reports when all I have is a bunch of files
> Thanks
> Bob
>
>

Deploying report into a folder

Hello,

I deploy my report through deploy command in the menu. If I create a folder in the report manager how can deploy my report into the folder?

Thanks,

Go to Project Prperties in that you have to type in the newly createdfolder name in the 'TargetFolder' also check the TargetServerURL.
This would solve your issue.

deploying packages

Error: 0xC0202009 at Package, Connection manager "Presup Dev sql_prov": An OLE DB error has occurred. Error code: 0x80040E4D.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Communication link failure".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "TCP Provider: Se ha forzado la interrupción de una conexión existente por el host remoto.

WTF? ·%$·&$%%& i`m sure my connections are ok,, cause i prevoiusly checked them, the problem occurs when deploying the package.. it seems to be an error when connecting to the source but whyy?, and what about the package configurations ? should i use them,, and how?

Does the error message occur while you 'deploy' them or when you try to execute them after deployment. I am assuming 'deploy' at the least means they are now on another computer from where you created the package. Did you modify the package property 'protectionlevel' before you deployed? If not the default value may be causing your issues and you will want to read about the protectionlevel property in books online.

Hope that helps.

|||

in my solution proyect works fine.. so i have the deployment utility folder, then i copy it to the target computer, the error appears when i'm using the wizard to deploy it.. i`ve changed the protection level and it remains the same error... which is the correct option?

sorry if my english sucks..

|||

apparently i′ve found a possible solution.. in the project properties on the security tab.. i stablished a package password, then skept the prevalidation of the package during the deployment, once in my target server i run the package giving the password package and bingo!!! it worked.. i don`t know if this is the most viable solution but it worked anyway.. please can anybody tell me if this is the best option?

deploy shared data source

I have modified a shared data source and when I deployed it, the data source
on the Report Manager page did not change. I then deleted the data source
from the Report Manager and redeployed the data source. Then the reports
errored with a data source not found error, so I redeployed the entire
project, but now, even thought the shared data source is in it's original
location all of my reports (50) say that The shared data source reference is
no longer valid. I have redeployed my project again with the same results.
Any help would be appreciatedAre you doing this with RS 2000 or RS 2005?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Robert Willhite" <RobertWillhite@.discussions.microsoft.com> wrote in
message news:2D8DD698-0E6A-463F-92B2-86EF2BE3C2D0@.microsoft.com...
>I have modified a shared data source and when I deployed it, the data
>source
> on the Report Manager page did not change. I then deleted the data source
> from the Report Manager and redeployed the data source. Then the reports
> errored with a data source not found error, so I redeployed the entire
> project, but now, even thought the shared data source is in it's original
> location all of my reports (50) say that The shared data source reference
> is
> no longer valid. I have redeployed my project again with the same
> results.
> Any help would be appreciated
>|||I am doing this with RS 2000
"Bruce L-C [MVP]" wrote:
> Are you doing this with RS 2000 or RS 2005?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Robert Willhite" <RobertWillhite@.discussions.microsoft.com> wrote in
> message news:2D8DD698-0E6A-463F-92B2-86EF2BE3C2D0@.microsoft.com...
> >I have modified a shared data source and when I deployed it, the data
> >source
> > on the Report Manager page did not change. I then deleted the data source
> > from the Report Manager and redeployed the data source. Then the reports
> > errored with a data source not found error, so I redeployed the entire
> > project, but now, even thought the shared data source is in it's original
> > location all of my reports (50) say that The shared data source reference
> > is
> > no longer valid. I have redeployed my project again with the same
> > results.
> >
> > Any help would be appreciated
> >
>
>|||First, so you can understand what happened along the way. When you deploy
the default is that the shared datasource does not overwrite. The reason is
so you can have a shared data source when developing that points to a
development database and then when deployed the datasource points to
production. So deleting and deploying again works (you can also force the
deploy to overwrite but I have never done that). Usually when re-deploying a
datasource the issue that comes up are the credentials. In report manager
open up the data source and make sure the credentials are correct.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Robert Willhite" <RobertWillhite@.discussions.microsoft.com> wrote in
message news:34B4224C-6043-4527-83B3-D216414B1A9B@.microsoft.com...
>I am doing this with RS 2000
> "Bruce L-C [MVP]" wrote:
>> Are you doing this with RS 2000 or RS 2005?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Robert Willhite" <RobertWillhite@.discussions.microsoft.com> wrote in
>> message news:2D8DD698-0E6A-463F-92B2-86EF2BE3C2D0@.microsoft.com...
>> >I have modified a shared data source and when I deployed it, the data
>> >source
>> > on the Report Manager page did not change. I then deleted the data
>> > source
>> > from the Report Manager and redeployed the data source. Then the
>> > reports
>> > errored with a data source not found error, so I redeployed the entire
>> > project, but now, even thought the shared data source is in it's
>> > original
>> > location all of my reports (50) say that The shared data source
>> > reference
>> > is
>> > no longer valid. I have redeployed my project again with the same
>> > results.
>> >
>> > Any help would be appreciated
>> >
>>

deploy reports directly into right folders

hi,
is it possible to deploy an report directly to a folder from the
business intellegence studio?
or can I only move reports via the Report Manager?
Thanks!Hi,
Create a folder in the Report Manager and specify the folder name and
target url in the project properties.
This automatically move the reports to the desired folder when u deploy
that report.
Thanks.
florian wrote:
> hi,
> is it possible to deploy an report directly to a folder from the
> business intellegence studio?
> or can I only move reports via the Report Manager?
> Thanks!|||but what if I have a project with several reports belonging to
different folders?
Sara schrieb:
> Hi,
> Create a folder in the Report Manager and specify the folder name and
> target url in the project properties.
> This automatically move the reports to the desired folder when u deploy
> that report.
> Thanks.
> florian wrote:
> > hi,
> >
> > is it possible to deploy an report directly to a folder from the
> > business intellegence studio?
> >
> > or can I only move reports via the Report Manager?
> >
> > Thanks!|||Yeah, that's what I want to know. I have the same thing, one project with 10
reports in it. 3 of the reports go in their own folder.
I guess you could argue that because the reports have their own folder in
the UI that they should have their own project. But then that raises the
issue of having to duplicate your shared data sources. As of yet I have not
found a way to share data sources across projects withing the same solution
in VS.Net 2003.
"florian" wrote:
> but what if I have a project with several reports belonging to
> different folders?
> Sara schrieb:
> > Hi,
> > Create a folder in the Report Manager and specify the folder name and
> > target url in the project properties.
> >
> > This automatically move the reports to the desired folder when u deploy
> > that report.
> >
> > Thanks.
> > florian wrote:
> > > hi,
> > >
> > > is it possible to deploy an report directly to a folder from the
> > > business intellegence studio?
> > >
> > > or can I only move reports via the Report Manager?
> > >
> > > Thanks!
>

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
> > >
> >
> >
>

Dependencies

In Enterprise Manager (EM), how does it arrive at
the dependencies for a table?
The reason I am asking is, before I add additional
columns to a table, under "objects dependent on
<tablename>", it shows tables, procedures, triggers, etc.
After I add columns to this table, it shows only tables
but nothing else.
What could be the reason? What I may be doing wrong?
How can I relink everything?
Thank you,
Kelly
To learn what EM does, run a profiler trace. You will probably find that EM calls a number of stored
procedures. So, you can read the source code for those stored procedures to determine whether you should
consider this a bug and possibly open a case with MS Support.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kelly" <anonymous@.discussions.microsoft.com> wrote in message news:1cb6901c4532d$bcccab20$a301280a@.phx.gbl...
> In Enterprise Manager (EM), how does it arrive at
> the dependencies for a table?
> The reason I am asking is, before I add additional
> columns to a table, under "objects dependent on
> <tablename>", it shows tables, procedures, triggers, etc.
> After I add columns to this table, it shows only tables
> but nothing else.
> What could be the reason? What I may be doing wrong?
> How can I relink everything?
> Thank you,
> Kelly
|||Depending on the nature of the table changes EM may create a new table, copy the data, and drop the original table. This process causes the dependency records to be lost. The dependency records can be restored by dropping and creating all the dependent
objects in the proper sequence, or by...
Two of the SQL Server Tools applications have an option to restore dependency records automatically. WT2 and WT3 implement that feature in the same way, but then they diverge into different functionality. You can learn more at this URL...
http://www.sqlservertools.us
"Kelly" wrote:

> In Enterprise Manager (EM), how does it arrive at
> the dependencies for a table?
> The reason I am asking is, before I add additional
> columns to a table, under "objects dependent on
> <tablename>", it shows tables, procedures, triggers, etc.
> After I add columns to this table, it shows only tables
> but nothing else.
> What could be the reason? What I may be doing wrong?
> How can I relink everything?
> Thank you,
> Kelly
>
|||Tibor,
Thanks for your input.
-Kelly

>--Original Message--
>To learn what EM does, run a profiler trace. You will
probably find that EM calls a number of stored
>procedures. So, you can read the source code for those
stored procedures to determine whether you should
>consider this a bug and possibly open a case with MS
Support.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Kelly" <anonymous@.discussions.microsoft.com> wrote in
message news:1cb6901c4532d$bcccab20$a301280a@.phx.gbl...[vbcol=seagreen]
etc.
>
>.
>
|||Thanks for the information.
-Kelly
>--Original Message--
>Depending on the nature of the table changes EM may
create a new table, copy the data, and drop the original
table. This process causes the dependency records to be
lost. The dependency records can be restored by dropping
and creating all the dependent objects in the proper
sequence, or by...
>Two of the SQL Server Tools applications have an option
to restore dependency records automatically. WT2 and WT3
implement that feature in the same way, but then they
diverge into different functionality. You can learn more
at this URL...[vbcol=seagreen]
>http://www.sqlservertools.us
>"Kelly" wrote:
etc.
>.
>

Dependencies

In Enterprise Manager (EM), how does it arrive at
the dependencies for a table?
The reason I am asking is, before I add additional
columns to a table, under "objects dependent on
<tablename>", it shows tables, procedures, triggers, etc.
After I add columns to this table, it shows only tables
but nothing else.
What could be the reason? What I may be doing wrong?
How can I relink everything?
Thank you,
KellyTo learn what EM does, run a profiler trace. You will probably find that EM
calls a number of stored
procedures. So, you can read the source code for those stored procedures to
determine whether you should
consider this a bug and possibly open a case with MS Support.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kelly" <anonymous@.discussions.microsoft.com> wrote in message news:1cb6901c4532d$bcccab20$a
301280a@.phx.gbl...
> In Enterprise Manager (EM), how does it arrive at
> the dependencies for a table?
> The reason I am asking is, before I add additional
> columns to a table, under "objects dependent on
> <tablename>", it shows tables, procedures, triggers, etc.
> After I add columns to this table, it shows only tables
> but nothing else.
> What could be the reason? What I may be doing wrong?
> How can I relink everything?
> Thank you,
> Kelly|||Depending on the nature of the table changes EM may create a new table, copy
the data, and drop the original table. This process causes the dependency
records to be lost. The dependency records can be restored by dropping and
creating all the dependent
objects in the proper sequence, or by...
Two of the SQL Server Tools applications have an option to restore dependenc
y records automatically. WT2 and WT3 implement that feature in the same way
, but then they diverge into different functionality. You can learn more at
this URL...
http://www.sqlservertools.us
"Kelly" wrote:

> In Enterprise Manager (EM), how does it arrive at
> the dependencies for a table?
> The reason I am asking is, before I add additional
> columns to a table, under "objects dependent on
> <tablename>", it shows tables, procedures, triggers, etc.
> After I add columns to this table, it shows only tables
> but nothing else.
> What could be the reason? What I may be doing wrong?
> How can I relink everything?
> Thank you,
> Kelly
>|||Tibor,
Thanks for your input.
-Kelly

>--Original Message--
>To learn what EM does, run a profiler trace. You will
probably find that EM calls a number of stored
>procedures. So, you can read the source code for those
stored procedures to determine whether you should
>consider this a bug and possibly open a case with MS
Support.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Kelly" <anonymous@.discussions.microsoft.com> wrote in
message news:1cb6901c4532d$bcccab20$a301280a@.phx
.gbl...
etc.[vbcol=seagreen]
>
>.
>|||Thanks for the information.
-Kelly
>--Original Message--
>Depending on the nature of the table changes EM may
create a new table, copy the data, and drop the original
table. This process causes the dependency records to be
lost. The dependency records can be restored by dropping
and creating all the dependent objects in the proper
sequence, or by...
>Two of the SQL Server Tools applications have an option
to restore dependency records automatically. WT2 and WT3
implement that feature in the same way, but then they
diverge into different functionality. You can learn more
at this URL...
>http://www.sqlservertools.us
>"Kelly" wrote:
>
etc.[vbcol=seagreen]
>.
>

Dependencies

In Enterprise Manager (EM), how does it arrive at
the dependencies for a table?
The reason I am asking is, before I add additional
columns to a table, under "objects dependent on
<tablename>", it shows tables, procedures, triggers, etc.
After I add columns to this table, it shows only tables
but nothing else.
What could be the reason? What I may be doing wrong?
How can I relink everything?
Thank you,
KellyTo learn what EM does, run a profiler trace. You will probably find that EM calls a number of stored
procedures. So, you can read the source code for those stored procedures to determine whether you should
consider this a bug and possibly open a case with MS Support.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kelly" <anonymous@.discussions.microsoft.com> wrote in message news:1cb6901c4532d$bcccab20$a301280a@.phx.gbl...
> In Enterprise Manager (EM), how does it arrive at
> the dependencies for a table?
> The reason I am asking is, before I add additional
> columns to a table, under "objects dependent on
> <tablename>", it shows tables, procedures, triggers, etc.
> After I add columns to this table, it shows only tables
> but nothing else.
> What could be the reason? What I may be doing wrong?
> How can I relink everything?
> Thank you,
> Kelly|||Depending on the nature of the table changes EM may create a new table, copy the data, and drop the original table. This process causes the dependency records to be lost. The dependency records can be restored by dropping and creating all the dependent objects in the proper sequence, or by...
Two of the SQL Server Tools applications have an option to restore dependency records automatically. WT2 and WT3 implement that feature in the same way, but then they diverge into different functionality. You can learn more at this URL...
http://www.sqlservertools.us
"Kelly" wrote:
> In Enterprise Manager (EM), how does it arrive at
> the dependencies for a table?
> The reason I am asking is, before I add additional
> columns to a table, under "objects dependent on
> <tablename>", it shows tables, procedures, triggers, etc.
> After I add columns to this table, it shows only tables
> but nothing else.
> What could be the reason? What I may be doing wrong?
> How can I relink everything?
> Thank you,
> Kelly
>|||Tibor,
Thanks for your input.
-Kelly
>--Original Message--
>To learn what EM does, run a profiler trace. You will
probably find that EM calls a number of stored
>procedures. So, you can read the source code for those
stored procedures to determine whether you should
>consider this a bug and possibly open a case with MS
Support.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Kelly" <anonymous@.discussions.microsoft.com> wrote in
message news:1cb6901c4532d$bcccab20$a301280a@.phx.gbl...
>> In Enterprise Manager (EM), how does it arrive at
>> the dependencies for a table?
>> The reason I am asking is, before I add additional
>> columns to a table, under "objects dependent on
>> <tablename>", it shows tables, procedures, triggers,
etc.
>> After I add columns to this table, it shows only tables
>> but nothing else.
>> What could be the reason? What I may be doing wrong?
>> How can I relink everything?
>> Thank you,
>> Kelly
>
>.
>|||Thanks for the information.
-Kelly
>--Original Message--
>Depending on the nature of the table changes EM may
create a new table, copy the data, and drop the original
table. This process causes the dependency records to be
lost. The dependency records can be restored by dropping
and creating all the dependent objects in the proper
sequence, or by...
>Two of the SQL Server Tools applications have an option
to restore dependency records automatically. WT2 and WT3
implement that feature in the same way, but then they
diverge into different functionality. You can learn more
at this URL...
>http://www.sqlservertools.us
>"Kelly" wrote:
>> In Enterprise Manager (EM), how does it arrive at
>> the dependencies for a table?
>> The reason I am asking is, before I add additional
>> columns to a table, under "objects dependent on
>> <tablename>", it shows tables, procedures, triggers,
etc.
>> After I add columns to this table, it shows only tables
>> but nothing else.
>> What could be the reason? What I may be doing wrong?
>> How can I relink everything?
>> Thank you,
>> Kelly
>.
>