Hello,
I just installed Vault Source Control on my machine. I then opened a
Reporting Services project with rdl's in it. Every RDL that is currently in
source control opens with this error
"Deserialization failed: File or assembly name
Microsoft.ReportingServices.Interfaces, or one of its dependencies, was not
found."
If I open another instance of the MSIDE without Vault (locally) and open a
different RDL it works fine. Is this an issue with the source control or
with the way it opens the file?
Any help will be appreciated. Need to get this solved.
PonnuI think it has to do with the way the add-in is written. Some add-ins turn
on shadow-copy, which plays havoc with the report designer as our assemblies
aren't located in the VS shared location. You might be able to copy the
report designer assemlies into the IDE directory. Not sure if you can
configure the add-in not to shadow copy.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
"Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
news:uZiORNloEHA.1160@.tk2msftngp13.phx.gbl...
> Hello,
> I just installed Vault Source Control on my machine. I then opened a
> Reporting Services project with rdl's in it. Every RDL that is currently
> in
> source control opens with this error
> "Deserialization failed: File or assembly name
> Microsoft.ReportingServices.Interfaces, or one of its dependencies, was
> not
> found."
> If I open another instance of the MSIDE without Vault (locally) and open a
> different RDL it works fine. Is this an issue with the source control or
> with the way it opens the file?
> Any help will be appreciated. Need to get this solved.
> Ponnu
>
Showing posts with label reporting. Show all posts
Showing posts with label reporting. Show all posts
Thursday, March 29, 2012
Description field in Subscriptions Table
The Description field in SQL Server 2005 Reporting Services just defaults to "Send e-mail to email@.domain.com" (obviously a dummy e-mail address) when you create an e-mail subscription. You cannot edit the Description when you select "Edit" beside a subscription.
The Description may be edited directly in the Subscriptions table under the ReportServer database but this is not end-user friendly.
I thought of using an add/update trigger to set the Description to the "Subject" out of the Extension Settings field. The Extension Settings field is XML so you would have to parse the Subject out of there first. The "Subject" is the e-mail Subject for the e-mail that is sent to the subscriber and it much more adequately describes the report.
My boss understood what I wanted to do but wanted to make sure in the industry literature that the product was not that lacking. Hard to believe that you cannot directly edit the Subscription Description through the web browser interface - would love for someone to prove me wrong.
Hello,
I'm wondering why you are wanting to change the description of a subscription? The description tells you what the subscription does, "Send email to..." for emails, or "Save as..." for files.
For adding a description to the report, you could set it in the properties of the report itself.
You can change the description directly, but it is reset after the subscription is updated.
Jarret
|||Well, the reason that I want to change the Subscription Description is that I have ten of them that say the same thing - you cannot tell one from the other unless you click on edit. This is not the Report Description
What we are going to do is add a trigger that fires when an update or add takes place and we will set the description equal to the parsed subject from the Extension Settings. Well, unless someone comes up with a better idea.
Thank you very much for responding.
William
|||I have solved the problems by modifying the CreateSubscription and UpdateSubscription stored procedures so that they parse the Subject out of the ExtensionSettings column and then set the Description equal to the parsed substring.sqlSunday, March 25, 2012
Deployment: SRS2005 can use SQL2K as ReportDatabase
Can the SQL Server 2005 Reporting Services configured to use the SQL2K Server
as reporting database server?
Rationale:
So that I can put the 2005 reporting services in the DMZ and use exisitng
sql2K server behind the DMZ to store the reporting database. Another reason
is that , I don't have to buy 2 licenses (1 for the reporting services and 1
for reporting database). If I have the reporting database on the SQL2K,
exisiting license would cover that.
I am not sure whether this can be done. Can somebody throw some light on this.
Thanks,Yes it's possible to store the report server database in a sql server 2000.
look at the post "RS 2005 with SQL Server 2000" (26.09.2005)
"JDS" <JDS@.discussions.microsoft.com> schrieb im Newsbeitrag
news:F92E7419-4B02-4B8C-B63A-AFA736FA6A2F@.microsoft.com...
> Can the SQL Server 2005 Reporting Services configured to use the SQL2K
> Server
> as reporting database server?
> Rationale:
> So that I can put the 2005 reporting services in the DMZ and use exisitng
> sql2K server behind the DMZ to store the reporting database. Another
> reason
> is that , I don't have to buy 2 licenses (1 for the reporting services and
> 1
> for reporting database). If I have the reporting database on the SQL2K,
> exisiting license would cover that.
> I am not sure whether this can be done. Can somebody throw some light on
> this.
> Thanks,
>|||=?Utf-8?B?SkRT?= <JDS@.discussions.microsoft.com> wrote in
news:F92E7419-4B02-4B8C-B63A-AFA736FA6A2F@.microsoft.com:
Yes it will work BUT
You need to license SQL 2005 to use RS2005 AND since RS is not a separate
product, you need a SQL license for the computer hosting RS.
> Can the SQL Server 2005 Reporting Services configured to use the SQL2K
> Server as reporting database server?
> Rationale:
> So that I can put the 2005 reporting services in the DMZ and use
> exisitng sql2K server behind the DMZ to store the reporting database.
> Another reason is that , I don't have to buy 2 licenses (1 for the
> reporting services and 1 for reporting database). If I have the
> reporting database on the SQL2K, exisiting license would cover that.
> I am not sure whether this can be done. Can somebody throw some light
> on this.
> Thanks,
>|||Thanks Jens and Asher
"Asher_N" wrote:
> =?Utf-8?B?SkRT?= <JDS@.discussions.microsoft.com> wrote in
> news:F92E7419-4B02-4B8C-B63A-AFA736FA6A2F@.microsoft.com:
> Yes it will work BUT
> You need to license SQL 2005 to use RS2005 AND since RS is not a separate
> product, you need a SQL license for the computer hosting RS.
> > Can the SQL Server 2005 Reporting Services configured to use the SQL2K
> > Server as reporting database server?
> >
> > Rationale:
> > So that I can put the 2005 reporting services in the DMZ and use
> > exisitng sql2K server behind the DMZ to store the reporting database.
> > Another reason is that , I don't have to buy 2 licenses (1 for the
> > reporting services and 1 for reporting database). If I have the
> > reporting database on the SQL2K, exisiting license would cover that.
> >
> > I am not sure whether this can be done. Can somebody throw some light
> > on this.
> >
> > Thanks,
> >
> >
>
as reporting database server?
Rationale:
So that I can put the 2005 reporting services in the DMZ and use exisitng
sql2K server behind the DMZ to store the reporting database. Another reason
is that , I don't have to buy 2 licenses (1 for the reporting services and 1
for reporting database). If I have the reporting database on the SQL2K,
exisiting license would cover that.
I am not sure whether this can be done. Can somebody throw some light on this.
Thanks,Yes it's possible to store the report server database in a sql server 2000.
look at the post "RS 2005 with SQL Server 2000" (26.09.2005)
"JDS" <JDS@.discussions.microsoft.com> schrieb im Newsbeitrag
news:F92E7419-4B02-4B8C-B63A-AFA736FA6A2F@.microsoft.com...
> Can the SQL Server 2005 Reporting Services configured to use the SQL2K
> Server
> as reporting database server?
> Rationale:
> So that I can put the 2005 reporting services in the DMZ and use exisitng
> sql2K server behind the DMZ to store the reporting database. Another
> reason
> is that , I don't have to buy 2 licenses (1 for the reporting services and
> 1
> for reporting database). If I have the reporting database on the SQL2K,
> exisiting license would cover that.
> I am not sure whether this can be done. Can somebody throw some light on
> this.
> Thanks,
>|||=?Utf-8?B?SkRT?= <JDS@.discussions.microsoft.com> wrote in
news:F92E7419-4B02-4B8C-B63A-AFA736FA6A2F@.microsoft.com:
Yes it will work BUT
You need to license SQL 2005 to use RS2005 AND since RS is not a separate
product, you need a SQL license for the computer hosting RS.
> Can the SQL Server 2005 Reporting Services configured to use the SQL2K
> Server as reporting database server?
> Rationale:
> So that I can put the 2005 reporting services in the DMZ and use
> exisitng sql2K server behind the DMZ to store the reporting database.
> Another reason is that , I don't have to buy 2 licenses (1 for the
> reporting services and 1 for reporting database). If I have the
> reporting database on the SQL2K, exisiting license would cover that.
> I am not sure whether this can be done. Can somebody throw some light
> on this.
> Thanks,
>|||Thanks Jens and Asher
"Asher_N" wrote:
> =?Utf-8?B?SkRT?= <JDS@.discussions.microsoft.com> wrote in
> news:F92E7419-4B02-4B8C-B63A-AFA736FA6A2F@.microsoft.com:
> Yes it will work BUT
> You need to license SQL 2005 to use RS2005 AND since RS is not a separate
> product, you need a SQL license for the computer hosting RS.
> > Can the SQL Server 2005 Reporting Services configured to use the SQL2K
> > Server as reporting database server?
> >
> > Rationale:
> > So that I can put the 2005 reporting services in the DMZ and use
> > exisitng sql2K server behind the DMZ to store the reporting database.
> > Another reason is that , I don't have to buy 2 licenses (1 for the
> > reporting services and 1 for reporting database). If I have the
> > reporting database on the SQL2K, exisiting license would cover that.
> >
> > I am not sure whether this can be done. Can somebody throw some light
> > on this.
> >
> > Thanks,
> >
> >
>
Deployment with Hardware Load balancing.
I am currently planning the deployment of reporting services into a hardware
load balanced environment. The documentation from MS only covers MS's NLB
software. Has anyone had any experience deploying with a hardware load
balancer. Specifically F5 load balencing equipment.
Thanks,
Adrian.Hello Adrian,
A report server Web farm is a collection of report server instances that
share the same report server database. Reporting Services does not provide
Web farm deployment functionality. To deploy Reporting Services in a Web
farm, you can use network load balancing (NLB) functionality provided
through Windows servers, Microsoft Application Center, or third-party
software that supports Web farm deployment. The load balancer can be
software or hardware.
For the "Steps for Deploying a Report Server Web Farm", please refer to the
"Steps for Deploying a Report Server Web Farm" section in the following web
site:
Enterprise Deployment Model
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
/drp_deploying_v1_0h9e.asp
More information for reference:
Installing a Report Server Web Farm
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/h
tm/gs_installingrs_v1_2ckm.asp
305064 How To Set Up an NLB Cluster for Application Center 2000
http://support.microsoft.com/?id=305064
Regarding the information of how to implement and maintain NLB clusters, if
you use a third-party hardware load balancer, please contact the hardware
vendor support to inquire about this issue. I believe that they will assist
you best since they will have the proper material resources to resolve this
problem.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Sophie,
To confirm that I understand what you are saying, here is my take on how you
would deploy a multi node reporting server with hardware load balancing.
Note: Database tier is being deployed as active/active SQL Cluster.
1. Deploy the initial reporting services server node as per a vanilla
install.
2. Deploy any subsequent nodes by joining the nodes to the initial reporting
services node by specifying the RSWEBFARMSERVER property in the installation
3. Overlay the web nodes with either a hardware or software load balancing
solution.
Thanks,
Adrian.
"Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> wrote in message
news:Tu9WDs$QFHA.3704@.TK2MSFTNGXA02.phx.gbl...
> Hello Adrian,
> A report server Web farm is a collection of report server instances that
> share the same report server database. Reporting Services does not provide
> Web farm deployment functionality. To deploy Reporting Services in a Web
> farm, you can use network load balancing (NLB) functionality provided
> through Windows servers, Microsoft Application Center, or third-party
> software that supports Web farm deployment. The load balancer can be
> software or hardware.
> For the "Steps for Deploying a Report Server Web Farm", please refer to
> the
> "Steps for Deploying a Report Server Web Farm" section in the following
> web
> site:
> Enterprise Deployment Model
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
> /drp_deploying_v1_0h9e.asp
> More information for reference:
> Installing a Report Server Web Farm
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/h
> tm/gs_installingrs_v1_2ckm.asp
> 305064 How To Set Up an NLB Cluster for Application Center 2000
> http://support.microsoft.com/?id=305064
> Regarding the information of how to implement and maintain NLB clusters,
> if
> you use a third-party hardware load balancer, please contact the hardware
> vendor support to inquire about this issue. I believe that they will
> assist
> you best since they will have the proper material resources to resolve
> this
> problem.
> I hope the information is helpful.
>
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||One further point, this is an Enterprise only feature.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Adrian Russell" <adrianru@.avanade.com> wrote in message
news:ujF3s%23ARFHA.356@.TK2MSFTNGP14.phx.gbl...
> Hi Sophie,
> To confirm that I understand what you are saying, here is my take on how
you
> would deploy a multi node reporting server with hardware load balancing.
> Note: Database tier is being deployed as active/active SQL Cluster.
> 1. Deploy the initial reporting services server node as per a vanilla
> install.
> 2. Deploy any subsequent nodes by joining the nodes to the initial
reporting
> services node by specifying the RSWEBFARMSERVER property in the
installation
> 3. Overlay the web nodes with either a hardware or software load balancing
> solution.
> Thanks,
> Adrian.
> "Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> wrote in message
> news:Tu9WDs$QFHA.3704@.TK2MSFTNGXA02.phx.gbl...
> > Hello Adrian,
> >
> > A report server Web farm is a collection of report server instances that
> > share the same report server database. Reporting Services does not
provide
> > Web farm deployment functionality. To deploy Reporting Services in a Web
> > farm, you can use network load balancing (NLB) functionality provided
> > through Windows servers, Microsoft Application Center, or third-party
> > software that supports Web farm deployment. The load balancer can be
> > software or hardware.
> >
> > For the "Steps for Deploying a Report Server Web Farm", please refer to
> > the
> > "Steps for Deploying a Report Server Web Farm" section in the following
> > web
> > site:
> >
> > Enterprise Deployment Model
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
> > /drp_deploying_v1_0h9e.asp
> >
> > More information for reference:
> >
> > Installing a Report Server Web Farm
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/h
> > tm/gs_installingrs_v1_2ckm.asp
> >
> > 305064 How To Set Up an NLB Cluster for Application Center 2000
> > http://support.microsoft.com/?id=305064
> >
> > Regarding the information of how to implement and maintain NLB clusters,
> > if
> > you use a third-party hardware load balancer, please contact the
hardware
> > vendor support to inquire about this issue. I believe that they will
> > assist
> > you best since they will have the proper material resources to resolve
> > this
> > problem.
> >
> > I hope the information is helpful.
> >
> >
> > Sophie Guo
> > Microsoft Online Partner Support
> >
> > Get Secure! - www.microsoft.com/security
> >
> > =====================================================> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> > =====================================================> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
>|||By Enterprise only I mean both SQL Server db has to be enterprise and the
Reporting Services install has to be Enterprise. Plus, for each server in
the web farm with Reporting Services you need an SQL Server Enterprise
license.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Adrian Russell" <adrianru@.avanade.com> wrote in message
news:ujF3s%23ARFHA.356@.TK2MSFTNGP14.phx.gbl...
> Hi Sophie,
> To confirm that I understand what you are saying, here is my take on how
you
> would deploy a multi node reporting server with hardware load balancing.
> Note: Database tier is being deployed as active/active SQL Cluster.
> 1. Deploy the initial reporting services server node as per a vanilla
> install.
> 2. Deploy any subsequent nodes by joining the nodes to the initial
reporting
> services node by specifying the RSWEBFARMSERVER property in the
installation
> 3. Overlay the web nodes with either a hardware or software load balancing
> solution.
> Thanks,
> Adrian.
> "Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> wrote in message
> news:Tu9WDs$QFHA.3704@.TK2MSFTNGXA02.phx.gbl...
> > Hello Adrian,
> >
> > A report server Web farm is a collection of report server instances that
> > share the same report server database. Reporting Services does not
provide
> > Web farm deployment functionality. To deploy Reporting Services in a Web
> > farm, you can use network load balancing (NLB) functionality provided
> > through Windows servers, Microsoft Application Center, or third-party
> > software that supports Web farm deployment. The load balancer can be
> > software or hardware.
> >
> > For the "Steps for Deploying a Report Server Web Farm", please refer to
> > the
> > "Steps for Deploying a Report Server Web Farm" section in the following
> > web
> > site:
> >
> > Enterprise Deployment Model
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
> > /drp_deploying_v1_0h9e.asp
> >
> > More information for reference:
> >
> > Installing a Report Server Web Farm
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/h
> > tm/gs_installingrs_v1_2ckm.asp
> >
> > 305064 How To Set Up an NLB Cluster for Application Center 2000
> > http://support.microsoft.com/?id=305064
> >
> > Regarding the information of how to implement and maintain NLB clusters,
> > if
> > you use a third-party hardware load balancer, please contact the
hardware
> > vendor support to inquire about this issue. I believe that they will
> > assist
> > you best since they will have the proper material resources to resolve
> > this
> > problem.
> >
> > I hope the information is helpful.
> >
> >
> > Sophie Guo
> > Microsoft Online Partner Support
> >
> > Get Secure! - www.microsoft.com/security
> >
> > =====================================================> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> > =====================================================> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
>|||I'm operating in exactly this configuration. As mentioned by others,
its really straight forward to setup:
Prerequsites:
- A Sql Server 2000 Enterprise instance with SP3a
Installation:
1) Install Sql Reporting 2000 Enterprise on the first web server.
During installation it creates the needed ReportServer and
ReportServerTempDb databases.
2) Install Sql Reporting 2000 Enterprise on each subsequent server in
Farm and point them at the ReportServer DB created in step 1. (repeat
for each additional server)
3) Deploy RDL's via ReportsServer web service from any of the servers
(since they share the same DB and therefore will share the RDL's once
they are uploaded).
4) Start using your servers. (or begin applying Service packs)
Note: SP2 will require one extra step which is to run RSActivate in
order to join your additional Report Server nodes to the group. In
pre-SP2 installations, this is done automatically for you.
One thing to consider when doing the F5 setup; make sure to setup
Server Affinity using a time-based session so you don't run into any
problems with ASP.NET post-backs. Typically I set the session
expiration to 40 minutes, but it all depends upon your
user-characteristics. Also I have found it helpful to utilize the
"Least Used" algorithm rather than the default "Round Robin" approach
to load balancing.
Obviously, there are numerous architectural and infrastructural
decisions required throughout this process, but this should give you
the 10k meter view.
I am happy with F5 for load balancing so far, so I hope this works out
for you.
Enjoy.
Lance Hunt
http://weblogs.asp.net/lhunt/|||Hello Adrian,
For the second item:
2. Deploy any subsequent nodes by joining the nodes to the initial
reporting services node by specifying the RSWEBFARMSERVER property in the
installation
The RSWEBFARMSERVER property is specified in the command prompt. To install
a web farm, you have to specify the RSDATABASENAME and RSDATABASESERVER
property in the command prompt.
For more information, please refer to the following topic in BOL:
"Installing Reporting Services From the Command Line"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/h
tm/gs_installingrs_v1_6h6h.asp
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi!
I'm also F5 Hardware load balancing, but I'm running into a problem.
Right now, we have 2 web servers in a cluster, and an F5 load balancer
infront of it. Both web servers have Kerberos delegation enabled, and
I can access Reporting services via Web Service just fine when I access
the web servers directly. However, when I put the F5 load balancer
infront, I get an Authentication error. The load balancer appears to
be sending my credentials as Anonymous! Has this happened to anyone?
Is there a Kerberos setting on this F5 hardware load balancer? I'm
unfamiliar with the hardware, and I'm trying to contact my IT
department to contact the vendor. That might take a while. I'm hoping
someone here has an answer.
Thanks!
Roy Assaly
Sophie Guo [MSFT] wrote:
> Hello Adrian,
> For the second item:
> 2. Deploy any subsequent nodes by joining the nodes to the initial
> reporting services node by specifying the RSWEBFARMSERVER property in
the
> installation
> The RSWEBFARMSERVER property is specified in the command prompt. To
install
> a web farm, you have to specify the RSDATABASENAME and
RSDATABASESERVER
> property in the command prompt.
> For more information, please refer to the following topic in BOL:
> "Installing Reporting Services From the Command Line"
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/h
> tm/gs_installingrs_v1_6h6h.asp
> I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader
so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
rights.
load balanced environment. The documentation from MS only covers MS's NLB
software. Has anyone had any experience deploying with a hardware load
balancer. Specifically F5 load balencing equipment.
Thanks,
Adrian.Hello Adrian,
A report server Web farm is a collection of report server instances that
share the same report server database. Reporting Services does not provide
Web farm deployment functionality. To deploy Reporting Services in a Web
farm, you can use network load balancing (NLB) functionality provided
through Windows servers, Microsoft Application Center, or third-party
software that supports Web farm deployment. The load balancer can be
software or hardware.
For the "Steps for Deploying a Report Server Web Farm", please refer to the
"Steps for Deploying a Report Server Web Farm" section in the following web
site:
Enterprise Deployment Model
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
/drp_deploying_v1_0h9e.asp
More information for reference:
Installing a Report Server Web Farm
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/h
tm/gs_installingrs_v1_2ckm.asp
305064 How To Set Up an NLB Cluster for Application Center 2000
http://support.microsoft.com/?id=305064
Regarding the information of how to implement and maintain NLB clusters, if
you use a third-party hardware load balancer, please contact the hardware
vendor support to inquire about this issue. I believe that they will assist
you best since they will have the proper material resources to resolve this
problem.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Sophie,
To confirm that I understand what you are saying, here is my take on how you
would deploy a multi node reporting server with hardware load balancing.
Note: Database tier is being deployed as active/active SQL Cluster.
1. Deploy the initial reporting services server node as per a vanilla
install.
2. Deploy any subsequent nodes by joining the nodes to the initial reporting
services node by specifying the RSWEBFARMSERVER property in the installation
3. Overlay the web nodes with either a hardware or software load balancing
solution.
Thanks,
Adrian.
"Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> wrote in message
news:Tu9WDs$QFHA.3704@.TK2MSFTNGXA02.phx.gbl...
> Hello Adrian,
> A report server Web farm is a collection of report server instances that
> share the same report server database. Reporting Services does not provide
> Web farm deployment functionality. To deploy Reporting Services in a Web
> farm, you can use network load balancing (NLB) functionality provided
> through Windows servers, Microsoft Application Center, or third-party
> software that supports Web farm deployment. The load balancer can be
> software or hardware.
> For the "Steps for Deploying a Report Server Web Farm", please refer to
> the
> "Steps for Deploying a Report Server Web Farm" section in the following
> web
> site:
> Enterprise Deployment Model
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
> /drp_deploying_v1_0h9e.asp
> More information for reference:
> Installing a Report Server Web Farm
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/h
> tm/gs_installingrs_v1_2ckm.asp
> 305064 How To Set Up an NLB Cluster for Application Center 2000
> http://support.microsoft.com/?id=305064
> Regarding the information of how to implement and maintain NLB clusters,
> if
> you use a third-party hardware load balancer, please contact the hardware
> vendor support to inquire about this issue. I believe that they will
> assist
> you best since they will have the proper material resources to resolve
> this
> problem.
> I hope the information is helpful.
>
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||One further point, this is an Enterprise only feature.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Adrian Russell" <adrianru@.avanade.com> wrote in message
news:ujF3s%23ARFHA.356@.TK2MSFTNGP14.phx.gbl...
> Hi Sophie,
> To confirm that I understand what you are saying, here is my take on how
you
> would deploy a multi node reporting server with hardware load balancing.
> Note: Database tier is being deployed as active/active SQL Cluster.
> 1. Deploy the initial reporting services server node as per a vanilla
> install.
> 2. Deploy any subsequent nodes by joining the nodes to the initial
reporting
> services node by specifying the RSWEBFARMSERVER property in the
installation
> 3. Overlay the web nodes with either a hardware or software load balancing
> solution.
> Thanks,
> Adrian.
> "Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> wrote in message
> news:Tu9WDs$QFHA.3704@.TK2MSFTNGXA02.phx.gbl...
> > Hello Adrian,
> >
> > A report server Web farm is a collection of report server instances that
> > share the same report server database. Reporting Services does not
provide
> > Web farm deployment functionality. To deploy Reporting Services in a Web
> > farm, you can use network load balancing (NLB) functionality provided
> > through Windows servers, Microsoft Application Center, or third-party
> > software that supports Web farm deployment. The load balancer can be
> > software or hardware.
> >
> > For the "Steps for Deploying a Report Server Web Farm", please refer to
> > the
> > "Steps for Deploying a Report Server Web Farm" section in the following
> > web
> > site:
> >
> > Enterprise Deployment Model
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
> > /drp_deploying_v1_0h9e.asp
> >
> > More information for reference:
> >
> > Installing a Report Server Web Farm
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/h
> > tm/gs_installingrs_v1_2ckm.asp
> >
> > 305064 How To Set Up an NLB Cluster for Application Center 2000
> > http://support.microsoft.com/?id=305064
> >
> > Regarding the information of how to implement and maintain NLB clusters,
> > if
> > you use a third-party hardware load balancer, please contact the
hardware
> > vendor support to inquire about this issue. I believe that they will
> > assist
> > you best since they will have the proper material resources to resolve
> > this
> > problem.
> >
> > I hope the information is helpful.
> >
> >
> > Sophie Guo
> > Microsoft Online Partner Support
> >
> > Get Secure! - www.microsoft.com/security
> >
> > =====================================================> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> > =====================================================> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
>|||By Enterprise only I mean both SQL Server db has to be enterprise and the
Reporting Services install has to be Enterprise. Plus, for each server in
the web farm with Reporting Services you need an SQL Server Enterprise
license.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Adrian Russell" <adrianru@.avanade.com> wrote in message
news:ujF3s%23ARFHA.356@.TK2MSFTNGP14.phx.gbl...
> Hi Sophie,
> To confirm that I understand what you are saying, here is my take on how
you
> would deploy a multi node reporting server with hardware load balancing.
> Note: Database tier is being deployed as active/active SQL Cluster.
> 1. Deploy the initial reporting services server node as per a vanilla
> install.
> 2. Deploy any subsequent nodes by joining the nodes to the initial
reporting
> services node by specifying the RSWEBFARMSERVER property in the
installation
> 3. Overlay the web nodes with either a hardware or software load balancing
> solution.
> Thanks,
> Adrian.
> "Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> wrote in message
> news:Tu9WDs$QFHA.3704@.TK2MSFTNGXA02.phx.gbl...
> > Hello Adrian,
> >
> > A report server Web farm is a collection of report server instances that
> > share the same report server database. Reporting Services does not
provide
> > Web farm deployment functionality. To deploy Reporting Services in a Web
> > farm, you can use network load balancing (NLB) functionality provided
> > through Windows servers, Microsoft Application Center, or third-party
> > software that supports Web farm deployment. The load balancer can be
> > software or hardware.
> >
> > For the "Steps for Deploying a Report Server Web Farm", please refer to
> > the
> > "Steps for Deploying a Report Server Web Farm" section in the following
> > web
> > site:
> >
> > Enterprise Deployment Model
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
> > /drp_deploying_v1_0h9e.asp
> >
> > More information for reference:
> >
> > Installing a Report Server Web Farm
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/h
> > tm/gs_installingrs_v1_2ckm.asp
> >
> > 305064 How To Set Up an NLB Cluster for Application Center 2000
> > http://support.microsoft.com/?id=305064
> >
> > Regarding the information of how to implement and maintain NLB clusters,
> > if
> > you use a third-party hardware load balancer, please contact the
hardware
> > vendor support to inquire about this issue. I believe that they will
> > assist
> > you best since they will have the proper material resources to resolve
> > this
> > problem.
> >
> > I hope the information is helpful.
> >
> >
> > Sophie Guo
> > Microsoft Online Partner Support
> >
> > Get Secure! - www.microsoft.com/security
> >
> > =====================================================> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> > =====================================================> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
>|||I'm operating in exactly this configuration. As mentioned by others,
its really straight forward to setup:
Prerequsites:
- A Sql Server 2000 Enterprise instance with SP3a
Installation:
1) Install Sql Reporting 2000 Enterprise on the first web server.
During installation it creates the needed ReportServer and
ReportServerTempDb databases.
2) Install Sql Reporting 2000 Enterprise on each subsequent server in
Farm and point them at the ReportServer DB created in step 1. (repeat
for each additional server)
3) Deploy RDL's via ReportsServer web service from any of the servers
(since they share the same DB and therefore will share the RDL's once
they are uploaded).
4) Start using your servers. (or begin applying Service packs)
Note: SP2 will require one extra step which is to run RSActivate in
order to join your additional Report Server nodes to the group. In
pre-SP2 installations, this is done automatically for you.
One thing to consider when doing the F5 setup; make sure to setup
Server Affinity using a time-based session so you don't run into any
problems with ASP.NET post-backs. Typically I set the session
expiration to 40 minutes, but it all depends upon your
user-characteristics. Also I have found it helpful to utilize the
"Least Used" algorithm rather than the default "Round Robin" approach
to load balancing.
Obviously, there are numerous architectural and infrastructural
decisions required throughout this process, but this should give you
the 10k meter view.
I am happy with F5 for load balancing so far, so I hope this works out
for you.
Enjoy.
Lance Hunt
http://weblogs.asp.net/lhunt/|||Hello Adrian,
For the second item:
2. Deploy any subsequent nodes by joining the nodes to the initial
reporting services node by specifying the RSWEBFARMSERVER property in the
installation
The RSWEBFARMSERVER property is specified in the command prompt. To install
a web farm, you have to specify the RSDATABASENAME and RSDATABASESERVER
property in the command prompt.
For more information, please refer to the following topic in BOL:
"Installing Reporting Services From the Command Line"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/h
tm/gs_installingrs_v1_6h6h.asp
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi!
I'm also F5 Hardware load balancing, but I'm running into a problem.
Right now, we have 2 web servers in a cluster, and an F5 load balancer
infront of it. Both web servers have Kerberos delegation enabled, and
I can access Reporting services via Web Service just fine when I access
the web servers directly. However, when I put the F5 load balancer
infront, I get an Authentication error. The load balancer appears to
be sending my credentials as Anonymous! Has this happened to anyone?
Is there a Kerberos setting on this F5 hardware load balancer? I'm
unfamiliar with the hardware, and I'm trying to contact my IT
department to contact the vendor. That might take a while. I'm hoping
someone here has an answer.
Thanks!
Roy Assaly
Sophie Guo [MSFT] wrote:
> Hello Adrian,
> For the second item:
> 2. Deploy any subsequent nodes by joining the nodes to the initial
> reporting services node by specifying the RSWEBFARMSERVER property in
the
> installation
> The RSWEBFARMSERVER property is specified in the command prompt. To
install
> a web farm, you have to specify the RSDATABASENAME and
RSDATABASESERVER
> property in the command prompt.
> For more information, please refer to the following topic in BOL:
> "Installing Reporting Services From the Command Line"
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/h
> tm/gs_installingrs_v1_6h6h.asp
> I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader
so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
rights.
Thursday, March 22, 2012
Deployment to Production problems
Somewhat newbie here trying to deploy my first Report. Production machine is
on Windows 2003 - finally got around the reporting service prompting for
windows authentication and now I'm trying to deploy my report through VS
2003. Which reports successful deployment.
If I press the "Run" button in VS 2003 it displays a web page:
[To Parent Directory]
Tuesday, March 29, 2005... Name of my report
No fancy Reporting Service front end, just a hyperlink. If I click on the
link, it displays my report.
If I navigate to http://[servername]/Reports/Pages/Folder.aspx it displays
the web page of SQL Server Reporting Services Home (with the appropriate
GUI), but no folders are listed.
There's obviously some extra step I need to do with 2003 that I didn't need
to setup on my local XP system that I developed and debugged on.Sounds like you haven't given permissions for anyone to see the reports. By
default, only admins can see contents of the server.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"dtaylor" <dtaylor@.discussions.microsoft.com> wrote in message
news:F158F5D6-E52B-40F6-9F31-31C49358C33D@.microsoft.com...
> Somewhat newbie here trying to deploy my first Report. Production machine
> is
> on Windows 2003 - finally got around the reporting service prompting for
> windows authentication and now I'm trying to deploy my report through VS
> 2003. Which reports successful deployment.
> If I press the "Run" button in VS 2003 it displays a web page:
> [To Parent Directory]
> Tuesday, March 29, 2005... Name of my report
> No fancy Reporting Service front end, just a hyperlink. If I click on the
> link, it displays my report.
> If I navigate to http://[servername]/Reports/Pages/Folder.aspx it displays
> the web page of SQL Server Reporting Services Home (with the appropriate
> GUI), but no folders are listed.
> There's obviously some extra step I need to do with 2003 that I didn't
> need
> to setup on my local XP system that I developed and debugged on.sql
on Windows 2003 - finally got around the reporting service prompting for
windows authentication and now I'm trying to deploy my report through VS
2003. Which reports successful deployment.
If I press the "Run" button in VS 2003 it displays a web page:
[To Parent Directory]
Tuesday, March 29, 2005... Name of my report
No fancy Reporting Service front end, just a hyperlink. If I click on the
link, it displays my report.
If I navigate to http://[servername]/Reports/Pages/Folder.aspx it displays
the web page of SQL Server Reporting Services Home (with the appropriate
GUI), but no folders are listed.
There's obviously some extra step I need to do with 2003 that I didn't need
to setup on my local XP system that I developed and debugged on.Sounds like you haven't given permissions for anyone to see the reports. By
default, only admins can see contents of the server.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"dtaylor" <dtaylor@.discussions.microsoft.com> wrote in message
news:F158F5D6-E52B-40F6-9F31-31C49358C33D@.microsoft.com...
> Somewhat newbie here trying to deploy my first Report. Production machine
> is
> on Windows 2003 - finally got around the reporting service prompting for
> windows authentication and now I'm trying to deploy my report through VS
> 2003. Which reports successful deployment.
> If I press the "Run" button in VS 2003 it displays a web page:
> [To Parent Directory]
> Tuesday, March 29, 2005... Name of my report
> No fancy Reporting Service front end, just a hyperlink. If I click on the
> link, it displays my report.
> If I navigate to http://[servername]/Reports/Pages/Folder.aspx it displays
> the web page of SQL Server Reporting Services Home (with the appropriate
> GUI), but no folders are listed.
> There's obviously some extra step I need to do with 2003 that I didn't
> need
> to setup on my local XP system that I developed and debugged on.sql
Deployment Security Problem
Hi,
I am trying to deploy my reports to a new server running reporting
services w/ SQL Server 2000 on the local machine. The ReportServer web site
has anonymous access NOT checked and Windows Integration selected. I'm
logged onto my machine with my domain account and when I try to deploy my
reports in VS 2003 I get "The underlying connection was closed: Could not
establish trust relationship with remote server." I do NOT have "Require
SSL" turned on and I know it has something to do with the way my credentials
are being passed (or not passed). If I turn on the option to allow
anonymous access to the reportserver site then I get a message that my
IUSR_<machinename> has insufficient privleges to perform the actions, which
is fine I don't want anonymous access on anyway.
How do I resolve deploying reports to the report server with my domain
account? I used the same domain account to install SQL Server and Reporting
Services and I am a local administrator on the server.
Thanks, ChrisIn addition to what I've discovered...
I can take the same URL I'm using for the TargetServerURL property and
browse to the report server. I get a pop-up dialog box to input my
credentials and I'm authenticated fine. Based on Microsoft Knowledge Base
Article - 842517 it would seem that the login dialog box should appear, but
it doesn't and just the error "Could not
> establish trust relationship with remote server." appears. The local
administrators are "content managers" for reporting services and I am a
member of that group, though I don't think the deployment process is making
it that far.
Thanks, Chris
"Chris" <chrisf@.unr.edu> wrote in message
news:u03AZPxfEHA.3536@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am trying to deploy my reports to a new server running reporting
> services w/ SQL Server 2000 on the local machine. The ReportServer web
site
> has anonymous access NOT checked and Windows Integration selected. I'm
> logged onto my machine with my domain account and when I try to deploy my
> reports in VS 2003 I get "The underlying connection was closed: Could not
> establish trust relationship with remote server." I do NOT have "Require
> SSL" turned on and I know it has something to do with the way my
credentials
> are being passed (or not passed). If I turn on the option to allow
> anonymous access to the reportserver site then I get a message that my
> IUSR_<machinename> has insufficient privleges to perform the actions,
which
> is fine I don't want anonymous access on anyway.
> How do I resolve deploying reports to the report server with my domain
> account? I used the same domain account to install SQL Server and
Reporting
> Services and I am a local administrator on the server.
> Thanks, Chris
>|||Chris:
In IE's security settings for the zone, is User Authentication set to
automatic logon or prompt? You might want to check here (Tools ->
Options -> Security -> Custom Level (for the zone your report server
is in).
--
Scott
http://www.OdeToCode.com
On Tue, 10 Aug 2004 12:54:27 -0700, "Chris" <chrisf@.unr.edu> wrote:
>Hi,
> I am trying to deploy my reports to a new server running reporting
>services w/ SQL Server 2000 on the local machine. The ReportServer web site
>has anonymous access NOT checked and Windows Integration selected. I'm
>logged onto my machine with my domain account and when I try to deploy my
>reports in VS 2003 I get "The underlying connection was closed: Could not
>establish trust relationship with remote server." I do NOT have "Require
>SSL" turned on and I know it has something to do with the way my credentials
>are being passed (or not passed). If I turn on the option to allow
>anonymous access to the reportserver site then I get a message that my
>IUSR_<machinename> has insufficient privleges to perform the actions, which
>is fine I don't want anonymous access on anyway.
>How do I resolve deploying reports to the report server with my domain
>account? I used the same domain account to install SQL Server and Reporting
>Services and I am a local administrator on the server.
>Thanks, Chris
>|||Hey Scott,
The IE zone setting changes don't have any affect. Visual Studio
continues to report the trust relationship error. I've tried both secure
and non-secure TargetServerURL properties.
Chris
"Scott Allen" <bitmask@.[nospam].fred.net> wrote in message
news:jp1jh0dq2m82lm982j8rab8flnjjde59o2@.4ax.com...
> Chris:
> In IE's security settings for the zone, is User Authentication set to
> automatic logon or prompt? You might want to check here (Tools ->
> Options -> Security -> Custom Level (for the zone your report server
> is in).
> --
> Scott
> http://www.OdeToCode.com
> On Tue, 10 Aug 2004 12:54:27 -0700, "Chris" <chrisf@.unr.edu> wrote:
> >Hi,
> > I am trying to deploy my reports to a new server running reporting
> >services w/ SQL Server 2000 on the local machine. The ReportServer web
site
> >has anonymous access NOT checked and Windows Integration selected. I'm
> >logged onto my machine with my domain account and when I try to deploy my
> >reports in VS 2003 I get "The underlying connection was closed: Could not
> >establish trust relationship with remote server." I do NOT have "Require
> >SSL" turned on and I know it has something to do with the way my
credentials
> >are being passed (or not passed). If I turn on the option to allow
> >anonymous access to the reportserver site then I get a message that my
> >IUSR_<machinename> has insufficient privleges to perform the actions,
which
> >is fine I don't want anonymous access on anyway.
> >
> >How do I resolve deploying reports to the report server with my domain
> >account? I used the same domain account to install SQL Server and
Reporting
> >Services and I am a local administrator on the server.
> >
> >Thanks, Chris
> >
>|||Well, I changed the security on the web site to require secure connections
and installed the certificate from the server into my machine's certificate
store and the deploy worked. I don't quite fully understand why non-ssl
connections don't work, but turning ssl on and making sure the CA was
trusted fixed the problem. Could this have been a bug or is there some
requirement that a secure connection be used to deploy reporting service
objects?
Chris
"Scott Allen" <bitmask@.[nospam].fred.net> wrote in message
news:jp1jh0dq2m82lm982j8rab8flnjjde59o2@.4ax.com...
> Chris:
> In IE's security settings for the zone, is User Authentication set to
> automatic logon or prompt? You might want to check here (Tools ->
> Options -> Security -> Custom Level (for the zone your report server
> is in).
> --
> Scott
> http://www.OdeToCode.com
> On Tue, 10 Aug 2004 12:54:27 -0700, "Chris" <chrisf@.unr.edu> wrote:
> >Hi,
> > I am trying to deploy my reports to a new server running reporting
> >services w/ SQL Server 2000 on the local machine. The ReportServer web
site
> >has anonymous access NOT checked and Windows Integration selected. I'm
> >logged onto my machine with my domain account and when I try to deploy my
> >reports in VS 2003 I get "The underlying connection was closed: Could not
> >establish trust relationship with remote server." I do NOT have "Require
> >SSL" turned on and I know it has something to do with the way my
credentials
> >are being passed (or not passed). If I turn on the option to allow
> >anonymous access to the reportserver site then I get a message that my
> >IUSR_<machinename> has insufficient privleges to perform the actions,
which
> >is fine I don't want anonymous access on anyway.
> >
> >How do I resolve deploying reports to the report server with my domain
> >account? I used the same domain account to install SQL Server and
Reporting
> >Services and I am a local administrator on the server.
> >
> >Thanks, Chris
> >
>|||I am using integrated security without ssl. I did have a problem once where
I went through an install without unchecking ssl and I was messed up. Don't
remember how I got out of the hole. However, I have done a couple of
installs since then and made sure to un-check ssl and everything went
smoothly.
Bruce L-C
"Chris" <chrisf@.unr.edu> wrote in message
news:%23hQmER7fEHA.140@.TK2MSFTNGP12.phx.gbl...
> Well, I changed the security on the web site to require secure connections
> and installed the certificate from the server into my machine's
certificate
> store and the deploy worked. I don't quite fully understand why non-ssl
> connections don't work, but turning ssl on and making sure the CA was
> trusted fixed the problem. Could this have been a bug or is there some
> requirement that a secure connection be used to deploy reporting service
> objects?
> Chris
> "Scott Allen" <bitmask@.[nospam].fred.net> wrote in message
> news:jp1jh0dq2m82lm982j8rab8flnjjde59o2@.4ax.com...
> > Chris:
> >
> > In IE's security settings for the zone, is User Authentication set to
> > automatic logon or prompt? You might want to check here (Tools ->
> > Options -> Security -> Custom Level (for the zone your report server
> > is in).
> >
> > --
> > Scott
> > http://www.OdeToCode.com
> >
> > On Tue, 10 Aug 2004 12:54:27 -0700, "Chris" <chrisf@.unr.edu> wrote:
> >
> > >Hi,
> > > I am trying to deploy my reports to a new server running reporting
> > >services w/ SQL Server 2000 on the local machine. The ReportServer web
> site
> > >has anonymous access NOT checked and Windows Integration selected. I'm
> > >logged onto my machine with my domain account and when I try to deploy
my
> > >reports in VS 2003 I get "The underlying connection was closed: Could
not
> > >establish trust relationship with remote server." I do NOT have
"Require
> > >SSL" turned on and I know it has something to do with the way my
> credentials
> > >are being passed (or not passed). If I turn on the option to allow
> > >anonymous access to the reportserver site then I get a message that my
> > >IUSR_<machinename> has insufficient privleges to perform the actions,
> which
> > >is fine I don't want anonymous access on anyway.
> > >
> > >How do I resolve deploying reports to the report server with my domain
> > >account? I used the same domain account to install SQL Server and
> Reporting
> > >Services and I am a local administrator on the server.
> > >
> > >Thanks, Chris
> > >
> >
>
I am trying to deploy my reports to a new server running reporting
services w/ SQL Server 2000 on the local machine. The ReportServer web site
has anonymous access NOT checked and Windows Integration selected. I'm
logged onto my machine with my domain account and when I try to deploy my
reports in VS 2003 I get "The underlying connection was closed: Could not
establish trust relationship with remote server." I do NOT have "Require
SSL" turned on and I know it has something to do with the way my credentials
are being passed (or not passed). If I turn on the option to allow
anonymous access to the reportserver site then I get a message that my
IUSR_<machinename> has insufficient privleges to perform the actions, which
is fine I don't want anonymous access on anyway.
How do I resolve deploying reports to the report server with my domain
account? I used the same domain account to install SQL Server and Reporting
Services and I am a local administrator on the server.
Thanks, ChrisIn addition to what I've discovered...
I can take the same URL I'm using for the TargetServerURL property and
browse to the report server. I get a pop-up dialog box to input my
credentials and I'm authenticated fine. Based on Microsoft Knowledge Base
Article - 842517 it would seem that the login dialog box should appear, but
it doesn't and just the error "Could not
> establish trust relationship with remote server." appears. The local
administrators are "content managers" for reporting services and I am a
member of that group, though I don't think the deployment process is making
it that far.
Thanks, Chris
"Chris" <chrisf@.unr.edu> wrote in message
news:u03AZPxfEHA.3536@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am trying to deploy my reports to a new server running reporting
> services w/ SQL Server 2000 on the local machine. The ReportServer web
site
> has anonymous access NOT checked and Windows Integration selected. I'm
> logged onto my machine with my domain account and when I try to deploy my
> reports in VS 2003 I get "The underlying connection was closed: Could not
> establish trust relationship with remote server." I do NOT have "Require
> SSL" turned on and I know it has something to do with the way my
credentials
> are being passed (or not passed). If I turn on the option to allow
> anonymous access to the reportserver site then I get a message that my
> IUSR_<machinename> has insufficient privleges to perform the actions,
which
> is fine I don't want anonymous access on anyway.
> How do I resolve deploying reports to the report server with my domain
> account? I used the same domain account to install SQL Server and
Reporting
> Services and I am a local administrator on the server.
> Thanks, Chris
>|||Chris:
In IE's security settings for the zone, is User Authentication set to
automatic logon or prompt? You might want to check here (Tools ->
Options -> Security -> Custom Level (for the zone your report server
is in).
--
Scott
http://www.OdeToCode.com
On Tue, 10 Aug 2004 12:54:27 -0700, "Chris" <chrisf@.unr.edu> wrote:
>Hi,
> I am trying to deploy my reports to a new server running reporting
>services w/ SQL Server 2000 on the local machine. The ReportServer web site
>has anonymous access NOT checked and Windows Integration selected. I'm
>logged onto my machine with my domain account and when I try to deploy my
>reports in VS 2003 I get "The underlying connection was closed: Could not
>establish trust relationship with remote server." I do NOT have "Require
>SSL" turned on and I know it has something to do with the way my credentials
>are being passed (or not passed). If I turn on the option to allow
>anonymous access to the reportserver site then I get a message that my
>IUSR_<machinename> has insufficient privleges to perform the actions, which
>is fine I don't want anonymous access on anyway.
>How do I resolve deploying reports to the report server with my domain
>account? I used the same domain account to install SQL Server and Reporting
>Services and I am a local administrator on the server.
>Thanks, Chris
>|||Hey Scott,
The IE zone setting changes don't have any affect. Visual Studio
continues to report the trust relationship error. I've tried both secure
and non-secure TargetServerURL properties.
Chris
"Scott Allen" <bitmask@.[nospam].fred.net> wrote in message
news:jp1jh0dq2m82lm982j8rab8flnjjde59o2@.4ax.com...
> Chris:
> In IE's security settings for the zone, is User Authentication set to
> automatic logon or prompt? You might want to check here (Tools ->
> Options -> Security -> Custom Level (for the zone your report server
> is in).
> --
> Scott
> http://www.OdeToCode.com
> On Tue, 10 Aug 2004 12:54:27 -0700, "Chris" <chrisf@.unr.edu> wrote:
> >Hi,
> > I am trying to deploy my reports to a new server running reporting
> >services w/ SQL Server 2000 on the local machine. The ReportServer web
site
> >has anonymous access NOT checked and Windows Integration selected. I'm
> >logged onto my machine with my domain account and when I try to deploy my
> >reports in VS 2003 I get "The underlying connection was closed: Could not
> >establish trust relationship with remote server." I do NOT have "Require
> >SSL" turned on and I know it has something to do with the way my
credentials
> >are being passed (or not passed). If I turn on the option to allow
> >anonymous access to the reportserver site then I get a message that my
> >IUSR_<machinename> has insufficient privleges to perform the actions,
which
> >is fine I don't want anonymous access on anyway.
> >
> >How do I resolve deploying reports to the report server with my domain
> >account? I used the same domain account to install SQL Server and
Reporting
> >Services and I am a local administrator on the server.
> >
> >Thanks, Chris
> >
>|||Well, I changed the security on the web site to require secure connections
and installed the certificate from the server into my machine's certificate
store and the deploy worked. I don't quite fully understand why non-ssl
connections don't work, but turning ssl on and making sure the CA was
trusted fixed the problem. Could this have been a bug or is there some
requirement that a secure connection be used to deploy reporting service
objects?
Chris
"Scott Allen" <bitmask@.[nospam].fred.net> wrote in message
news:jp1jh0dq2m82lm982j8rab8flnjjde59o2@.4ax.com...
> Chris:
> In IE's security settings for the zone, is User Authentication set to
> automatic logon or prompt? You might want to check here (Tools ->
> Options -> Security -> Custom Level (for the zone your report server
> is in).
> --
> Scott
> http://www.OdeToCode.com
> On Tue, 10 Aug 2004 12:54:27 -0700, "Chris" <chrisf@.unr.edu> wrote:
> >Hi,
> > I am trying to deploy my reports to a new server running reporting
> >services w/ SQL Server 2000 on the local machine. The ReportServer web
site
> >has anonymous access NOT checked and Windows Integration selected. I'm
> >logged onto my machine with my domain account and when I try to deploy my
> >reports in VS 2003 I get "The underlying connection was closed: Could not
> >establish trust relationship with remote server." I do NOT have "Require
> >SSL" turned on and I know it has something to do with the way my
credentials
> >are being passed (or not passed). If I turn on the option to allow
> >anonymous access to the reportserver site then I get a message that my
> >IUSR_<machinename> has insufficient privleges to perform the actions,
which
> >is fine I don't want anonymous access on anyway.
> >
> >How do I resolve deploying reports to the report server with my domain
> >account? I used the same domain account to install SQL Server and
Reporting
> >Services and I am a local administrator on the server.
> >
> >Thanks, Chris
> >
>|||I am using integrated security without ssl. I did have a problem once where
I went through an install without unchecking ssl and I was messed up. Don't
remember how I got out of the hole. However, I have done a couple of
installs since then and made sure to un-check ssl and everything went
smoothly.
Bruce L-C
"Chris" <chrisf@.unr.edu> wrote in message
news:%23hQmER7fEHA.140@.TK2MSFTNGP12.phx.gbl...
> Well, I changed the security on the web site to require secure connections
> and installed the certificate from the server into my machine's
certificate
> store and the deploy worked. I don't quite fully understand why non-ssl
> connections don't work, but turning ssl on and making sure the CA was
> trusted fixed the problem. Could this have been a bug or is there some
> requirement that a secure connection be used to deploy reporting service
> objects?
> Chris
> "Scott Allen" <bitmask@.[nospam].fred.net> wrote in message
> news:jp1jh0dq2m82lm982j8rab8flnjjde59o2@.4ax.com...
> > Chris:
> >
> > In IE's security settings for the zone, is User Authentication set to
> > automatic logon or prompt? You might want to check here (Tools ->
> > Options -> Security -> Custom Level (for the zone your report server
> > is in).
> >
> > --
> > Scott
> > http://www.OdeToCode.com
> >
> > On Tue, 10 Aug 2004 12:54:27 -0700, "Chris" <chrisf@.unr.edu> wrote:
> >
> > >Hi,
> > > I am trying to deploy my reports to a new server running reporting
> > >services w/ SQL Server 2000 on the local machine. The ReportServer web
> site
> > >has anonymous access NOT checked and Windows Integration selected. I'm
> > >logged onto my machine with my domain account and when I try to deploy
my
> > >reports in VS 2003 I get "The underlying connection was closed: Could
not
> > >establish trust relationship with remote server." I do NOT have
"Require
> > >SSL" turned on and I know it has something to do with the way my
> credentials
> > >are being passed (or not passed). If I turn on the option to allow
> > >anonymous access to the reportserver site then I get a message that my
> > >IUSR_<machinename> has insufficient privleges to perform the actions,
> which
> > >is fine I don't want anonymous access on anyway.
> > >
> > >How do I resolve deploying reports to the report server with my domain
> > >account? I used the same domain account to install SQL Server and
> Reporting
> > >Services and I am a local administrator on the server.
> > >
> > >Thanks, Chris
> > >
> >
>
Deployment Questions
I am planning to install/deploy SQL Reporting Services at our agency.
We have a web server, a SQL Server (Enterprise license), and various
other servers. I know that the RS database has to be installed on a
server with SQL Server 2000 license, but is it also advisable to
install the report server components on the SQL Server box? This would
entail putting IIS on the SQL Server machine, and I'm not sure that
this is a good idea...
Basically, I am looking for "best practices" for a standard deployment
of RS. At this point, we will be running our application over our
local intranet, and will only have about 20 users.Hello Jad,
Just to note. Installing Reporting Services on the same server running SQL
Server 2000 is not a requirement. During Setup, you can choose whether to
create the report server database on a local or remote SQL Server instance.
Take a peek at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_8jom.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_8k82.asp
Adrian M.
"JAD" <jdevilli@.lasers.state.la.us> wrote in message
news:1106087493.051954.122790@.c13g2000cwb.googlegroups.com...
>I am planning to install/deploy SQL Reporting Services at our agency.
> We have a web server, a SQL Server (Enterprise license), and various
> other servers. I know that the RS database has to be installed on a
> server with SQL Server 2000 license, but is it also advisable to
> install the report server components on the SQL Server box? This would
> entail putting IIS on the SQL Server machine, and I'm not sure that
> this is a good idea...
> Basically, I am looking for "best practices" for a standard deployment
> of RS. At this point, we will be running our application over our
> local intranet, and will only have about 20 users.
>|||You can deploy reports just by right click on the project and select
deploying to the desired report server.
Or you can use scripts for deploying reports.
Another method is uploading the rdl on the report server.
The first one is easier but the developer should be an admin of the report
server.
Eralper
http://www.kodyaz.com
"JAD" wrote:
> I am planning to install/deploy SQL Reporting Services at our agency.
> We have a web server, a SQL Server (Enterprise license), and various
> other servers. I know that the RS database has to be installed on a
> server with SQL Server 2000 license, but is it also advisable to
> install the report server components on the SQL Server box? This would
> entail putting IIS on the SQL Server machine, and I'm not sure that
> this is a good idea...
> Basically, I am looking for "best practices" for a standard deployment
> of RS. At this point, we will be running our application over our
> local intranet, and will only have about 20 users.
>
We have a web server, a SQL Server (Enterprise license), and various
other servers. I know that the RS database has to be installed on a
server with SQL Server 2000 license, but is it also advisable to
install the report server components on the SQL Server box? This would
entail putting IIS on the SQL Server machine, and I'm not sure that
this is a good idea...
Basically, I am looking for "best practices" for a standard deployment
of RS. At this point, we will be running our application over our
local intranet, and will only have about 20 users.Hello Jad,
Just to note. Installing Reporting Services on the same server running SQL
Server 2000 is not a requirement. During Setup, you can choose whether to
create the report server database on a local or remote SQL Server instance.
Take a peek at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_8jom.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_8k82.asp
Adrian M.
"JAD" <jdevilli@.lasers.state.la.us> wrote in message
news:1106087493.051954.122790@.c13g2000cwb.googlegroups.com...
>I am planning to install/deploy SQL Reporting Services at our agency.
> We have a web server, a SQL Server (Enterprise license), and various
> other servers. I know that the RS database has to be installed on a
> server with SQL Server 2000 license, but is it also advisable to
> install the report server components on the SQL Server box? This would
> entail putting IIS on the SQL Server machine, and I'm not sure that
> this is a good idea...
> Basically, I am looking for "best practices" for a standard deployment
> of RS. At this point, we will be running our application over our
> local intranet, and will only have about 20 users.
>|||You can deploy reports just by right click on the project and select
deploying to the desired report server.
Or you can use scripts for deploying reports.
Another method is uploading the rdl on the report server.
The first one is easier but the developer should be an admin of the report
server.
Eralper
http://www.kodyaz.com
"JAD" wrote:
> I am planning to install/deploy SQL Reporting Services at our agency.
> We have a web server, a SQL Server (Enterprise license), and various
> other servers. I know that the RS database has to be installed on a
> server with SQL Server 2000 license, but is it also advisable to
> install the report server components on the SQL Server box? This would
> entail putting IIS on the SQL Server machine, and I'm not sure that
> this is a good idea...
> Basically, I am looking for "best practices" for a standard deployment
> of RS. At this point, we will be running our application over our
> local intranet, and will only have about 20 users.
>
Deployment problem to production server
I just started using reporting services and have a set of reports done that works on VS2005, however I am struggling with how to deploy this to a production server. The production server does not have a public presnet on the web. If I copy the directory to the production machine it does not work. I realzie that somehow I need to update the report database on the production machine but am lost about how to do that if I cannot connect to the machine from VS2005. I also tried the upload function in report manager.
How do I get my reports onto this box? Surely there is a way to do this without having to have a connection from VS2005. If you do applications that you want to ship to remote users there must be a way to do this.
Thanks
Chuck
In an effort to see how this works I took the reports database from my devleopment machine and installed it onto the server using SQL backup / restore. Does this break the reports database? Do I have to uninstall the reporting services using the SQL install tool or is there a way to recreate the database without doing the SQL uninstall reinstall?
Thanks
Chuck
deployment not working
I have a freshly installed reporting server/sql server and I have an older
visual studio reporting project.
Now I wanted to change the deployment url to the new server, but whenever I
try to deploy I get the message: "The permissions granted to user 'user' are
insufficient for performing this operation."
What permissions and where do I need to change to get this right?Give the user 'user' the Content Manager role on the folder to which you
want to deploy.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Servé La" <blabla@.bestaatniet.nl> wrote in message
news:O0%23tvvk$EHA.2580@.TK2MSFTNGP15.phx.gbl...
>I have a freshly installed reporting server/sql server and I have an older
> visual studio reporting project.
> Now I wanted to change the deployment url to the new server, but whenever
> I
> try to deploy I get the message: "The permissions granted to user 'user'
> are
> insufficient for performing this operation."
> What permissions and where do I need to change to get this right?
>
visual studio reporting project.
Now I wanted to change the deployment url to the new server, but whenever I
try to deploy I get the message: "The permissions granted to user 'user' are
insufficient for performing this operation."
What permissions and where do I need to change to get this right?Give the user 'user' the Content Manager role on the folder to which you
want to deploy.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Servé La" <blabla@.bestaatniet.nl> wrote in message
news:O0%23tvvk$EHA.2580@.TK2MSFTNGP15.phx.gbl...
>I have a freshly installed reporting server/sql server and I have an older
> visual studio reporting project.
> Now I wanted to change the deployment url to the new server, but whenever
> I
> try to deploy I get the message: "The permissions granted to user 'user'
> are
> insufficient for performing this operation."
> What permissions and where do I need to change to get this right?
>
Deployment issue SSRS 2000 reports on Production server
Hi All,
I am facing the issue while deploying Reporting Services 2000 Reports in
Production environment (Windows NT Server and SQL Server 2000) in our
application.
Background: I developed few reports using SQL Server Reporting Services 2000
and are able to deploy in Development environment and those reports are
working fine without any issues.
When we are trying to deploy the same in our Production environment, then we
are facing some issue during the deployment time and not able to deploy those
reports into it. We are followed 3 ways to deploy the same as mentioned below:
Method 1: From Application or report manager screen
(http://servername/reports or http://localhost/reports ) we are trying to
deploy / uploads all the reports one by one, then we are getting the error at
the time of upload as â'The underlying connection was closed: Could not
establish trust relationship with remote server.â'
Method 2: From Reports Designer window, we set build mode as â'Productionâ'
and set all the project environments as Production environment and made a
build and then made deploy. After that we are getting an error as "A
Connection could not be made to the report server
http://servername/reportserver". Later we manually copying all the reports
into Production environment and trying to open the reports, then we are not
able to open / call those reports from our application. Here we could not
able to connect or do not know what to do after copying of the reports into
physical environment of the application.
Method 3: We search thru google and few forums, and then we got to know that
we can deploy reports from the script also. So we tried to do the same as per
their instructions, then we got the error in command prompt as below:
E:\New Folder\Files\Dev2.0\ProfessionalServices\REPORTS>rs -i ps_reports.rss
â's http://servername/reportserver -v parentfolder="DBDReports"
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The command completed successfully
Kindly help us to resolve this issue and thanks in advance for your help.
Regards,
nsbThe best way to work this out is from the development environment. You can
deploy a single report by doing a right mouse click on the report and
deploy. What error if any are you getting? Do you have the rights to
publish? One easy thing to try in that regard is to add your user to the
local adminstrators group on the server.
I am betting that you are not part of the administrators group and you were
on the development server. You need to have someone who is in that group to
add you to the appropriate roll in RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"nsb" <nsb@.discussions.microsoft.com> wrote in message
news:8327C9F9-4320-4D0B-84F2-B636A0CAC04C@.microsoft.com...
> Hi All,
> I am facing the issue while deploying Reporting Services 2000 Reports in
> Production environment (Windows NT Server and SQL Server 2000) in our
> application.
> Background: I developed few reports using SQL Server Reporting Services
> 2000
> and are able to deploy in Development environment and those reports are
> working fine without any issues.
> When we are trying to deploy the same in our Production environment, then
> we
> are facing some issue during the deployment time and not able to deploy
> those
> reports into it. We are followed 3 ways to deploy the same as mentioned
> below:
> Method 1: From Application or report manager screen
> (http://servername/reports or http://localhost/reports ) we are trying to
> deploy / uploads all the reports one by one, then we are getting the error
> at
> the time of upload as "The underlying connection was closed: Could not
> establish trust relationship with remote server."
> Method 2: From Reports Designer window, we set build mode as "Production"
> and set all the project environments as Production environment and made a
> build and then made deploy. After that we are getting an error as "A
> Connection could not be made to the report server
> http://servername/reportserver". Later we manually copying all the reports
> into Production environment and trying to open the reports, then we are
> not
> able to open / call those reports from our application. Here we could not
> able to connect or do not know what to do after copying of the reports
> into
> physical environment of the application.
> Method 3: We search thru google and few forums, and then we got to know
> that
> we can deploy reports from the script also. So we tried to do the same as
> per
> their instructions, then we got the error in command prompt as below:
> E:\New Folder\Files\Dev2.0\ProfessionalServices\REPORTS>rs -i
> ps_reports.rss
> -s http://servername/reportserver -v parentfolder="DBDReports"
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The command completed successfully
> Kindly help us to resolve this issue and thanks in advance for your help.
> Regards,
> nsb
I am facing the issue while deploying Reporting Services 2000 Reports in
Production environment (Windows NT Server and SQL Server 2000) in our
application.
Background: I developed few reports using SQL Server Reporting Services 2000
and are able to deploy in Development environment and those reports are
working fine without any issues.
When we are trying to deploy the same in our Production environment, then we
are facing some issue during the deployment time and not able to deploy those
reports into it. We are followed 3 ways to deploy the same as mentioned below:
Method 1: From Application or report manager screen
(http://servername/reports or http://localhost/reports ) we are trying to
deploy / uploads all the reports one by one, then we are getting the error at
the time of upload as â'The underlying connection was closed: Could not
establish trust relationship with remote server.â'
Method 2: From Reports Designer window, we set build mode as â'Productionâ'
and set all the project environments as Production environment and made a
build and then made deploy. After that we are getting an error as "A
Connection could not be made to the report server
http://servername/reportserver". Later we manually copying all the reports
into Production environment and trying to open the reports, then we are not
able to open / call those reports from our application. Here we could not
able to connect or do not know what to do after copying of the reports into
physical environment of the application.
Method 3: We search thru google and few forums, and then we got to know that
we can deploy reports from the script also. So we tried to do the same as per
their instructions, then we got the error in command prompt as below:
E:\New Folder\Files\Dev2.0\ProfessionalServices\REPORTS>rs -i ps_reports.rss
â's http://servername/reportserver -v parentfolder="DBDReports"
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The command completed successfully
Kindly help us to resolve this issue and thanks in advance for your help.
Regards,
nsbThe best way to work this out is from the development environment. You can
deploy a single report by doing a right mouse click on the report and
deploy. What error if any are you getting? Do you have the rights to
publish? One easy thing to try in that regard is to add your user to the
local adminstrators group on the server.
I am betting that you are not part of the administrators group and you were
on the development server. You need to have someone who is in that group to
add you to the appropriate roll in RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"nsb" <nsb@.discussions.microsoft.com> wrote in message
news:8327C9F9-4320-4D0B-84F2-B636A0CAC04C@.microsoft.com...
> Hi All,
> I am facing the issue while deploying Reporting Services 2000 Reports in
> Production environment (Windows NT Server and SQL Server 2000) in our
> application.
> Background: I developed few reports using SQL Server Reporting Services
> 2000
> and are able to deploy in Development environment and those reports are
> working fine without any issues.
> When we are trying to deploy the same in our Production environment, then
> we
> are facing some issue during the deployment time and not able to deploy
> those
> reports into it. We are followed 3 ways to deploy the same as mentioned
> below:
> Method 1: From Application or report manager screen
> (http://servername/reports or http://localhost/reports ) we are trying to
> deploy / uploads all the reports one by one, then we are getting the error
> at
> the time of upload as "The underlying connection was closed: Could not
> establish trust relationship with remote server."
> Method 2: From Reports Designer window, we set build mode as "Production"
> and set all the project environments as Production environment and made a
> build and then made deploy. After that we are getting an error as "A
> Connection could not be made to the report server
> http://servername/reportserver". Later we manually copying all the reports
> into Production environment and trying to open the reports, then we are
> not
> able to open / call those reports from our application. Here we could not
> able to connect or do not know what to do after copying of the reports
> into
> physical environment of the application.
> Method 3: We search thru google and few forums, and then we got to know
> that
> we can deploy reports from the script also. So we tried to do the same as
> per
> their instructions, then we got the error in command prompt as below:
> E:\New Folder\Files\Dev2.0\ProfessionalServices\REPORTS>rs -i
> ps_reports.rss
> -s http://servername/reportserver -v parentfolder="DBDReports"
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The command completed successfully
> Kindly help us to resolve this issue and thanks in advance for your help.
> Regards,
> nsb
Wednesday, March 21, 2012
Deployment Errors
Hi, I'm new to Reporting Services. However, I am sa on the reporting
services database server and also admin rights on the server. I deployed my
report to the reporting services server without errors, however someone else
(not sa equivalent on the database, and not admin equivalent) cannot deploy
because they get permission errors.
Any ideas? Thanks in advance.Read up on roles. Security works in RS via assigning user or groups to
roles. By default the administrators group of the server is in a role which
is why everything works for you. What I do is create local groups and to
that group I add domain users/groups. Then I assign that local group to a
role (this is done in Report Manager).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RichieRich" <RichieRich@.discussions.microsoft.com> wrote in message
news:221820BB-1DF3-4C08-8E73-2F0B6F4DC2A2@.microsoft.com...
> Hi, I'm new to Reporting Services. However, I am sa on the reporting
> services database server and also admin rights on the server. I deployed
> my
> report to the reporting services server without errors, however someone
> else
> (not sa equivalent on the database, and not admin equivalent) cannot
> deploy
> because they get permission errors.
> Any ideas? Thanks in advance.|||Thanks. I'll try it. I completed the MS Course 2030A Creating Reporting
Solutions, but can you recommend any other courses?
Thanks.
"Bruce L-C [MVP]" wrote:
> Read up on roles. Security works in RS via assigning user or groups to
> roles. By default the administrators group of the server is in a role which
> is why everything works for you. What I do is create local groups and to
> that group I add domain users/groups. Then I assign that local group to a
> role (this is done in Report Manager).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RichieRich" <RichieRich@.discussions.microsoft.com> wrote in message
> news:221820BB-1DF3-4C08-8E73-2F0B6F4DC2A2@.microsoft.com...
> > Hi, I'm new to Reporting Services. However, I am sa on the reporting
> > services database server and also admin rights on the server. I deployed
> > my
> > report to the reporting services server without errors, however someone
> > else
> > (not sa equivalent on the database, and not admin equivalent) cannot
> > deploy
> > because they get permission errors.
> >
> > Any ideas? Thanks in advance.
>
>|||Sorry. Not familiar with the course. I would recommend buying some books.
There are several good ones. Two I have are Hitchhiker's Guide to SQL Server
2000 Reporting Services and Microsoft Reporting Services In Action.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RichieRich" <RichieRich@.discussions.microsoft.com> wrote in message
news:058E276C-0DE6-4667-8D98-8B1226CA224D@.microsoft.com...
> Thanks. I'll try it. I completed the MS Course 2030A Creating Reporting
> Solutions, but can you recommend any other courses?
> Thanks.
> "Bruce L-C [MVP]" wrote:
>> Read up on roles. Security works in RS via assigning user or groups to
>> roles. By default the administrators group of the server is in a role
>> which
>> is why everything works for you. What I do is create local groups and to
>> that group I add domain users/groups. Then I assign that local group to a
>> role (this is done in Report Manager).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "RichieRich" <RichieRich@.discussions.microsoft.com> wrote in message
>> news:221820BB-1DF3-4C08-8E73-2F0B6F4DC2A2@.microsoft.com...
>> > Hi, I'm new to Reporting Services. However, I am sa on the reporting
>> > services database server and also admin rights on the server. I
>> > deployed
>> > my
>> > report to the reporting services server without errors, however someone
>> > else
>> > (not sa equivalent on the database, and not admin equivalent) cannot
>> > deploy
>> > because they get permission errors.
>> >
>> > Any ideas? Thanks in advance.
>>
services database server and also admin rights on the server. I deployed my
report to the reporting services server without errors, however someone else
(not sa equivalent on the database, and not admin equivalent) cannot deploy
because they get permission errors.
Any ideas? Thanks in advance.Read up on roles. Security works in RS via assigning user or groups to
roles. By default the administrators group of the server is in a role which
is why everything works for you. What I do is create local groups and to
that group I add domain users/groups. Then I assign that local group to a
role (this is done in Report Manager).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RichieRich" <RichieRich@.discussions.microsoft.com> wrote in message
news:221820BB-1DF3-4C08-8E73-2F0B6F4DC2A2@.microsoft.com...
> Hi, I'm new to Reporting Services. However, I am sa on the reporting
> services database server and also admin rights on the server. I deployed
> my
> report to the reporting services server without errors, however someone
> else
> (not sa equivalent on the database, and not admin equivalent) cannot
> deploy
> because they get permission errors.
> Any ideas? Thanks in advance.|||Thanks. I'll try it. I completed the MS Course 2030A Creating Reporting
Solutions, but can you recommend any other courses?
Thanks.
"Bruce L-C [MVP]" wrote:
> Read up on roles. Security works in RS via assigning user or groups to
> roles. By default the administrators group of the server is in a role which
> is why everything works for you. What I do is create local groups and to
> that group I add domain users/groups. Then I assign that local group to a
> role (this is done in Report Manager).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RichieRich" <RichieRich@.discussions.microsoft.com> wrote in message
> news:221820BB-1DF3-4C08-8E73-2F0B6F4DC2A2@.microsoft.com...
> > Hi, I'm new to Reporting Services. However, I am sa on the reporting
> > services database server and also admin rights on the server. I deployed
> > my
> > report to the reporting services server without errors, however someone
> > else
> > (not sa equivalent on the database, and not admin equivalent) cannot
> > deploy
> > because they get permission errors.
> >
> > Any ideas? Thanks in advance.
>
>|||Sorry. Not familiar with the course. I would recommend buying some books.
There are several good ones. Two I have are Hitchhiker's Guide to SQL Server
2000 Reporting Services and Microsoft Reporting Services In Action.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RichieRich" <RichieRich@.discussions.microsoft.com> wrote in message
news:058E276C-0DE6-4667-8D98-8B1226CA224D@.microsoft.com...
> Thanks. I'll try it. I completed the MS Course 2030A Creating Reporting
> Solutions, but can you recommend any other courses?
> Thanks.
> "Bruce L-C [MVP]" wrote:
>> Read up on roles. Security works in RS via assigning user or groups to
>> roles. By default the administrators group of the server is in a role
>> which
>> is why everything works for you. What I do is create local groups and to
>> that group I add domain users/groups. Then I assign that local group to a
>> role (this is done in Report Manager).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "RichieRich" <RichieRich@.discussions.microsoft.com> wrote in message
>> news:221820BB-1DF3-4C08-8E73-2F0B6F4DC2A2@.microsoft.com...
>> > Hi, I'm new to Reporting Services. However, I am sa on the reporting
>> > services database server and also admin rights on the server. I
>> > deployed
>> > my
>> > report to the reporting services server without errors, however someone
>> > else
>> > (not sa equivalent on the database, and not admin equivalent) cannot
>> > deploy
>> > because they get permission errors.
>> >
>> > Any ideas? Thanks in advance.
>>
Deployment error
HI,
I am using .NET 2003 on my pc. I installed reporting services 2000 on my pc as well.
I have a remote computer (server) with sql 2000.
I created a report using the reporting services, and now I want to deploy it to the report server.
When I do it I get: " The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing"
I dont know how to configure reporting services, I know how to create reports, so i hope you can help me step by step.
For a strat I wish you can help me configure it to work om my pc (I installed sql 2000 on my pc as well)
Thanks,
Target Folder: ReportServer
TargetServerURL:http://127.0.0.1/ReportServer
Double check the datasource you are using. Go into the properties of the datasource, click edit, then 'Test Connection'. Probably a worth a check.deployment and reports
Hi,
When I deploy a report i am assuming the report is deployed to the reporting service DB (ReportServer). Then when i try to view report in a browser I presume the following happens:
Navigate to http://localhost/Reports and click report you want to view
A web service call is made to retrieve report data from a DB eg Northwind
The data is the rendered based on the defined formatting in the RDL file and displayed in browser.
If this is correct does anyone known where the report is deployed to (DB or Web service) I cannot see the rdl files in any of these places and if I delete my project report viewing still works.
I know you can view all reports if you are in SQL management studio and go connect->reporting services but this is not a DB. Is this the web service and if so why cant i see files in IIS?
Thanks for replies
It's because they're not stored as files. When you deploy any files to the report server, they are stored in a table called Catalog and are serialized into an image column called Content.
Report Manager, Management Studio or whatever just connect to the web service and query it about which reports are stored in the database. The web service is basically the interface into the database.
Deployment
Hello,
I was reading some article which said, the reporting service (sql server 2005)does
not have many capabilities and so, after initial development of reports you
can deploy it to a custom website or an application and then use .net to
enhance report functionalities...
How to do this..Please help me.!
Thanks,Shankar - do you have a specific question about deployment?
Reporting services provides for many reporting capabilities and deployment options. These are documented in the Books Online that comes with the product. Please use this as your first reference when evaluating the product's capabilities.
Good luck,
-Lukasz|||Hi,
When reading the Books Online for SQL Server 2000 Reporting Services I can see two different ways for deployment described.
1. Deploy from Report Designer
2. Upload files in Report Manager
Is there any way to automate the deployment in this version by using MSI or some other 'deployment' product?
// Jarle|||
Yes - the report server provides a
There is a sample script that comes with the RS installation. Also, the
Hope that help,
-
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks for the help!
// Jarle|||
I have tried to create a script in MS SQL Server Management Studio that uploads Excel to SRS.
(I shortened the numbers that represent the excel file for brevity)
Public Overridable Sub Main()
CreateResource
End Sub
Private Sub CreateResource()
Dim Resource As String = "CARDAPPTS"
Dim Parent As String = "/Cardiology/Weekly Appointments"
Dim Overwrite As Boolean = true
Dim Contents() As Byte = New Byte() {208, 207, 17, 224, 161, 177, 26, 225, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 62, 0, 3, 0, 254, 255, 9, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 113, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 254, 255, 255, 255, 0, 0, 0, 0, 254, 255, 255, 255, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 96, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 5, 0, 68, 0, 111, 0, 99, 0, 117, 0, 109, 0, 101, 0, 110, 0, 116, 0, 83, 0, 117, 0, 109, 0, 109, 0, 97, 0, 114, 0, 121, 0, 73, 0, 110, 0, 102, 0, 111, 0, 114, 0, 109, 0, 97, 0, 116, 0, 105, 0, 111, 0, 110, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56, 0, 2, 1, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 104, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0}
Dim MimeType As String = "application/vnd.ms-excel"
Dim Properties(-1) As Microsoft.SqlServer.ReportingServices2005.[Property]
RS.CreateResource(Resource, Parent, Overwrite, Contents, MimeType, Properties)
End Sub
When I try to run it with rs.exe, I get error: BC30451: Name 'Contents' is not declaired.
Is there a way to automate uploading Excel files using rs.exe?
I am trying to avoid uploading 500 spreadsheets manually through the MS SQL Server Management Studio. (We are doing this in the interim until the 500 reports can be built in RS)
Any help is appreciated.
sqlDeployment
Hello,
I was reading some article which said, the reporting service (sql server 2005)does
not have many capabilities and so, after initial development of reports you
can deploy it to a custom website or an application and then use .net to
enhance report functionalities...
How to do this..Please help me.!
Thanks,Shankar - do you have a specific question about deployment?
Reporting services provides for many reporting capabilities and deployment options. These are documented in the Books Online that comes with the product. Please use this as your first reference when evaluating the product's capabilities.
Good luck,
-Lukasz|||Hi,
When reading the Books Online for SQL Server 2000 Reporting Services I can see two different ways for deployment described.
1. Deploy from Report Designer
2. Upload files in Report Manager
Is there any way to automate the deployment in this version by using MSI or some other 'deployment' product?
// Jarle|||
Yes - the report server provides a
There is a sample script that comes with the RS installation. Also, the
Hope that help,
-
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks for the help!
// Jarle
Deployment
Hello,
I was reading some article which said, the reporting service (sql server 2005)does
not have many capabilities and so, after initial development of reports you
can deploy it to a custom website or an application and then use .net to
enhance report functionalities...
How to do this..Please help me.!
Thanks,Shankar - do you have a specific question about deployment?
Reporting services provides for many reporting capabilities and deployment options. These are documented in the Books Online that comes with the product. Please use this as your first reference when evaluating the product's capabilities.
Good luck,
-Lukasz|||Hi,
When reading the Books Online for SQL Server 2000 Reporting Services I can see two different ways for deployment described.
1. Deploy from Report Designer
2. Upload files in Report Manager
Is there any way to automate the deployment in this version by using MSI or some other 'deployment' product?
// Jarle|||
Yes - the report server provides a
There is a sample script that comes with the RS installation. Also, the
Hope that help,
-
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks for the help!
// Jarle|||
I have tried to create a script in MS SQL Server Management Studio that uploads Excel to SRS.
(I shortened the numbers that represent the excel file for brevity)
Public Overridable Sub Main()
CreateResource
End Sub
Private Sub CreateResource()
Dim Resource As String = "CARDAPPTS"
Dim Parent As String = "/Cardiology/Weekly Appointments"
Dim Overwrite As Boolean = true
Dim Contents() As Byte = New Byte() {208, 207, 17, 224, 161, 177, 26, 225, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 62, 0, 3, 0, 254, 255, 9, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 113, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 254, 255, 255, 255, 0, 0, 0, 0, 254, 255, 255, 255, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 96, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 5, 0, 68, 0, 111, 0, 99, 0, 117, 0, 109, 0, 101, 0, 110, 0, 116, 0, 83, 0, 117, 0, 109, 0, 109, 0, 97, 0, 114, 0, 121, 0, 73, 0, 110, 0, 102, 0, 111, 0, 114, 0, 109, 0, 97, 0, 116, 0, 105, 0, 111, 0, 110, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56, 0, 2, 1, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 104, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0}
Dim MimeType As String = "application/vnd.ms-excel"
Dim Properties(-1) As Microsoft.SqlServer.ReportingServices2005.[Property]
RS.CreateResource(Resource, Parent, Overwrite, Contents, MimeType, Properties)
End Sub
When I try to run it with rs.exe, I get error: BC30451: Name 'Contents' is not declaired.
Is there a way to automate uploading Excel files using rs.exe?
I am trying to avoid uploading 500 spreadsheets manually through the MS SQL Server Management Studio. (We are doing this in the interim until the 500 reports can be built in RS)
Any help is appreciated.
Deployment
I'm working through Ch 3 of "SQL Server 2005 Reporting Services Step by Step" by Stacia Misner, published by Microsoft Press, but I can't get the example report in Ch3 to deploy. I get a long error message, which says this:
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://localhost/ReportServer.
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)
at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)
at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()
at Microsoft.ReportingServices.WebServer.Global.StartApp()
at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul>
<li>Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.ReportingServices.Designer)
BUTTONS:
OK
This is your problem:
<li>Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>
Looks like the account that SSRS is running under doesn't have permissions on \ReportServer. Make sure the account in question can read from the folder.
|||Thanks, but it still doesn't work even with admin permissions. I restarted IIS and RS and that reduced the error to the following:
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://localhost/ReportServer.
ADDITIONAL INFORMATION:
Unable to connect to the remote server (Microsoft.ReportingServices.Designer)
No connection could be made because the target machine actively refused it (System)
BUTTONS:
OK|||
I went to the Surface Area Configuration for Features and Reporting Services is enabled. But when I select "Windows Integrated Security" I get this error:
TITLE: Surface Area Configuration
Unable to connect to the remote server (System)
ADDITIONAL INFORMATION:
No connection could be made because the target machine actively refused it (System)
BUTTONS:
OK|||I should mention that I have SQL Server 2005 installed on my machine and am trying to deploy to it. I'm not working over a net.|||
Hey Roger,
Did you ever find a solution or cause to your problem? I am now experiencing the same problem.
I am not trying to deploy a report, rather install SQL 2005 SP1, which fails stating I could not authenticate to all instances. Then, when poking around in the Surface Area Configuration Manager, clicking on SQL Server Reporting Services - Windows Integrated Security, I get the same error you get:
"Unable to connect to remote server (System)"
"A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond (System)"
Thanks!
Dan
Deployment
I'm working through Ch 3 of "SQL Server 2005 Reporting Services Step by Step" by Stacia Misner, published by Microsoft Press, but I can't get the example report in Ch3 to deploy. I get a long error message, which says this:
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://localhost/ReportServer.
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)
at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)
at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()
at Microsoft.ReportingServices.WebServer.Global.StartApp()
at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul>
<li>Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.ReportingServices.Designer)
BUTTONS:
OK
This is your problem:
<li>Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>
Looks like the account that SSRS is running under doesn't have permissions on \ReportServer. Make sure the account in question can read from the folder.
|||Thanks, but it still doesn't work even with admin permissions. I restarted IIS and RS and that reduced the error to the following:
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://localhost/ReportServer.
ADDITIONAL INFORMATION:
Unable to connect to the remote server (Microsoft.ReportingServices.Designer)
No connection could be made because the target machine actively refused it (System)
BUTTONS:
OK
|||I went to the Surface Area Configuration for Features and Reporting Services is enabled. But when I select "Windows Integrated Security" I get this error:
TITLE: Surface Area Configuration
Unable to connect to the remote server (System)
ADDITIONAL INFORMATION:
No connection could be made because the target machine actively refused it (System)
BUTTONS:
OK
|||I should mention that I have SQL Server 2005 installed on my machine and am trying to deploy to it. I'm not working over a net.|||Hey Roger,
Did you ever find a solution or cause to your problem? I am now experiencing the same problem.
I am not trying to deploy a report, rather install SQL 2005 SP1, which fails stating I could not authenticate to all instances. Then, when poking around in the Surface Area Configuration Manager, clicking on SQL Server Reporting Services - Windows Integrated Security, I get the same error you get:
"Unable to connect to remote server (System)"
"A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond (System)"
Thanks!
Dan
Deployment
I'm working through Ch 3 of "SQL Server 2005 Reporting Services Step by Step" by Stacia Misner, published by Microsoft Press, but I can't get the example report in Ch3 to deploy. I get a long error message, which says this:
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://localhost/ReportServer.
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)
at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)
at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()
at Microsoft.ReportingServices.WebServer.Global.StartApp()
at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul>
<li>Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.ReportingServices.Designer)
BUTTONS:
OK
This is your problem:
<li>Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>
Looks like the account that SSRS is running under doesn't have permissions on \ReportServer. Make sure the account in question can read from the folder.
|||Thanks, but it still doesn't work even with admin permissions. I restarted IIS and RS and that reduced the error to the following:
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://localhost/ReportServer.
ADDITIONAL INFORMATION:
Unable to connect to the remote server (Microsoft.ReportingServices.Designer)
No connection could be made because the target machine actively refused it (System)
BUTTONS:
OK|||
I went to the Surface Area Configuration for Features and Reporting Services is enabled. But when I select "Windows Integrated Security" I get this error:
TITLE: Surface Area Configuration
Unable to connect to the remote server (System)
ADDITIONAL INFORMATION:
No connection could be made because the target machine actively refused it (System)
BUTTONS:
OK|||I should mention that I have SQL Server 2005 installed on my machine and am trying to deploy to it. I'm not working over a net.|||
Hey Roger,
Did you ever find a solution or cause to your problem? I am now experiencing the same problem.
I am not trying to deploy a report, rather install SQL 2005 SP1, which fails stating I could not authenticate to all instances. Then, when poking around in the Surface Area Configuration Manager, clicking on SQL Server Reporting Services - Windows Integrated Security, I get the same error you get:
"Unable to connect to remote server (System)"
"A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond (System)"
Thanks!
Dan
sqlDeployment
Hello,
What is the best way to deploy a Reporting Services solution. The solution
consists of database scripts, reports, CRI dll's and roles.
Thanks
HenrikHello Henrik,
I am not sure what does your solution include.
Based on my research and experience, you need to deploy those data
seperately.
For example, you need to run all the database scripts on the production
environment and then, you could use the VS 2005 IDE to deploy the report.
I am not sure what did you mean CRI dll and roles. Would you please specify
it more clearly?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hello Wei Lu,
We have a solution that contains the following elements:
1) SQL Scripts, which create views, tables, ect.
2) Custom Report Items (CRI) which is contained in a DLL
3) Reports (RDL files)
4) Reporting Services User Roles
5) Datasources
6) Setup of policies (permissions) on each report
We have to package the solution and deploy it to multiple customers.
Best regards
Henrik.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:OnGVeBD7GHA.2336@.TK2MSFTNGXA01.phx.gbl...
> Hello Henrik,
> I am not sure what does your solution include.
> Based on my research and experience, you need to deploy those data
> seperately.
> For example, you need to run all the database scripts on the production
> environment and then, you could use the VS 2005 IDE to deploy the report.
> I am not sure what did you mean CRI dll and roles. Would you please
> specify
> it more clearly?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Have you looked at MSI packages?
You could probably package most of the elements. MSI packages can be used
for SQL scripts, which covers element 1, and might cover element 4, 5 and 6
if you can do this through SQL. It can also install dlls, covering element
2. I've never tried using msi against a web service, but it should be
possible, and with the right setup of your package, you should be able to
either deploy your reports or at least trigger a rss-script (reporting
services script, not the blog rss :) ) that will deploy your reports.
A bit of information here
http://www.sqlmag.com/Article/ArticleID/22428/sql_server_22428.html
A more hands-on example and article here
http://www.csharp-home.com/index/tiki-read_article.php?articleId=152
If you decide on msi, please tell the NG what you do and how successful it
turns out.
Kaisa M. Lindahl Lervik
"Henrik Skak Pedersen" <skak@.community.nospam> wrote in message
news:eY0e8DE7GHA.4116@.TK2MSFTNGP03.phx.gbl...
> Hello Wei Lu,
> We have a solution that contains the following elements:
> 1) SQL Scripts, which create views, tables, ect.
> 2) Custom Report Items (CRI) which is contained in a DLL
> 3) Reports (RDL files)
> 4) Reporting Services User Roles
> 5) Datasources
> 6) Setup of policies (permissions) on each report
> We have to package the solution and deploy it to multiple customers.
> Best regards
> Henrik.
>
> "Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
> news:OnGVeBD7GHA.2336@.TK2MSFTNGXA01.phx.gbl...
>> Hello Henrik,
>> I am not sure what does your solution include.
>> Based on my research and experience, you need to deploy those data
>> seperately.
>> For example, you need to run all the database scripts on the production
>> environment and then, you could use the VS 2005 IDE to deploy the report.
>> I am not sure what did you mean CRI dll and roles. Would you please
>> specify
>> it more clearly?
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community Support
>> ==================================================>> Get notification to my posts through email? Please refer to
>> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
>> ications.
>> Note: The MSDN Managed Newsgroup support offering is for non-urgent
>> issues
>> where an initial response from the community or a Microsoft Support
>> Engineer within 1 business day is acceptable. Please note that each
>> follow
>> up response may take approximately 2 business days as the support
>> professional working with you may need further investigation to reach the
>> most efficient resolution. The offering is not appropriate for situations
>> that require urgent, real-time or phone-based interactions or complex
>> project analysis and dump analysis issues. Issues of this nature are best
>> handled working with a dedicated Microsoft Support Engineer by contacting
>> Microsoft Customer Support Services (CSS) at
>> http://msdn.microsoft.com/subscriptions/support/default.aspx.
>> ==================================================>> (This posting is provided "AS IS", with no warranties, and confers no
>> rights.)
>|||Hello Henrik,
I agreee with Kaisa.
You could setup a MSI package to deploy the SQL Script and use the RSS
script to deploy the Report.
Here are also some article for your reference:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsintro7/ht
ml/vbtskcreatinginstallerforyourapplication.asp
http://www.codeproject.com/dotnet/Win_App_Setup_Project.asp?df=100&forumid=2
50630&exp=0&select=1419048
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/
rsp_prog_soapapi_script_3ik1.asp
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
What is the best way to deploy a Reporting Services solution. The solution
consists of database scripts, reports, CRI dll's and roles.
Thanks
HenrikHello Henrik,
I am not sure what does your solution include.
Based on my research and experience, you need to deploy those data
seperately.
For example, you need to run all the database scripts on the production
environment and then, you could use the VS 2005 IDE to deploy the report.
I am not sure what did you mean CRI dll and roles. Would you please specify
it more clearly?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hello Wei Lu,
We have a solution that contains the following elements:
1) SQL Scripts, which create views, tables, ect.
2) Custom Report Items (CRI) which is contained in a DLL
3) Reports (RDL files)
4) Reporting Services User Roles
5) Datasources
6) Setup of policies (permissions) on each report
We have to package the solution and deploy it to multiple customers.
Best regards
Henrik.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:OnGVeBD7GHA.2336@.TK2MSFTNGXA01.phx.gbl...
> Hello Henrik,
> I am not sure what does your solution include.
> Based on my research and experience, you need to deploy those data
> seperately.
> For example, you need to run all the database scripts on the production
> environment and then, you could use the VS 2005 IDE to deploy the report.
> I am not sure what did you mean CRI dll and roles. Would you please
> specify
> it more clearly?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Have you looked at MSI packages?
You could probably package most of the elements. MSI packages can be used
for SQL scripts, which covers element 1, and might cover element 4, 5 and 6
if you can do this through SQL. It can also install dlls, covering element
2. I've never tried using msi against a web service, but it should be
possible, and with the right setup of your package, you should be able to
either deploy your reports or at least trigger a rss-script (reporting
services script, not the blog rss :) ) that will deploy your reports.
A bit of information here
http://www.sqlmag.com/Article/ArticleID/22428/sql_server_22428.html
A more hands-on example and article here
http://www.csharp-home.com/index/tiki-read_article.php?articleId=152
If you decide on msi, please tell the NG what you do and how successful it
turns out.
Kaisa M. Lindahl Lervik
"Henrik Skak Pedersen" <skak@.community.nospam> wrote in message
news:eY0e8DE7GHA.4116@.TK2MSFTNGP03.phx.gbl...
> Hello Wei Lu,
> We have a solution that contains the following elements:
> 1) SQL Scripts, which create views, tables, ect.
> 2) Custom Report Items (CRI) which is contained in a DLL
> 3) Reports (RDL files)
> 4) Reporting Services User Roles
> 5) Datasources
> 6) Setup of policies (permissions) on each report
> We have to package the solution and deploy it to multiple customers.
> Best regards
> Henrik.
>
> "Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
> news:OnGVeBD7GHA.2336@.TK2MSFTNGXA01.phx.gbl...
>> Hello Henrik,
>> I am not sure what does your solution include.
>> Based on my research and experience, you need to deploy those data
>> seperately.
>> For example, you need to run all the database scripts on the production
>> environment and then, you could use the VS 2005 IDE to deploy the report.
>> I am not sure what did you mean CRI dll and roles. Would you please
>> specify
>> it more clearly?
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community Support
>> ==================================================>> Get notification to my posts through email? Please refer to
>> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
>> ications.
>> Note: The MSDN Managed Newsgroup support offering is for non-urgent
>> issues
>> where an initial response from the community or a Microsoft Support
>> Engineer within 1 business day is acceptable. Please note that each
>> follow
>> up response may take approximately 2 business days as the support
>> professional working with you may need further investigation to reach the
>> most efficient resolution. The offering is not appropriate for situations
>> that require urgent, real-time or phone-based interactions or complex
>> project analysis and dump analysis issues. Issues of this nature are best
>> handled working with a dedicated Microsoft Support Engineer by contacting
>> Microsoft Customer Support Services (CSS) at
>> http://msdn.microsoft.com/subscriptions/support/default.aspx.
>> ==================================================>> (This posting is provided "AS IS", with no warranties, and confers no
>> rights.)
>|||Hello Henrik,
I agreee with Kaisa.
You could setup a MSI package to deploy the SQL Script and use the RSS
script to deploy the Report.
Here are also some article for your reference:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsintro7/ht
ml/vbtskcreatinginstallerforyourapplication.asp
http://www.codeproject.com/dotnet/Win_App_Setup_Project.asp?df=100&forumid=2
50630&exp=0&select=1419048
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/
rsp_prog_soapapi_script_3ik1.asp
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Posts (Atom)