Hi I'm very new in this area so please be patience...
We run windows server 2003 and SQL 2005 and Reportservices.
We have build several reports which we can see on
http://localhost/Reports/Pages/Folder.aspx
However if we deploy these report to a webpage using the option inVisual
Studio,
Project/"project name/Properties then we get and error.
"connection couldn't be established Url//name.
If we try to add teh following link on the page of our websit we get the
message.
"this page couldn't be found"
What kind of setting/option/path should we follow to get this established?On Jul 4, 3:14 am, SQL-Herbie <SQLHer...@.discussions.microsoft.com>
wrote:
> Hi I'm very new in this area so please be patience...
> We run windows server 2003 and SQL 2005 and Reportservices.
> We have build several reports which we can see onhttp://localhost/Reports/Pages/Folder.aspx
> However if we deploy these report to a webpage using the option inVisual
> Studio,
> Project/"project name/Properties then we get and error.
> "connection couldn't be established Url//name.
> If we try to add teh following link on the page of our websit we get the
> message.
> "this page couldn't be found"
> What kind of setting/option/path should we follow to get this established?
Traditionally, I like to deploy reports to other servers via the
Report Manager on the other server. All you would need to do is upload
the RDL file and set the datasource to an available datsource in the
Report Manager (if one exists already; otherwise, create one). Hope
this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||"EMartinez" wrote:
> On Jul 4, 3:14 am, SQL-Herbie <SQLHer...@.discussions.microsoft.com>
> wrote:
> > Hi I'm very new in this area so please be patience...
> > We run windows server 2003 and SQL 2005 and Reportservices.
> >
> > We have build several reports which we can see onhttp://localhost/Reports/Pages/Folder.aspx
> >
> > However if we deploy these report to a webpage using the option inVisual
> > Studio,
> > Project/"project name/Properties then we get and error.
> > "connection couldn't be established Url//name.
> >
> > If we try to add teh following link on the page of our websit we get the
> > message.
> > "this page couldn't be found"
> >
> > What kind of setting/option/path should we follow to get this established?
>
> Traditionally, I like to deploy reports to other servers via the
> Report Manager on the other server. All you would need to do is upload
> the RDL file and set the datasource to an available datsource in the
> Report Manager (if one exists already; otherwise, create one). Hope
> this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Sorry but what kind of tool(s) should we use to read these RDL files
Secondly we loose the functionality of the reportserver...|||On Jul 5, 1:14 am, SQL-Herbie <SQLHer...@.discussions.microsoft.com>
wrote:
> "EMartinez" wrote:
> > On Jul 4, 3:14 am, SQL-Herbie <SQLHer...@.discussions.microsoft.com>
> > wrote:
> > > Hi I'm very new in this area so please be patience...
> > > We run windows server 2003 and SQL 2005 and Reportservices.
> > > We have build several reports which we can see onhttp://localhost/Reports/Pages/Folder.aspx
> > > However if we deploy these report to a webpage using the option inVisual
> > > Studio,
> > > Project/"project name/Properties then we get and error.
> > > "connection couldn't be established Url//name.
> > > If we try to add teh following link on the page of our websit we get the
> > > message.
> > > "this page couldn't be found"
> > > What kind of setting/option/path should we follow to get this established?
> > Traditionally, I like to deploy reports to other servers via the
> > Report Manager on the other server. All you would need to do is upload
> > the RDL file and set the datasource to an available datsource in the
> > Report Manager (if one exists already; otherwise, create one). Hope
> > this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Sorry but what kind of tool(s) should we use to read these RDL files
> Secondly we loose the functionality of the reportserver...
To read the RDL file itself (non report view of course) you could use
a standard text editor (Notepad, Wordpad, Notepad++, etc). If you are
saying that you do not have SSRS/Reporting Services installed on the
machine you are deploying them to, you may run into the issue where
the reports cannot be viewed, since it requires the RS service to be
running on the machine that is hosting the reports (so to speak).
Also, you might want to look into the RS.exe utility for the command
line. Hope this helps further.
Regards,
Enrique Martinez
Sr. Software Consultant|||I think there is some communication problem going on in this thread.
The ability to deploy the report from VS is how you get a report into
Reporting Services. If you can see the reports on your server (which the
below seems to be the case) then you have already deployed the report.
What are you trying to do when you use the phrase "deploy these report to a
webpage". Are you trying to deploy to another reporting services server? Or
are you trying to view the report in your own webpage somewhere else.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SQL-Herbie" <SQLHerbie@.discussions.microsoft.com> wrote in message
news:5FB85260-24A8-4D96-8E1A-FC9E9CEE281C@.microsoft.com...
> Hi I'm very new in this area so please be patience...
> We run windows server 2003 and SQL 2005 and Reportservices.
> We have build several reports which we can see on
> http://localhost/Reports/Pages/Folder.aspx
> However if we deploy these report to a webpage using the option inVisual
> Studio,
> Project/"project name/Properties then we get and error.
> "connection couldn't be established Url//name.
> If we try to add teh following link on the page of our websit we get the
> message.
> "this page couldn't be found"
> What kind of setting/option/path should we follow to get this established?
>
Showing posts with label deploy. Show all posts
Showing posts with label deploy. Show all posts
Wednesday, March 21, 2012
Reports work, Reports Manager not
I've done a number of RS installs, this one is on a new 2003 server. I have
VS.NET on the computer and can develop and deploy successfully.
I can view the report from VS.NET preview or using IE, typing
http://localhost/ReportServer?/yada/yada
However if I want to run Reports Manager, typing http://localhost/Reports
then I get an error,
Access denied to 'C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\BIN'. Failed to start monitoring file changes.
I've changed permissions on the folder and the ReportServer service is now
started with the Admin account, no success yet.It is fixed now. This is what I did in case it can help someone in the
future.
Un-install Reporting Services.
Use Enterprise Manager to delete the 2 Reporting Services databases, the
un-install did not.
Delete the C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services
directory and sub-directories.
Install again.
"Chris Botha" <chris_s_botha@.AThotmail.com> wrote in message
news:#5EIp0$HFHA.2564@.tk2msftngp13.phx.gbl...
> I've done a number of RS installs, this one is on a new 2003 server. I
have
> VS.NET on the computer and can develop and deploy successfully.
> I can view the report from VS.NET preview or using IE, typing
> http://localhost/ReportServer?/yada/yada
> However if I want to run Reports Manager, typing http://localhost/Reports
> then I get an error,
> Access denied to 'C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\BIN'. Failed to start monitoring file changes.
> I've changed permissions on the folder and the ReportServer service is now
> started with the Admin account, no success yet.
>
VS.NET on the computer and can develop and deploy successfully.
I can view the report from VS.NET preview or using IE, typing
http://localhost/ReportServer?/yada/yada
However if I want to run Reports Manager, typing http://localhost/Reports
then I get an error,
Access denied to 'C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\BIN'. Failed to start monitoring file changes.
I've changed permissions on the folder and the ReportServer service is now
started with the Admin account, no success yet.It is fixed now. This is what I did in case it can help someone in the
future.
Un-install Reporting Services.
Use Enterprise Manager to delete the 2 Reporting Services databases, the
un-install did not.
Delete the C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services
directory and sub-directories.
Install again.
"Chris Botha" <chris_s_botha@.AThotmail.com> wrote in message
news:#5EIp0$HFHA.2564@.tk2msftngp13.phx.gbl...
> I've done a number of RS installs, this one is on a new 2003 server. I
have
> VS.NET on the computer and can develop and deploy successfully.
> I can view the report from VS.NET preview or using IE, typing
> http://localhost/ReportServer?/yada/yada
> However if I want to run Reports Manager, typing http://localhost/Reports
> then I get an error,
> Access denied to 'C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\BIN'. Failed to start monitoring file changes.
> I've changed permissions on the folder and the ReportServer service is now
> started with the Admin account, no success yet.
>
Reports Won't Deploy
I'm stuck, any ideas? Is this a version or sp issue or a connection problem?
SQL Server 2005, Report Server Version: 9.00.1399.00 Visual Studio 2005.
All my service and accounts are set up fine, I can manually upload a report
and data source to the report server, but VS 2005 will not deploy when the
web server is set in the TargetServerURL property.
The error I get is
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://phxdb02/Reports.
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version.
(Microsoft.ReportingServices.Designer)
The request failed with HTTP status 404: Not Found.
(Microsoft.ReportingServices.Designer)You need to specify the ReportServer web service endpoint not the Report
Manager url e.g. in your Project Properties for the TargetServerURL specify
http://phxdb02/ReportServer
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:EDDFC084-0623-4FE2-B742-2AAA52D2E3ED@.microsoft.com...
> I'm stuck, any ideas? Is this a version or sp issue or a connection
> problem?
> SQL Server 2005, Report Server Version: 9.00.1399.00 Visual Studio 2005.
> All my service and accounts are set up fine, I can manually upload a
> report
> and data source to the report server, but VS 2005 will not deploy when the
> web server is set in the TargetServerURL property.
> The error I get is
> TITLE: Microsoft Report Designer
> A connection could not be made to the report server
> http://phxdb02/Reports.
> ADDITIONAL INFORMATION:
> The attempt to connect to the report server failed. Check your connection
> information and that the report server is a compatible version.
> (Microsoft.ReportingServices.Designer)
> The request failed with HTTP status 404: Not Found.
> (Microsoft.ReportingServices.Designer)
>|||Perfect! Thank you, that was it!!!
"Jasper Smith" wrote:
> You need to specify the ReportServer web service endpoint not the Report
> Manager url e.g. in your Project Properties for the TargetServerURL specify
> http://phxdb02/ReportServer
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
> "Scott" <Scott@.discussions.microsoft.com> wrote in message
> news:EDDFC084-0623-4FE2-B742-2AAA52D2E3ED@.microsoft.com...
> > I'm stuck, any ideas? Is this a version or sp issue or a connection
> > problem?
> >
> > SQL Server 2005, Report Server Version: 9.00.1399.00 Visual Studio 2005.
> > All my service and accounts are set up fine, I can manually upload a
> > report
> > and data source to the report server, but VS 2005 will not deploy when the
> > web server is set in the TargetServerURL property.
> >
> > The error I get is
> >
> > TITLE: Microsoft Report Designer
> >
> > A connection could not be made to the report server
> > http://phxdb02/Reports.
> >
> > ADDITIONAL INFORMATION:
> >
> > The attempt to connect to the report server failed. Check your connection
> > information and that the report server is a compatible version.
> > (Microsoft.ReportingServices.Designer)
> >
> > The request failed with HTTP status 404: Not Found.
> > (Microsoft.ReportingServices.Designer)
> >
>
>
SQL Server 2005, Report Server Version: 9.00.1399.00 Visual Studio 2005.
All my service and accounts are set up fine, I can manually upload a report
and data source to the report server, but VS 2005 will not deploy when the
web server is set in the TargetServerURL property.
The error I get is
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://phxdb02/Reports.
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version.
(Microsoft.ReportingServices.Designer)
The request failed with HTTP status 404: Not Found.
(Microsoft.ReportingServices.Designer)You need to specify the ReportServer web service endpoint not the Report
Manager url e.g. in your Project Properties for the TargetServerURL specify
http://phxdb02/ReportServer
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:EDDFC084-0623-4FE2-B742-2AAA52D2E3ED@.microsoft.com...
> I'm stuck, any ideas? Is this a version or sp issue or a connection
> problem?
> SQL Server 2005, Report Server Version: 9.00.1399.00 Visual Studio 2005.
> All my service and accounts are set up fine, I can manually upload a
> report
> and data source to the report server, but VS 2005 will not deploy when the
> web server is set in the TargetServerURL property.
> The error I get is
> TITLE: Microsoft Report Designer
> A connection could not be made to the report server
> http://phxdb02/Reports.
> ADDITIONAL INFORMATION:
> The attempt to connect to the report server failed. Check your connection
> information and that the report server is a compatible version.
> (Microsoft.ReportingServices.Designer)
> The request failed with HTTP status 404: Not Found.
> (Microsoft.ReportingServices.Designer)
>|||Perfect! Thank you, that was it!!!
"Jasper Smith" wrote:
> You need to specify the ReportServer web service endpoint not the Report
> Manager url e.g. in your Project Properties for the TargetServerURL specify
> http://phxdb02/ReportServer
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
> "Scott" <Scott@.discussions.microsoft.com> wrote in message
> news:EDDFC084-0623-4FE2-B742-2AAA52D2E3ED@.microsoft.com...
> > I'm stuck, any ideas? Is this a version or sp issue or a connection
> > problem?
> >
> > SQL Server 2005, Report Server Version: 9.00.1399.00 Visual Studio 2005.
> > All my service and accounts are set up fine, I can manually upload a
> > report
> > and data source to the report server, but VS 2005 will not deploy when the
> > web server is set in the TargetServerURL property.
> >
> > The error I get is
> >
> > TITLE: Microsoft Report Designer
> >
> > A connection could not be made to the report server
> > http://phxdb02/Reports.
> >
> > ADDITIONAL INFORMATION:
> >
> > The attempt to connect to the report server failed. Check your connection
> > information and that the report server is a compatible version.
> > (Microsoft.ReportingServices.Designer)
> >
> > The request failed with HTTP status 404: Not Found.
> > (Microsoft.ReportingServices.Designer)
> >
>
>
reports without sql server
Hi,
I wanna know if it's possible to deploy reports to a production environment
where sql server is completely not needed? Maybe only some reporting service
components that can be installed for the report generation?
I know this question has been asked before, but I just can't find a
definitive answer. Some say it can, others say it can't.Anyone that says it can does not know what they are talking about. For this
version you have to have Reporting Services server and the server requires
SQL Server. Now, SQL Server does not have to be on the same box, it can
reside on another box but SQL Server is used by Reporting Services and is a
requirement.
Version 2 will have some webform and winform controls. These controls will
use RS if present but can work without it. If this is the case, though, then
you don't have Report Manager (i.e. you have to create your own web pages to
get parameters and call the reports).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Servé La" <blabla@.bestaatniet.nl> wrote in message
news:%231VVIjZ8EHA.3700@.tk2msftngp13.phx.gbl...
> Hi,
> I wanna know if it's possible to deploy reports to a production
environment
> where sql server is completely not needed? Maybe only some reporting
service
> components that can be installed for the report generation?
> I know this question has been asked before, but I just can't find a
> definitive answer. Some say it can, others say it can't.
>|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schreef in bericht
news:%233UydPa8EHA.3368@.TK2MSFTNGP10.phx.gbl...
> Anyone that says it can does not know what they are talking about. For
this
> version you have to have Reporting Services server and the server requires
> SQL Server. Now, SQL Server does not have to be on the same box, it can
> reside on another box but SQL Server is used by Reporting Services and is
a
> requirement.
> Version 2 will have some webform and winform controls. These controls will
> use RS if present but can work without it. If this is the case, though,
then
> you don't have Report Manager (i.e. you have to create your own web pages
to
> get parameters and call the reports).
Ok thank yousql
I wanna know if it's possible to deploy reports to a production environment
where sql server is completely not needed? Maybe only some reporting service
components that can be installed for the report generation?
I know this question has been asked before, but I just can't find a
definitive answer. Some say it can, others say it can't.Anyone that says it can does not know what they are talking about. For this
version you have to have Reporting Services server and the server requires
SQL Server. Now, SQL Server does not have to be on the same box, it can
reside on another box but SQL Server is used by Reporting Services and is a
requirement.
Version 2 will have some webform and winform controls. These controls will
use RS if present but can work without it. If this is the case, though, then
you don't have Report Manager (i.e. you have to create your own web pages to
get parameters and call the reports).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Servé La" <blabla@.bestaatniet.nl> wrote in message
news:%231VVIjZ8EHA.3700@.tk2msftngp13.phx.gbl...
> Hi,
> I wanna know if it's possible to deploy reports to a production
environment
> where sql server is completely not needed? Maybe only some reporting
service
> components that can be installed for the report generation?
> I know this question has been asked before, but I just can't find a
> definitive answer. Some say it can, others say it can't.
>|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schreef in bericht
news:%233UydPa8EHA.3368@.TK2MSFTNGP10.phx.gbl...
> Anyone that says it can does not know what they are talking about. For
this
> version you have to have Reporting Services server and the server requires
> SQL Server. Now, SQL Server does not have to be on the same box, it can
> reside on another box but SQL Server is used by Reporting Services and is
a
> requirement.
> Version 2 will have some webform and winform controls. These controls will
> use RS if present but can work without it. If this is the case, though,
then
> you don't have Report Manager (i.e. you have to create your own web pages
to
> get parameters and call the reports).
Ok thank yousql
Tuesday, March 20, 2012
Reports running much slower on SQL Express Edition of Reporting Services...
We have a SQL Server 2005 application that we deploy most of the time on SQL
Express, not full blown SQL. We have a Development box here (2 CPU XEON
with 4GB RAM) that has the Developer Edition and an instance of SQL Express
installed. If I run the same reports, with the same data, but one on the
developer edition and one on the Express Edition, there is a SIGNIFICANT
performance difference. This is a 1-page report - nothing huge, and it
renders in 2-3 seconds on Developer edition, but consistantly takes 15-20
seconds on the Express Edition.
I know SQL Express has a 1GB RAM limit, and a 1-CPU limit, but are there any
settings or anything that I can do to bring this closer to the full blown
SQL Version. This performance killing me onsite...
Any thoughts?
Thanks,
Markhave you identify if the problem is related to RS or SQL?
Does the SQL query is slower on the express edition? or the query takes the
same amount of time?
if the difference is here, then you have to play in the query and the
indexes to optimize it for the Express edition.
"Mark Essex" <messex@.netalytics.com> wrote in message
news:eyZTzG35HHA.980@.TK2MSFTNGP06.phx.gbl...
> We have a SQL Server 2005 application that we deploy most of the time on
> SQL Express, not full blown SQL. We have a Development box here (2 CPU
> XEON with 4GB RAM) that has the Developer Edition and an instance of SQL
> Express installed. If I run the same reports, with the same data, but one
> on the developer edition and one on the Express Edition, there is a
> SIGNIFICANT performance difference. This is a 1-page report - nothing
> huge, and it renders in 2-3 seconds on Developer edition, but consistantly
> takes 15-20 seconds on the Express Edition.
> I know SQL Express has a 1GB RAM limit, and a 1-CPU limit, but are there
> any settings or anything that I can do to bring this closer to the full
> blown SQL Version. This performance killing me onsite...
> Any thoughts?
> Thanks,
> Mark
>|||The query is 'instant' (less than a second) on both SQL Instances, so I
would say that this is an RS issue, not a SQL issue.
"Jeje" <willgart@.hotmail.com> wrote in message
news:2645D59B-223F-4F18-9712-AFF641F24C77@.microsoft.com...
> have you identify if the problem is related to RS or SQL?
> Does the SQL query is slower on the express edition? or the query takes
> the same amount of time?
> if the difference is here, then you have to play in the query and the
> indexes to optimize it for the Express edition.
>
> "Mark Essex" <messex@.netalytics.com> wrote in message
> news:eyZTzG35HHA.980@.TK2MSFTNGP06.phx.gbl...
>> We have a SQL Server 2005 application that we deploy most of the time on
>> SQL Express, not full blown SQL. We have a Development box here (2 CPU
>> XEON with 4GB RAM) that has the Developer Edition and an instance of SQL
>> Express installed. If I run the same reports, with the same data, but
>> one on the developer edition and one on the Express Edition, there is a
>> SIGNIFICANT performance difference. This is a 1-page report - nothing
>> huge, and it renders in 2-3 seconds on Developer edition, but
>> consistantly takes 15-20 seconds on the Express Edition.
>> I know SQL Express has a 1GB RAM limit, and a 1-CPU limit, but are there
>> any settings or anything that I can do to bring this closer to the full
>> blown SQL Version. This performance killing me onsite...
>> Any thoughts?
>> Thanks,
>> Mark
>>|||what is the connection string used by the report?
and does RS and SQL are on the same server?
"Mark Essex" <messex@.netalytics.com> wrote in message
news:eoyjDAJ6HHA.4880@.TK2MSFTNGP03.phx.gbl...
> The query is 'instant' (less than a second) on both SQL Instances, so I
> would say that this is an RS issue, not a SQL issue.
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:2645D59B-223F-4F18-9712-AFF641F24C77@.microsoft.com...
>> have you identify if the problem is related to RS or SQL?
>> Does the SQL query is slower on the express edition? or the query takes
>> the same amount of time?
>> if the difference is here, then you have to play in the query and the
>> indexes to optimize it for the Express edition.
>>
>> "Mark Essex" <messex@.netalytics.com> wrote in message
>> news:eyZTzG35HHA.980@.TK2MSFTNGP06.phx.gbl...
>> We have a SQL Server 2005 application that we deploy most of the time on
>> SQL Express, not full blown SQL. We have a Development box here (2 CPU
>> XEON with 4GB RAM) that has the Developer Edition and an instance of SQL
>> Express installed. If I run the same reports, with the same data, but
>> one on the developer edition and one on the Express Edition, there is a
>> SIGNIFICANT performance difference. This is a 1-page report - nothing
>> huge, and it renders in 2-3 seconds on Developer edition, but
>> consistantly takes 15-20 seconds on the Express Edition.
>> I know SQL Express has a 1GB RAM limit, and a 1-CPU limit, but are there
>> any settings or anything that I can do to bring this closer to the full
>> blown SQL Version. This performance killing me onsite...
>> Any thoughts?
>> Thanks,
>> Mark
>>
>|||COnnection string looks like:
data source=.\installs; initial catalog = Methasoft53
RS and SQL are on the same machine.
Would the '.\installs' cause issues, meaning should I put the MACHINE NAME
in there, instead of using the 'dot' notation? Maybe a 'lookup' time issue?
Thanks,
Mark
"Jeje" <willgart@.hotmail.com> wrote in message
news:6C308FB1-6A82-440F-9746-8BED264C9313@.microsoft.com...
> what is the connection string used by the report?
> and does RS and SQL are on the same server?
> "Mark Essex" <messex@.netalytics.com> wrote in message
> news:eoyjDAJ6HHA.4880@.TK2MSFTNGP03.phx.gbl...
>> The query is 'instant' (less than a second) on both SQL Instances, so I
>> would say that this is an RS issue, not a SQL issue.
>> "Jeje" <willgart@.hotmail.com> wrote in message
>> news:2645D59B-223F-4F18-9712-AFF641F24C77@.microsoft.com...
>> have you identify if the problem is related to RS or SQL?
>> Does the SQL query is slower on the express edition? or the query takes
>> the same amount of time?
>> if the difference is here, then you have to play in the query and the
>> indexes to optimize it for the Express edition.
>>
>> "Mark Essex" <messex@.netalytics.com> wrote in message
>> news:eyZTzG35HHA.980@.TK2MSFTNGP06.phx.gbl...
>> We have a SQL Server 2005 application that we deploy most of the time
>> on SQL Express, not full blown SQL. We have a Development box here (2
>> CPU XEON with 4GB RAM) that has the Developer Edition and an instance
>> of SQL Express installed. If I run the same reports, with the same
>> data, but one on the developer edition and one on the Express Edition,
>> there is a SIGNIFICANT performance difference. This is a 1-page
>> report - nothing huge, and it renders in 2-3 seconds on Developer
>> edition, but consistantly takes 15-20 seconds on the Express Edition.
>> I know SQL Express has a 1GB RAM limit, and a 1-CPU limit, but are
>> there any settings or anything that I can do to bring this closer to
>> the full blown SQL Version. This performance killing me onsite...
>> Any thoughts?
>> Thanks,
>> Mark
>>
>>|||to see if there is a naming resolution issue, open the profiler on your
server, then run the report.
if you see the query 10 seconds after you click "view report", then there is
a name resolution issue. if you see the query in less then 1second, then
there is no naming issue and the problem is somewhere else.
but using the . (dot) should not cause name resolution issue.
but maybe there is an authentication issue.
try to use an SQL Server login instead of the windows authentication
data source=.\installs; initial catalog =Methasoft53;uid=<user>;pwd=<password>
"Mark Essex" <messex@.netalytics.com> wrote in message
news:Oqg98Rp6HHA.4584@.TK2MSFTNGP03.phx.gbl...
> COnnection string looks like:
> data source=.\installs; initial catalog = Methasoft53
> RS and SQL are on the same machine.
> Would the '.\installs' cause issues, meaning should I put the MACHINE NAME
> in there, instead of using the 'dot' notation? Maybe a 'lookup' time
> issue?
> Thanks,
> Mark
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:6C308FB1-6A82-440F-9746-8BED264C9313@.microsoft.com...
>> what is the connection string used by the report?
>> and does RS and SQL are on the same server?
>> "Mark Essex" <messex@.netalytics.com> wrote in message
>> news:eoyjDAJ6HHA.4880@.TK2MSFTNGP03.phx.gbl...
>> The query is 'instant' (less than a second) on both SQL Instances, so I
>> would say that this is an RS issue, not a SQL issue.
>> "Jeje" <willgart@.hotmail.com> wrote in message
>> news:2645D59B-223F-4F18-9712-AFF641F24C77@.microsoft.com...
>> have you identify if the problem is related to RS or SQL?
>> Does the SQL query is slower on the express edition? or the query takes
>> the same amount of time?
>> if the difference is here, then you have to play in the query and the
>> indexes to optimize it for the Express edition.
>>
>> "Mark Essex" <messex@.netalytics.com> wrote in message
>> news:eyZTzG35HHA.980@.TK2MSFTNGP06.phx.gbl...
>> We have a SQL Server 2005 application that we deploy most of the time
>> on SQL Express, not full blown SQL. We have a Development box here (2
>> CPU XEON with 4GB RAM) that has the Developer Edition and an instance
>> of SQL Express installed. If I run the same reports, with the same
>> data, but one on the developer edition and one on the Express Edition,
>> there is a SIGNIFICANT performance difference. This is a 1-page
>> report - nothing huge, and it renders in 2-3 seconds on Developer
>> edition, but consistantly takes 15-20 seconds on the Express Edition.
>> I know SQL Express has a 1GB RAM limit, and a 1-CPU limit, but are
>> there any settings or anything that I can do to bring this closer to
>> the full blown SQL Version. This performance killing me onsite...
>> Any thoughts?
>> Thanks,
>> Mark
>>
>>
>
Express, not full blown SQL. We have a Development box here (2 CPU XEON
with 4GB RAM) that has the Developer Edition and an instance of SQL Express
installed. If I run the same reports, with the same data, but one on the
developer edition and one on the Express Edition, there is a SIGNIFICANT
performance difference. This is a 1-page report - nothing huge, and it
renders in 2-3 seconds on Developer edition, but consistantly takes 15-20
seconds on the Express Edition.
I know SQL Express has a 1GB RAM limit, and a 1-CPU limit, but are there any
settings or anything that I can do to bring this closer to the full blown
SQL Version. This performance killing me onsite...
Any thoughts?
Thanks,
Markhave you identify if the problem is related to RS or SQL?
Does the SQL query is slower on the express edition? or the query takes the
same amount of time?
if the difference is here, then you have to play in the query and the
indexes to optimize it for the Express edition.
"Mark Essex" <messex@.netalytics.com> wrote in message
news:eyZTzG35HHA.980@.TK2MSFTNGP06.phx.gbl...
> We have a SQL Server 2005 application that we deploy most of the time on
> SQL Express, not full blown SQL. We have a Development box here (2 CPU
> XEON with 4GB RAM) that has the Developer Edition and an instance of SQL
> Express installed. If I run the same reports, with the same data, but one
> on the developer edition and one on the Express Edition, there is a
> SIGNIFICANT performance difference. This is a 1-page report - nothing
> huge, and it renders in 2-3 seconds on Developer edition, but consistantly
> takes 15-20 seconds on the Express Edition.
> I know SQL Express has a 1GB RAM limit, and a 1-CPU limit, but are there
> any settings or anything that I can do to bring this closer to the full
> blown SQL Version. This performance killing me onsite...
> Any thoughts?
> Thanks,
> Mark
>|||The query is 'instant' (less than a second) on both SQL Instances, so I
would say that this is an RS issue, not a SQL issue.
"Jeje" <willgart@.hotmail.com> wrote in message
news:2645D59B-223F-4F18-9712-AFF641F24C77@.microsoft.com...
> have you identify if the problem is related to RS or SQL?
> Does the SQL query is slower on the express edition? or the query takes
> the same amount of time?
> if the difference is here, then you have to play in the query and the
> indexes to optimize it for the Express edition.
>
> "Mark Essex" <messex@.netalytics.com> wrote in message
> news:eyZTzG35HHA.980@.TK2MSFTNGP06.phx.gbl...
>> We have a SQL Server 2005 application that we deploy most of the time on
>> SQL Express, not full blown SQL. We have a Development box here (2 CPU
>> XEON with 4GB RAM) that has the Developer Edition and an instance of SQL
>> Express installed. If I run the same reports, with the same data, but
>> one on the developer edition and one on the Express Edition, there is a
>> SIGNIFICANT performance difference. This is a 1-page report - nothing
>> huge, and it renders in 2-3 seconds on Developer edition, but
>> consistantly takes 15-20 seconds on the Express Edition.
>> I know SQL Express has a 1GB RAM limit, and a 1-CPU limit, but are there
>> any settings or anything that I can do to bring this closer to the full
>> blown SQL Version. This performance killing me onsite...
>> Any thoughts?
>> Thanks,
>> Mark
>>|||what is the connection string used by the report?
and does RS and SQL are on the same server?
"Mark Essex" <messex@.netalytics.com> wrote in message
news:eoyjDAJ6HHA.4880@.TK2MSFTNGP03.phx.gbl...
> The query is 'instant' (less than a second) on both SQL Instances, so I
> would say that this is an RS issue, not a SQL issue.
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:2645D59B-223F-4F18-9712-AFF641F24C77@.microsoft.com...
>> have you identify if the problem is related to RS or SQL?
>> Does the SQL query is slower on the express edition? or the query takes
>> the same amount of time?
>> if the difference is here, then you have to play in the query and the
>> indexes to optimize it for the Express edition.
>>
>> "Mark Essex" <messex@.netalytics.com> wrote in message
>> news:eyZTzG35HHA.980@.TK2MSFTNGP06.phx.gbl...
>> We have a SQL Server 2005 application that we deploy most of the time on
>> SQL Express, not full blown SQL. We have a Development box here (2 CPU
>> XEON with 4GB RAM) that has the Developer Edition and an instance of SQL
>> Express installed. If I run the same reports, with the same data, but
>> one on the developer edition and one on the Express Edition, there is a
>> SIGNIFICANT performance difference. This is a 1-page report - nothing
>> huge, and it renders in 2-3 seconds on Developer edition, but
>> consistantly takes 15-20 seconds on the Express Edition.
>> I know SQL Express has a 1GB RAM limit, and a 1-CPU limit, but are there
>> any settings or anything that I can do to bring this closer to the full
>> blown SQL Version. This performance killing me onsite...
>> Any thoughts?
>> Thanks,
>> Mark
>>
>|||COnnection string looks like:
data source=.\installs; initial catalog = Methasoft53
RS and SQL are on the same machine.
Would the '.\installs' cause issues, meaning should I put the MACHINE NAME
in there, instead of using the 'dot' notation? Maybe a 'lookup' time issue?
Thanks,
Mark
"Jeje" <willgart@.hotmail.com> wrote in message
news:6C308FB1-6A82-440F-9746-8BED264C9313@.microsoft.com...
> what is the connection string used by the report?
> and does RS and SQL are on the same server?
> "Mark Essex" <messex@.netalytics.com> wrote in message
> news:eoyjDAJ6HHA.4880@.TK2MSFTNGP03.phx.gbl...
>> The query is 'instant' (less than a second) on both SQL Instances, so I
>> would say that this is an RS issue, not a SQL issue.
>> "Jeje" <willgart@.hotmail.com> wrote in message
>> news:2645D59B-223F-4F18-9712-AFF641F24C77@.microsoft.com...
>> have you identify if the problem is related to RS or SQL?
>> Does the SQL query is slower on the express edition? or the query takes
>> the same amount of time?
>> if the difference is here, then you have to play in the query and the
>> indexes to optimize it for the Express edition.
>>
>> "Mark Essex" <messex@.netalytics.com> wrote in message
>> news:eyZTzG35HHA.980@.TK2MSFTNGP06.phx.gbl...
>> We have a SQL Server 2005 application that we deploy most of the time
>> on SQL Express, not full blown SQL. We have a Development box here (2
>> CPU XEON with 4GB RAM) that has the Developer Edition and an instance
>> of SQL Express installed. If I run the same reports, with the same
>> data, but one on the developer edition and one on the Express Edition,
>> there is a SIGNIFICANT performance difference. This is a 1-page
>> report - nothing huge, and it renders in 2-3 seconds on Developer
>> edition, but consistantly takes 15-20 seconds on the Express Edition.
>> I know SQL Express has a 1GB RAM limit, and a 1-CPU limit, but are
>> there any settings or anything that I can do to bring this closer to
>> the full blown SQL Version. This performance killing me onsite...
>> Any thoughts?
>> Thanks,
>> Mark
>>
>>|||to see if there is a naming resolution issue, open the profiler on your
server, then run the report.
if you see the query 10 seconds after you click "view report", then there is
a name resolution issue. if you see the query in less then 1second, then
there is no naming issue and the problem is somewhere else.
but using the . (dot) should not cause name resolution issue.
but maybe there is an authentication issue.
try to use an SQL Server login instead of the windows authentication
data source=.\installs; initial catalog =Methasoft53;uid=<user>;pwd=<password>
"Mark Essex" <messex@.netalytics.com> wrote in message
news:Oqg98Rp6HHA.4584@.TK2MSFTNGP03.phx.gbl...
> COnnection string looks like:
> data source=.\installs; initial catalog = Methasoft53
> RS and SQL are on the same machine.
> Would the '.\installs' cause issues, meaning should I put the MACHINE NAME
> in there, instead of using the 'dot' notation? Maybe a 'lookup' time
> issue?
> Thanks,
> Mark
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:6C308FB1-6A82-440F-9746-8BED264C9313@.microsoft.com...
>> what is the connection string used by the report?
>> and does RS and SQL are on the same server?
>> "Mark Essex" <messex@.netalytics.com> wrote in message
>> news:eoyjDAJ6HHA.4880@.TK2MSFTNGP03.phx.gbl...
>> The query is 'instant' (less than a second) on both SQL Instances, so I
>> would say that this is an RS issue, not a SQL issue.
>> "Jeje" <willgart@.hotmail.com> wrote in message
>> news:2645D59B-223F-4F18-9712-AFF641F24C77@.microsoft.com...
>> have you identify if the problem is related to RS or SQL?
>> Does the SQL query is slower on the express edition? or the query takes
>> the same amount of time?
>> if the difference is here, then you have to play in the query and the
>> indexes to optimize it for the Express edition.
>>
>> "Mark Essex" <messex@.netalytics.com> wrote in message
>> news:eyZTzG35HHA.980@.TK2MSFTNGP06.phx.gbl...
>> We have a SQL Server 2005 application that we deploy most of the time
>> on SQL Express, not full blown SQL. We have a Development box here (2
>> CPU XEON with 4GB RAM) that has the Developer Edition and an instance
>> of SQL Express installed. If I run the same reports, with the same
>> data, but one on the developer edition and one on the Express Edition,
>> there is a SIGNIFICANT performance difference. This is a 1-page
>> report - nothing huge, and it renders in 2-3 seconds on Developer
>> edition, but consistantly takes 15-20 seconds on the Express Edition.
>> I know SQL Express has a 1GB RAM limit, and a 1-CPU limit, but are
>> there any settings or anything that I can do to bring this closer to
>> the full blown SQL Version. This performance killing me onsite...
>> Any thoughts?
>> Thanks,
>> Mark
>>
>>
>
Reports on Web farm-Please reply
Hi
We are planning to deploy SQL Server reports on our Internet site which is a
web farm of Windows 2003 web edition servers. We have total 9 boxes in our
Internet web farm and they sit in DMZ spread onto multiple locations. Our
dev/qa environment is inside our network and here are my questions:
1. Does the SQL Server database being used by our Internet servers has to be
in same DMZ domain or can it sit inside out network and then we can pass all
the db transactions back to database inside network? I read somewhere that RS
and SQL Server DB have to be on same domain to work. Is this correct?
2. Also I would like to know how we can deploy all the reports from our
internal dev/qa environment onto our Internet boxes on a continuous basis. I
guess I will have to setup report services on each box and then use some
scripting to move over the required files over to all 9 boxes. Is this
correct assumption? Do we need to copy some files onto each web servers or if
they are talking to same database then the moment we update the db, changes
will be reflected across all web farm sites? Is there any online resource
which describes this whole thing?
Please note that I am not SQL DBA and have just started using SQL Server
reports.
--
ThanksIf you are deploying over the internet then you need to use forms based
authentication and my understanding (but I am hazy on this so don't consider
the answer definitive) is the issue with domains will not matter.
I can answer your second question more definitively than the first. If you
look at a server and look for any rdl files you will not find any. When you
deploy you are not copying files. Deployment is the process where the
reports get stored in the object store for Reporting Services (i.e. in the
database). The whole point of a web farm is they all point to a single
database for the object store and they all see the same reports, report
cache, subscriptions, etc. As far as how you deploy, you can deploy from
your dev machines or you can copy the rdl files over someplace else and then
you scripting to deploy them. An example of how to do this ships with the
product (I always just deploy from the dev environment so I have no ever
scripted this but I know it is possible).
Note for a web farm you have to be running enterprise edition of SQL Server.
Also you need an enterprise edition license for each server in the web farm.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"tiwanap" <tiwanap@.discussions.microsoft.com> wrote in message
news:5A5A9C26-2106-4E25-9BC6-6E52000ED2CB@.microsoft.com...
> Hi
> We are planning to deploy SQL Server reports on our Internet site which is
> a
> web farm of Windows 2003 web edition servers. We have total 9 boxes in our
> Internet web farm and they sit in DMZ spread onto multiple locations. Our
> dev/qa environment is inside our network and here are my questions:
> 1. Does the SQL Server database being used by our Internet servers has to
> be
> in same DMZ domain or can it sit inside out network and then we can pass
> all
> the db transactions back to database inside network? I read somewhere that
> RS
> and SQL Server DB have to be on same domain to work. Is this correct?
> 2. Also I would like to know how we can deploy all the reports from our
> internal dev/qa environment onto our Internet boxes on a continuous basis.
> I
> guess I will have to setup report services on each box and then use some
> scripting to move over the required files over to all 9 boxes. Is this
> correct assumption? Do we need to copy some files onto each web servers or
> if
> they are talking to same database then the moment we update the db,
> changes
> will be reflected across all web farm sites? Is there any online resource
> which describes this whole thing?
> Please note that I am not SQL DBA and have just started using SQL Server
> reports.
> --
> Thanks
We are planning to deploy SQL Server reports on our Internet site which is a
web farm of Windows 2003 web edition servers. We have total 9 boxes in our
Internet web farm and they sit in DMZ spread onto multiple locations. Our
dev/qa environment is inside our network and here are my questions:
1. Does the SQL Server database being used by our Internet servers has to be
in same DMZ domain or can it sit inside out network and then we can pass all
the db transactions back to database inside network? I read somewhere that RS
and SQL Server DB have to be on same domain to work. Is this correct?
2. Also I would like to know how we can deploy all the reports from our
internal dev/qa environment onto our Internet boxes on a continuous basis. I
guess I will have to setup report services on each box and then use some
scripting to move over the required files over to all 9 boxes. Is this
correct assumption? Do we need to copy some files onto each web servers or if
they are talking to same database then the moment we update the db, changes
will be reflected across all web farm sites? Is there any online resource
which describes this whole thing?
Please note that I am not SQL DBA and have just started using SQL Server
reports.
--
ThanksIf you are deploying over the internet then you need to use forms based
authentication and my understanding (but I am hazy on this so don't consider
the answer definitive) is the issue with domains will not matter.
I can answer your second question more definitively than the first. If you
look at a server and look for any rdl files you will not find any. When you
deploy you are not copying files. Deployment is the process where the
reports get stored in the object store for Reporting Services (i.e. in the
database). The whole point of a web farm is they all point to a single
database for the object store and they all see the same reports, report
cache, subscriptions, etc. As far as how you deploy, you can deploy from
your dev machines or you can copy the rdl files over someplace else and then
you scripting to deploy them. An example of how to do this ships with the
product (I always just deploy from the dev environment so I have no ever
scripted this but I know it is possible).
Note for a web farm you have to be running enterprise edition of SQL Server.
Also you need an enterprise edition license for each server in the web farm.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"tiwanap" <tiwanap@.discussions.microsoft.com> wrote in message
news:5A5A9C26-2106-4E25-9BC6-6E52000ED2CB@.microsoft.com...
> Hi
> We are planning to deploy SQL Server reports on our Internet site which is
> a
> web farm of Windows 2003 web edition servers. We have total 9 boxes in our
> Internet web farm and they sit in DMZ spread onto multiple locations. Our
> dev/qa environment is inside our network and here are my questions:
> 1. Does the SQL Server database being used by our Internet servers has to
> be
> in same DMZ domain or can it sit inside out network and then we can pass
> all
> the db transactions back to database inside network? I read somewhere that
> RS
> and SQL Server DB have to be on same domain to work. Is this correct?
> 2. Also I would like to know how we can deploy all the reports from our
> internal dev/qa environment onto our Internet boxes on a continuous basis.
> I
> guess I will have to setup report services on each box and then use some
> scripting to move over the required files over to all 9 boxes. Is this
> correct assumption? Do we need to copy some files onto each web servers or
> if
> they are talking to same database then the moment we update the db,
> changes
> will be reflected across all web farm sites? Is there any online resource
> which describes this whole thing?
> Please note that I am not SQL DBA and have just started using SQL Server
> reports.
> --
> Thanks
Monday, March 12, 2012
Reports Depoyment Problem
I have a shared datasource already installed on the ReportServer.
Later I want to deploy reports that use that datasource.
The reports are created with a shared datasource which is not the same as
the one deployed.
How can I specify the datasource programatically when I am deploying the
reports?I think a better way is to have them use the same datasource name. When you
deploy the datasource it is not overwritten. So the datasource can point to
a development database or QA database or Production database (assuming you
have three different servers) and they can all be called the same thing. You
can modify the datasource after deployment to where you want it to go. From
then on it will not be overwritten during deployment unless you explicitly
tell it to be overwritten.
Bruce L-C
"CalinV" <CalinV@.discussions.microsoft.com> wrote in message
news:D912BB4E-C3D4-4A78-883C-06DAC33A8BD6@.microsoft.com...
> I have a shared datasource already installed on the ReportServer.
> Later I want to deploy reports that use that datasource.
> The reports are created with a shared datasource which is not the same as
> the one deployed.
> How can I specify the datasource programatically when I am deploying the
> reports?
>|||Take a look at the SetReportDataSources [1] SOAP API method.
[1]
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_ref_soapapi_service_lz_3x88.asp
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"CalinV" <CalinV@.discussions.microsoft.com> wrote in message
news:D912BB4E-C3D4-4A78-883C-06DAC33A8BD6@.microsoft.com...
> I have a shared datasource already installed on the ReportServer.
> Later I want to deploy reports that use that datasource.
> The reports are created with a shared datasource which is not the same as
> the one deployed.
> How can I specify the datasource programatically when I am deploying the
> reports?
>
Later I want to deploy reports that use that datasource.
The reports are created with a shared datasource which is not the same as
the one deployed.
How can I specify the datasource programatically when I am deploying the
reports?I think a better way is to have them use the same datasource name. When you
deploy the datasource it is not overwritten. So the datasource can point to
a development database or QA database or Production database (assuming you
have three different servers) and they can all be called the same thing. You
can modify the datasource after deployment to where you want it to go. From
then on it will not be overwritten during deployment unless you explicitly
tell it to be overwritten.
Bruce L-C
"CalinV" <CalinV@.discussions.microsoft.com> wrote in message
news:D912BB4E-C3D4-4A78-883C-06DAC33A8BD6@.microsoft.com...
> I have a shared datasource already installed on the ReportServer.
> Later I want to deploy reports that use that datasource.
> The reports are created with a shared datasource which is not the same as
> the one deployed.
> How can I specify the datasource programatically when I am deploying the
> reports?
>|||Take a look at the SetReportDataSources [1] SOAP API method.
[1]
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_ref_soapapi_service_lz_3x88.asp
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"CalinV" <CalinV@.discussions.microsoft.com> wrote in message
news:D912BB4E-C3D4-4A78-883C-06DAC33A8BD6@.microsoft.com...
> I have a shared datasource already installed on the ReportServer.
> Later I want to deploy reports that use that datasource.
> The reports are created with a shared datasource which is not the same as
> the one deployed.
> How can I specify the datasource programatically when I am deploying the
> reports?
>
Reports deployment
Our production environment sits on a different domain, behind a firewall. We
need to deploy our reports to our production server, but can't deploy to the
other domain. Also we are avoiding putting VS .NET on the production server
by not installing the Report Designer.
So, I was thinking we could deploy the reports to CD to get them to the
production domain. This is our first foray with RS.. is there an
article/resource where we can learn more about what specific files we need to
deploy?
thx,
JanYou have two options. One is to put your rds and rdl files onto a CD and go
to a PC in the other domain that has Report Designer on it and use that to
deploy to the server. Note that Report Designer does not need to be on the
server. Your other choice is to write a deployment script/app that takes and
deploys your reports. Note that deployment is not copying files. Report
Server is putting the reports into the database. No rdl files exist on your
server. SOAP (web services) are used by the Report Designer to deploy and
you can do the same thing.
What is the reason you can't deploy to your server, that it is on another
domain? I would think that deploying to another domain should be possible.
Search this newsgroup with deploy as the subject and you will find a variety
of posts. In particular Teo mentions creating a script. Another one talks
about deploying to a server in another domain.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jan" <Jan@.discussions.microsoft.com> wrote in message
news:B0F23AB4-F114-4111-819C-AA52BC50F729@.microsoft.com...
> Our production environment sits on a different domain, behind a firewall.
We
> need to deploy our reports to our production server, but can't deploy to
the
> other domain. Also we are avoiding putting VS .NET on the production
server
> by not installing the Report Designer.
> So, I was thinking we could deploy the reports to CD to get them to the
> production domain. This is our first foray with RS.. is there an
> article/resource where we can learn more about what specific files we need
to
> deploy?
> thx,
> Jan|||Thanks Bruce, that is a big help.
It would be possible to deploy across domains if our security dept permitted
it. Our production domain is locked down with very limited access for
security reasons.
"Bruce L-C [MVP]" wrote:
> You have two options. One is to put your rds and rdl files onto a CD and go
> to a PC in the other domain that has Report Designer on it and use that to
> deploy to the server. Note that Report Designer does not need to be on the
> server. Your other choice is to write a deployment script/app that takes and
> deploys your reports. Note that deployment is not copying files. Report
> Server is putting the reports into the database. No rdl files exist on your
> server. SOAP (web services) are used by the Report Designer to deploy and
> you can do the same thing.
> What is the reason you can't deploy to your server, that it is on another
> domain? I would think that deploying to another domain should be possible.
> Search this newsgroup with deploy as the subject and you will find a variety
> of posts. In particular Teo mentions creating a script. Another one talks
> about deploying to a server in another domain.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jan" <Jan@.discussions.microsoft.com> wrote in message
> news:B0F23AB4-F114-4111-819C-AA52BC50F729@.microsoft.com...
> > Our production environment sits on a different domain, behind a firewall.
> We
> > need to deploy our reports to our production server, but can't deploy to
> the
> > other domain. Also we are avoiding putting VS .NET on the production
> server
> > by not installing the Report Designer.
> >
> > So, I was thinking we could deploy the reports to CD to get them to the
> > production domain. This is our first foray with RS.. is there an
> > article/resource where we can learn more about what specific files we need
> to
> > deploy?
> >
> > thx,
> > Jan
>
>
need to deploy our reports to our production server, but can't deploy to the
other domain. Also we are avoiding putting VS .NET on the production server
by not installing the Report Designer.
So, I was thinking we could deploy the reports to CD to get them to the
production domain. This is our first foray with RS.. is there an
article/resource where we can learn more about what specific files we need to
deploy?
thx,
JanYou have two options. One is to put your rds and rdl files onto a CD and go
to a PC in the other domain that has Report Designer on it and use that to
deploy to the server. Note that Report Designer does not need to be on the
server. Your other choice is to write a deployment script/app that takes and
deploys your reports. Note that deployment is not copying files. Report
Server is putting the reports into the database. No rdl files exist on your
server. SOAP (web services) are used by the Report Designer to deploy and
you can do the same thing.
What is the reason you can't deploy to your server, that it is on another
domain? I would think that deploying to another domain should be possible.
Search this newsgroup with deploy as the subject and you will find a variety
of posts. In particular Teo mentions creating a script. Another one talks
about deploying to a server in another domain.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jan" <Jan@.discussions.microsoft.com> wrote in message
news:B0F23AB4-F114-4111-819C-AA52BC50F729@.microsoft.com...
> Our production environment sits on a different domain, behind a firewall.
We
> need to deploy our reports to our production server, but can't deploy to
the
> other domain. Also we are avoiding putting VS .NET on the production
server
> by not installing the Report Designer.
> So, I was thinking we could deploy the reports to CD to get them to the
> production domain. This is our first foray with RS.. is there an
> article/resource where we can learn more about what specific files we need
to
> deploy?
> thx,
> Jan|||Thanks Bruce, that is a big help.
It would be possible to deploy across domains if our security dept permitted
it. Our production domain is locked down with very limited access for
security reasons.
"Bruce L-C [MVP]" wrote:
> You have two options. One is to put your rds and rdl files onto a CD and go
> to a PC in the other domain that has Report Designer on it and use that to
> deploy to the server. Note that Report Designer does not need to be on the
> server. Your other choice is to write a deployment script/app that takes and
> deploys your reports. Note that deployment is not copying files. Report
> Server is putting the reports into the database. No rdl files exist on your
> server. SOAP (web services) are used by the Report Designer to deploy and
> you can do the same thing.
> What is the reason you can't deploy to your server, that it is on another
> domain? I would think that deploying to another domain should be possible.
> Search this newsgroup with deploy as the subject and you will find a variety
> of posts. In particular Teo mentions creating a script. Another one talks
> about deploying to a server in another domain.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jan" <Jan@.discussions.microsoft.com> wrote in message
> news:B0F23AB4-F114-4111-819C-AA52BC50F729@.microsoft.com...
> > Our production environment sits on a different domain, behind a firewall.
> We
> > need to deploy our reports to our production server, but can't deploy to
> the
> > other domain. Also we are avoiding putting VS .NET on the production
> server
> > by not installing the Report Designer.
> >
> > So, I was thinking we could deploy the reports to CD to get them to the
> > production domain. This is our first foray with RS.. is there an
> > article/resource where we can learn more about what specific files we need
> to
> > deploy?
> >
> > thx,
> > Jan
>
>
Labels:
database,
deploy,
deployment,
domain,
environment,
firewall,
microsoft,
mysql,
oracle,
production,
reports,
server,
sits,
sql
Reports Deploy.
Hi,
I have my report test environment in a LAN and the production
environment in another LAN in another country. The production
environment doesn't have Visual Studio.
I want to know if there's another way to deploy reports in Report
Server without to use the Visual Studio. Or, can I to deploy from my
machine with Visual Studio to Report Server in another LAN'
Thanks in advance.You could use Reporting Services Scripter (link below) to script out your
reports then they just need to run the generated batch file to load your
reports. Thet will just need RS.EXE from the client tools to be able to run
the generated sripts
http://www.sqldbatips.com/showarticle.asp?ID=62
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Gave" <vasgabriel@.gmail.com> wrote in message
news:1137169868.545497.262050@.g43g2000cwa.googlegroups.com...
> Hi,
> I have my report test environment in a LAN and the production
> environment in another LAN in another country. The production
> environment doesn't have Visual Studio.
> I want to know if there's another way to deploy reports in Report
> Server without to use the Visual Studio. Or, can I to deploy from my
> machine with Visual Studio to Report Server in another LAN'
> Thanks in advance.
>|||Jasper, Thanks for response.
I download the Reporting Services Scripter and I get the following
error:
The request failed with the error message:
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a
href='/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportService.asmx'>here</a>.</h2>
</body></html>
I'm using Reporting Services with Form Authentication instead of
Windows Authentication.
Can you help me please?
Thanks a lot.|||Sorry, there's currently no support for Forms Authentication, the reason
being that RS.EXE doesn't support it and being that's the mechanism used to
deploy the scripts, it seems silly to allow the generation of scripts that
can't be run. Hopefully at a future date there will be support for non
windows authentication using RS>EXE at which time I'll add it to RSScripter.
Sorry it can't help you.
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Gave" <vasgabriel@.gmail.com> wrote in message
news:1137178511.255692.202680@.g47g2000cwa.googlegroups.com...
> Jasper, Thanks for response.
> I download the Reporting Services Scripter and I get the following
> error:
> The request failed with the error message:
> <html><head><title>Object moved</title></head><body>
> <h2>Object moved to <a
> href='/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportService.asmx'>here</a>.</h2>
> </body></html>
> I'm using Reporting Services with Form Authentication instead of
> Windows Authentication.
> Can you help me please?
> Thanks a lot.
>
I have my report test environment in a LAN and the production
environment in another LAN in another country. The production
environment doesn't have Visual Studio.
I want to know if there's another way to deploy reports in Report
Server without to use the Visual Studio. Or, can I to deploy from my
machine with Visual Studio to Report Server in another LAN'
Thanks in advance.You could use Reporting Services Scripter (link below) to script out your
reports then they just need to run the generated batch file to load your
reports. Thet will just need RS.EXE from the client tools to be able to run
the generated sripts
http://www.sqldbatips.com/showarticle.asp?ID=62
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Gave" <vasgabriel@.gmail.com> wrote in message
news:1137169868.545497.262050@.g43g2000cwa.googlegroups.com...
> Hi,
> I have my report test environment in a LAN and the production
> environment in another LAN in another country. The production
> environment doesn't have Visual Studio.
> I want to know if there's another way to deploy reports in Report
> Server without to use the Visual Studio. Or, can I to deploy from my
> machine with Visual Studio to Report Server in another LAN'
> Thanks in advance.
>|||Jasper, Thanks for response.
I download the Reporting Services Scripter and I get the following
error:
The request failed with the error message:
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a
href='/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportService.asmx'>here</a>.</h2>
</body></html>
I'm using Reporting Services with Form Authentication instead of
Windows Authentication.
Can you help me please?
Thanks a lot.|||Sorry, there's currently no support for Forms Authentication, the reason
being that RS.EXE doesn't support it and being that's the mechanism used to
deploy the scripts, it seems silly to allow the generation of scripts that
can't be run. Hopefully at a future date there will be support for non
windows authentication using RS>EXE at which time I'll add it to RSScripter.
Sorry it can't help you.
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Gave" <vasgabriel@.gmail.com> wrote in message
news:1137178511.255692.202680@.g47g2000cwa.googlegroups.com...
> Jasper, Thanks for response.
> I download the Reporting Services Scripter and I get the following
> error:
> The request failed with the error message:
> <html><head><title>Object moved</title></head><body>
> <h2>Object moved to <a
> href='/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportService.asmx'>here</a>.</h2>
> </body></html>
> I'm using Reporting Services with Form Authentication instead of
> Windows Authentication.
> Can you help me please?
> Thanks a lot.
>
Saturday, February 25, 2012
Reporting Test Web Environment
Has anyone come up with a way to deploy reports to a test environment without
purchasing a new server and a second copy of Reporting Services? I would
like to have second website with a copy of our live site for testing purposes
but we don't have the resources or the demand to warrant a second server.
There's nothing that I can find in the RS documentation to create a second
instance. I tried making a new virtual web in IIS and copying the files to
the web's underlying file structure but that did not work.
Any advice or guidance would be greatly appreciated.http://msdn2.microsoft.com/en-us/library/ms403426.aspx
"Stuart" <Stuart@.discussions.microsoft.com> wrote in message
news:4995111C-5CDE-439A-A1F0-9B75D44EBBF7@.microsoft.com...
> Has anyone come up with a way to deploy reports to a test environment
> without
> purchasing a new server and a second copy of Reporting Services? I would
> like to have second website with a copy of our live site for testing
> purposes
> but we don't have the resources or the demand to warrant a second server.
> There's nothing that I can find in the RS documentation to create a second
> instance. I tried making a new virtual web in IIS and copying the files
> to
> the web's underlying file structure but that did not work.
> Any advice or guidance would be greatly appreciated.|||Thanks!
"Immy" wrote:
> http://msdn2.microsoft.com/en-us/library/ms403426.aspx
> "Stuart" <Stuart@.discussions.microsoft.com> wrote in message
> news:4995111C-5CDE-439A-A1F0-9B75D44EBBF7@.microsoft.com...
> > Has anyone come up with a way to deploy reports to a test environment
> > without
> > purchasing a new server and a second copy of Reporting Services? I would
> > like to have second website with a copy of our live site for testing
> > purposes
> > but we don't have the resources or the demand to warrant a second server.
> > There's nothing that I can find in the RS documentation to create a second
> > instance. I tried making a new virtual web in IIS and copying the files
> > to
> > the web's underlying file structure but that did not work.
> >
> > Any advice or guidance would be greatly appreciated.
>
>|||or can you use a SQL Server Developers edition for testing; or is it
just for development'
Stuart wrote:
> Has anyone come up with a way to deploy reports to a test environment without
> purchasing a new server and a second copy of Reporting Services? I would
> like to have second website with a copy of our live site for testing purposes
> but we don't have the resources or the demand to warrant a second server.
> There's nothing that I can find in the RS documentation to create a second
> instance. I tried making a new virtual web in IIS and copying the files to
> the web's underlying file structure but that did not work.
> Any advice or guidance would be greatly appreciated.
purchasing a new server and a second copy of Reporting Services? I would
like to have second website with a copy of our live site for testing purposes
but we don't have the resources or the demand to warrant a second server.
There's nothing that I can find in the RS documentation to create a second
instance. I tried making a new virtual web in IIS and copying the files to
the web's underlying file structure but that did not work.
Any advice or guidance would be greatly appreciated.http://msdn2.microsoft.com/en-us/library/ms403426.aspx
"Stuart" <Stuart@.discussions.microsoft.com> wrote in message
news:4995111C-5CDE-439A-A1F0-9B75D44EBBF7@.microsoft.com...
> Has anyone come up with a way to deploy reports to a test environment
> without
> purchasing a new server and a second copy of Reporting Services? I would
> like to have second website with a copy of our live site for testing
> purposes
> but we don't have the resources or the demand to warrant a second server.
> There's nothing that I can find in the RS documentation to create a second
> instance. I tried making a new virtual web in IIS and copying the files
> to
> the web's underlying file structure but that did not work.
> Any advice or guidance would be greatly appreciated.|||Thanks!
"Immy" wrote:
> http://msdn2.microsoft.com/en-us/library/ms403426.aspx
> "Stuart" <Stuart@.discussions.microsoft.com> wrote in message
> news:4995111C-5CDE-439A-A1F0-9B75D44EBBF7@.microsoft.com...
> > Has anyone come up with a way to deploy reports to a test environment
> > without
> > purchasing a new server and a second copy of Reporting Services? I would
> > like to have second website with a copy of our live site for testing
> > purposes
> > but we don't have the resources or the demand to warrant a second server.
> > There's nothing that I can find in the RS documentation to create a second
> > instance. I tried making a new virtual web in IIS and copying the files
> > to
> > the web's underlying file structure but that did not work.
> >
> > Any advice or guidance would be greatly appreciated.
>
>|||or can you use a SQL Server Developers edition for testing; or is it
just for development'
Stuart wrote:
> Has anyone come up with a way to deploy reports to a test environment without
> purchasing a new server and a second copy of Reporting Services? I would
> like to have second website with a copy of our live site for testing purposes
> but we don't have the resources or the demand to warrant a second server.
> There's nothing that I can find in the RS documentation to create a second
> instance. I tried making a new virtual web in IIS and copying the files to
> the web's underlying file structure but that did not work.
> Any advice or guidance would be greatly appreciated.
Monday, February 20, 2012
Reporting Services: I cannot deploy reports.
I am using Visual Studio 2005 and trying to deploy reports to SQL Server 2000.
I get the following message:
A connection could not be made to the report server http://aklink1/reportserver.
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed.Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)
Please help!
Hi,
The RDL files for SQL 2005 reports have changed. They are not backward compatible. Can you check the version of your Reporting Services Designer via the about box?
Greetz,
Geert
Geert Verhoeven
Consultant @. Ausy Belgium
My Personal Blog
|||Version 9.00.1399.00
|||Hi,
That's the 2005 version. You have 2 options:
upgrade the report server to 2005
Subscribe to:
Posts (Atom)