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

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

Deployment of analysis services on windows 2003(Very urgent Please)

I have window 2000 as my development machine. I am using visual studio 2003 and sql server 2000.
I was able to develop a web application which uses the pivot table componant.
Every thing was working fine with out any problem.

I deployed my Project to windows 2003.
I am able to see the pivot table control.
I am not able to get any data into my pivot table.

I am not sure what is going wrong.
Is there anything I need to take care in windows 2003 specifically.

I don't have microsoft office on windows 2003.
Does it make a difference?

Please help!!!

Anil

Help Please|||

If you are using MSOWC for your pivot table component and if yout new server do not have riyhrt MSOWC installled or Office instaled,then you will not be able to view the data.

|||

MSOWC is already available on that machine.
I think the webservice is not able to contact the iis properly.
I have already setup the virtual directory for olap on IIS.

Any ideas

|||

Are you using the HTTP connection to Analysis Services or are you connection directly?

If you are connecting directly, what is the version of the MSOLAP80.dll? You may have to upgrade it to a service pack for Analysis Services.

Copy the MDX Sample Application exe to the 2003 machine and see if it can connect.

David

|||

Finally we narrow down the error it is with the fieldsets for the pivot table.

The web service is working fine if we remove the accessing fieldsets code.

When ever we tried to access the fieldsets in the cube we are getting error.

The error message is "Interop.OWC10 - Unspecified error ".

We installed service pack 4 on sql server.

I reinstalled the owc10 dll again.

I gave the permissions to the user machinename_iuser....

But nothing has solved my problem.

Please help.

|||

Hello. I have some doubts about if OWC:s work with HTTP unless you write some code to make them work. OWC are ActiveX controls and they use tcp/ip.

If you disable the SSAS Olap connection and publish an excel OWC OLAP- report in a folder on your IIS machine, will this work? This is to make sure that nothing else is causing these problems.

It is not recommended to develop on an older O/S than the server O/S, but you are probably aware of that now.

Also check that you are allowed to run programs in your IIS folder on Windows 2003.

In IIS/ Win2003 you can check what web service extensions that are allowed.

Regards

Thomas Ivarsson

|||

i am not sure how to disable the SSAS Olap connection and publish an excel OWC OLAP- report in a folder on your IIS machine.

Yes I am member in administrator group. I can run programs in my IIS folder.

Webservice has extensions allowed in iis are
Active Server Pages
ASP.Net v1.1.4322
Front Page server extensions
HwsMessages HttpReceive
Windows Sharepoint Services.

Regards
Anil

|||

Hello. Build a report from SSAS2000 in Excel and publish it to a webfolder on your IIS. I see that you have Sharepoint services. Upload your Excel SSAS2000 report to Sharepoint on Win2003 server.

Regards

Thomas Ivarsson

|||

I published it on iis and I am able to see all dimension but I am not able to see the fact table values.
I don't know what else to do.

Thanks So much for your help

Anil

|||

Here is link to a kb with your keywords(http://support.microsoft.com/kb/331400)

Regards

Thomas Ivarsson

Deployment issues

Hi All,

I am running SQL RS 2005 on Windows Server 2003

My client is XP sp2 with .NET 2005 Team

When I try to deploy a RS report to my web server I get an error;

Error 4 The permissions granted to user 'MyDomain\MyUser' are insufficient for performing this operation.

What folders/user/permissions need to be opened on the server so that I can deploy reports from my client machine?

regards,

Bill

Did you install SP1 for windows 2003 server?|||

I did.

SP1 for SQL Server as well.

Thing is, I had everything working fine a week ago. We had to uninstall SQL Server 2005. I put it back on today. No issues at all in the setup except for this.

|||Can no one tell me what permissions I need to deploy reports to the server, or is this really a rare issue?

Deployment issue : COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either not va

Hello,

I have a asp.net application that calls a DTS package. This application is running fine on my machine (where SQL Server and Web Server are running). When I moved the application to a Web Server, I am getting the following error due to the DTS package.

COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either not valid or not registered.

In my Bin folder, I do have the reference to the Interop.DTS.dll. The web server admin tells me that the dtsffile.dll, dtspkg.dll, dtspump.dll and axscphst.dll are registered onto the web server.

I am struggling to find the reasons for this. I have tried to replicate this error onto my machine to help me finding out the cause of this problem but in vain!

Can you help please?

Thank you.

Hello,

Just an update on this issue.
Basically, I have never been able to manage to sort this one out, despite viewing many articles on the net.

However, I just want to share one option to overcome this problem.

You can invoke your DTS package through a JOB using SP_START_JOB stored proc. This SP Instructs SQL Server Agent to execute a job immediately. This would do the job of executing the package!!! Of course, you will need the right to run the job.

Hope this helps.

Deployment issue : COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either no

Hello,

I have a asp.net application that calls a DTS package. This application is running fine on my machine (where SQL Server and Web Server are running). When I moved the application to a Web Server, I am getting the following error due to the DTS package.

COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either not valid or not registered.

In my Bin folder, I do have the reference to the Interop.DTS.dll. The web server admin tells me that the dtsffile.dll, dtspkg.dll, dtspump.dll and axscphst.dll are registered onto the web server.

I am struggling to find the reasons for this. I have tried to replicate this error onto my machine to help me finding out the cause of this problem but in vain!

Can you help please?

Thank you.

Hello,

Just an update on this issue.
Basically, I have never been able to manage to sort this one out, despite viewing many articles on the net.

However, I just want to share one option to overcome this problem.

You can invoke your DTS package through a JOB using SP_START_JOB stored proc. This SP Instructs SQL Server Agent to execute a job immediately. This would do the job of executing the package!!! Of course, you will need the right to run the job.

Hope this helps.

Deploying web app, which SQL files do I upload?..

I'm working on a web application that uses SQL Server 2000. Once I'm ready to upload my website to a production server, I need to know how to upload my SQL Server database files to the server. Are there actual files that can be uploaded? I've only deployed a website that works with MySQL to a production server, and there were no files to upload... the database had to be created on the server, and then the data itself had to be exported to text files (on my computer), then imported/uploaded to the production server using SQL statements...

How do I do this?

Thanks~::I need to know how to upload my SQL Server database files to the server.

Ask your provider, systemadministrator or whoever manages this.

Our hosting operation does NOT allow uploads of sql database fiules - you are supposed to create a new database and use the copy database wizard out of SQL Server's enterprise manager.|||hi
i saw http://europe.webmatrixhosting.net, do you know that all hosts provide like this host utilities to work with SQL Server? utilities like http://www.aspenterprisemanager.com??

i'm developing an asp.net storefront that uses SQL Server Database, but i'm worry about after developing that, i want to do what?!! how to manage my database?
tahnk

Deploying to a webserver

I'm confused...
I was able to get my Web Host to install Reporting Services.
I understand that after I deploy my reports to my Web Host's server, that
the URL I need would look something like this:
http://myWebHostServer/ReportServer
My question is: If my Web Host has dozens/hundreds of users (like me) who
want to utilize RS, are we all deploying to the same place? My URL (let's
say) is www.abc.com. In development, I have 10 reports in a folder called
RSReports. When I want to display Report1 to my user, will I be able to use:
http://www.abc.com/RSReports/Report1 ?
Also - when I want to manage my reports and use
http://myWebHostServer/ReportServer
will I see only my reports, or everybody else's as well'
Thanx
JerryAlthough the default installation does not allow this it is possible to
install it somewhere else. Check out gotdotnet, I think that is where I saw
the article.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JerryK" <JerryK@.discussions.microsoft.com> wrote in message
news:38602143-4FC4-4772-BD6D-B97E8596BFE1@.microsoft.com...
> I'm confused...
> I was able to get my Web Host to install Reporting Services.
> I understand that after I deploy my reports to my Web Host's server, that
> the URL I need would look something like this:
> http://myWebHostServer/ReportServer
> My question is: If my Web Host has dozens/hundreds of users (like me) who
> want to utilize RS, are we all deploying to the same place? My URL (let's
> say) is www.abc.com. In development, I have 10 reports in a folder called
> RSReports. When I want to display Report1 to my user, will I be able to
use:
> http://www.abc.com/RSReports/Report1 ?
> Also - when I want to manage my reports and use
> http://myWebHostServer/ReportServer
> will I see only my reports, or everybody else's as well'
> Thanx
> Jerry
>|||RS is installed as an application hosted in a virtual directory below the
root of an IIS web server, and the same interface is used to access reports
whether for viewing or managing.
The Report Manager effectively configures itself based on the windows
account you log in to the site with. There is a role based security model
built into RS and what you see when you log in depends on the role or roles
to which your host assigned to your account.
Whether you will see just your own reports or those of everyone else depends
on these roles. One would hope that the host has created a role just for you
and made sure that this role can only access your reports and that your
reports can only be accessed by this role, of which you are the only member.
The other possiblity is that your site is hosted on it's own IIS virtual
server and that they have installed reporting services within this virtual
server. In which case you effectively have your own Report Server.
As far as accessing the reports via a url, you can do this but it is not as
simple as extending the path to include the name of the report as you
suggest. The simplest way is to log in to Report Manager and navigate to the
report you want to view, when you do take a look at the status bar and you
will see what I mean about the url.
Hope this helps
Mike Hanson
"JerryK" wrote:
> I'm confused...
> I was able to get my Web Host to install Reporting Services.
> I understand that after I deploy my reports to my Web Host's server, that
> the URL I need would look something like this:
> http://myWebHostServer/ReportServer
> My question is: If my Web Host has dozens/hundreds of users (like me) who
> want to utilize RS, are we all deploying to the same place? My URL (let's
> say) is www.abc.com. In development, I have 10 reports in a folder called
> RSReports. When I want to display Report1 to my user, will I be able to use:
> http://www.abc.com/RSReports/Report1 ?
> Also - when I want to manage my reports and use
> http://myWebHostServer/ReportServer
> will I see only my reports, or everybody else's as well'
> Thanx
> Jerry
>

Deploying the Personal Web Site

Rank newbie to ASP.NET here, so I'm totally "at sea" as to finding a "cookbook" for "how to deploy" a slightly customized version of the "Personal Web Site" project.

My hosting service has an ASP.NET database installed. I can verify from their "SQL Server Web Admin" package that there are 11 "aspnet_" table names present. I have run the "personal-add.sql" script which has defined two (empty) tables -- "Albums" and "Photos".

CONFUSION 1: The hosting service includes a Help fille for "Connecting to a SQL Server Database Using ASP.NET 2.0" which details the way to add 'connectionStrings' for "Personal" and "LocalSqlServer". I have made a "remote" copy of the "web.config" file and supplied the ostensively correct info for my Server, Database, User ID and Password. QUESTION: Why are there TWO names -- "Personal" and "LocalSqlServer"? Since all of the tables are contained now within the ASP.NET database are the details for both of these to be the same?

CONFUSION 2: Error handling. I'm getting "An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine." Huh!? That page then goes on to mention "<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>". I've not a clue as to what "mycustompage.htm" should contain in order to field the error[s] erupting.

POINTERS, anyone? Have I missed some basic part of the manual[s] someplace? I was sort of hoping that there would be a simple "cookbook" around someplace for how to "deploy" a relatively tested group of pages (application) in a relatively idiot-proof manner. I'm not finding it, so ANY pointers, hints, URLs will be greatly appreciated.

Color me "confused in Kauai" ... :) KevInKauai

Hi,

1.For your first question,the difference between "Personal" and "LocalSqlServer" is like the following:

Personal connectionStrings:"Data Source=localhost;Initial Catalog=CatelogName;uid=sa;password=XXX" (For other editions than the Express edition)

LocalSqlServer connectionString:"data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" . (For SqlServer Express Edition)

2.For your second question,you can change the customErrors settings into the following mode if your hoster provide the authority.

<customErrors mode="off"/>

Thanks.

|||

Thanks, Jin !

My "VB guru days" were back with VB6 and I've taken a long hiatus, so I guess I'm suffering from object (or abject!) confusion. I've been trying to find the uttimate object reference but have only come up with this: http://quickstarts.asp.net/QuickStartv20/util/classbrowser.aspx

I've gone through all but the last 2 of the LearningVisualStudio (Express) videos and there really was never an application deployed in all of that.

Color me -- STILL WAY CONFUSED!

:) mahalos ... KevInKauai

Deploying Reports

Hi Everyone,

I am getting an error when I am trying to deploy my reports to my web server which contains reporting services. The error that am getting is 'Exception of type Microsoft.ReportingServices.ReportProcessing.ReportProcessingException was thrown.' and it appears within the Visual Studio IDE causing the deployment to fail. Has any one seen this error and if so what’s the fix that worked for you? Or any suggestions?

Here’s some background information -
My sql server is behind a firewall and within a network.
My web server is outside the network and the firewall.
I have created my own ssl certificate.
I have tried deploying the reports as different users with different log-ins and still no success. I get the same error.

I hope that's enough information for now.
Thanks

Hey everyone,
I am now getting a new error -
'The underlying connection was closed: Could not establish trust relationship with remote server. '

Any one have any suggestions?

Thanks|||Hey everyone,

I found a solution to my problem. I believe this is a common problem especially if you install your own SSL certificate. The solution to simple go into RsReportServer.Config and turn off SSL. This allowed me to upload all the reports to server. Then turn it back on for your safety.

I hope this helps anyone else thats having a similar problem.

Thanks

Deploying Reporting Services Project ON SSL Secured Web Site

Hello Everyone,
I am new to reporting services and am trying to Deploy my RS project to a
SSL secured website. I am getting error "Could not establish trust
relationship for ssl/tls secure channel".
I did check the box ssl.
I other thing I noticed is when I go to the configuration surface for sql
server and click on reporting services features when I clik on windows
integrated security on that server it gives me error "The request failed with
HTTP Status 403: forbidden. (system.web.services).
Any help is greatly appreciated.
Thanks
Shabnam GuptaHi Shabam,
This I had last week as well, it was solved @. my side by referring to the
servername by it's actual name. First I was referring to it by "localhost".
After changing it to the actual server name the error went away.
Hope this helps for you.
Greetz
Perry
"Shabam Gupta" <ShabamGupta@.discussions.microsoft.com> wrote in message
news:554E1BD5-0435-4E0F-AB28-4AA470B288FA@.microsoft.com...
> Hello Everyone,
> I am new to reporting services and am trying to Deploy my RS project to a
> SSL secured website. I am getting error "Could not establish trust
> relationship for ssl/tls secure channel".
> I did check the box ssl.
> I other thing I noticed is when I go to the configuration surface for sql
> server and click on reporting services features when I clik on windows
> integrated security on that server it gives me error "The request failed
> with
> HTTP Status 403: forbidden. (system.web.services).
> Any help is greatly appreciated.
> Thanks
> Shabnam Gupta

Deploying Report Server to a Shared Server

I wish to deploy reporting capability on a web page with a ReportViewer to a shared server environment. On my local server, all works fine when IU view the aspx page, I can see my report on my aspx page, images and all.

However, when I deploy to my shared server, I can not get the page to work. Googling, I heard that I needed to copy three files to the bin folder, which I did. I copied:

Microsoft.ReportViewer.Common.dll
Microsoft.ReportViewer.WinForms.dll
Microsoft.ReportViewer.ProcessingObjectModel.dll

But now I get the error when accessing everything but the default page:

"Exception Details: System.Security.Policy.PolicyException: Required permissions cannot be acquired."

Any help would be appreciated,

Thank you,

Paolo

I assume that your local server has Visual Studio installed but your shared server does not. In that case you need to install the Report Viewer Redistributable on your shared server. You can download the redistributable package from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=8a166cac-758d-45c8-b637-dd7726e61367&DisplayLang=en

-Albert

|||

Thank you. Correct assumption.

I just learned that my hosting provider prohibits deploying "reporting software", so I will be looking at one that does. (what is different between a dataset needed to supply a webform and a reporting object ?) But will any shared provider allow installation of the redistributable?

Thanks again,

Paolo

Deploying Report Server behind web servers

We'd like to deploy our report servers behind our web tier in the app tier
in order to prevent our clients from being able to use url access directly.
My main concern has to do with a chance that a client may attempt to alter
the content of report parameters or otherwise probe around.
Our web code is able to forward requests to the report server and render
reports correctly, but toolbar functionality seems to be broken. The web
developer tells me that the toolbar functionality is too stateful, so
paging (as an example) won't work.
Is what we're trying to do (request forwarding) unsupported? Are my fears
regarding exposing the report server in our DMZ unwarranted? If so, I must
be missing something.What about building your own interfaace or getting the Report Stream from
Reporting Webservice to Qrite the Stream to the browser ? There you could
lock down your reporting server and connect to the RS with special lockedup
credentials.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"JoeA" <joea@.nospam.net> schrieb im Newsbeitrag
news:Xns963D69BAFC14Emailmailcom@.207.46.248.16...
> We'd like to deploy our report servers behind our web tier in the app tier
> in order to prevent our clients from being able to use url access
> directly.
> My main concern has to do with a chance that a client may attempt to alter
> the content of report parameters or otherwise probe around.
> Our web code is able to forward requests to the report server and render
> reports correctly, but toolbar functionality seems to be broken. The web
> developer tells me that the toolbar functionality is too stateful, so
> paging (as an example) won't work.
> Is what we're trying to do (request forwarding) unsupported? Are my fears
> regarding exposing the report server in our DMZ unwarranted? If so, I
> must
> be missing something.|||Thanks for the reply. We have considered that - however we didn't want to
have to recreate all of the goodies in the toolbar.
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
in news:#1t7uEQRFHA.2136@.TK2MSFTNGP14.phx.gbl:
> What about building your own interfaace or getting the Report Stream
> from Reporting Webservice to Qrite the Stream to the browser ? There
> you could lock down your reporting server and connect to the RS with
> special lockedup credentials.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>

Deploying multiple web parts together

Hi,
My problem is that i want to add Web Part library project so that i
could add more than one web part into one solution.This will
facilitate me in deploying just one solution on Sharepoint server and
all webparts would be deployed.I searched through Google and found
that it was possible in vs.net 2003 through Web Part Template Library
project.But i could not find out any method of doing so in vs.net
2005.Could any one help..
I am using Sharepoint Server 2007 and vs.net 2005
Amit
Hi
"Amit" wrote:

> Hi,
> My problem is that i want to add Web Part library project so that i
> could add more than one web part into one solution.This will
> facilitate me in deploying just one solution on Sharepoint server and
> all webparts would be deployed.I searched through Google and found
> that it was possible in vs.net 2003 through Web Part Template Library
> project.But i could not find out any method of doing so in vs.net
> 2005.Could any one help..
> I am using Sharepoint Server 2007 and vs.net 2005
> Amit
>
This is not really a SQL Server question, you should post to a more
appropriate group such as microsoft.public.sharepoint.* or go to
http://www.microsoft.com/technet/community/newsgroups/server/sharepoint.mspx
and choose a group.
John

Deploying multiple web parts together

Hi,
My problem is that i want to add Web Part library project so that i
could add more than one web part into one solution.This will
facilitate me in deploying just one solution on Sharepoint server and
all webparts would be deployed.I searched through Google and found
that it was possible in vs.net 2003 through Web Part Template Library
project.But i could not find out any method of doing so in vs.net
2005.Could any one help..
I am using Sharepoint Server 2007 and vs.net 2005
AmitHi
"Amit" wrote:
> Hi,
> My problem is that i want to add Web Part library project so that i
> could add more than one web part into one solution.This will
> facilitate me in deploying just one solution on Sharepoint server and
> all webparts would be deployed.I searched through Google and found
> that it was possible in vs.net 2003 through Web Part Template Library
> project.But i could not find out any method of doing so in vs.net
> 2005.Could any one help..
> I am using Sharepoint Server 2007 and vs.net 2005
> Amit
>
This is not really a SQL Server question, you should post to a more
appropriate group such as microsoft.public.sharepoint.* or go to
http://www.microsoft.com/technet/community/newsgroups/server/sharepoint.mspx
and choose a group.
John

Deploying multiple web parts together

Hi,
My problem is that i want to add Web Part library project so that i
could add more than one web part into one solution.This will
facilitate me in deploying just one solution on Sharepoint server and
all webparts would be deployed.I searched through Google and found
that it was possible in vs.net 2003 through Web Part Template Library
project.But i could not find out any method of doing so in vs.net
2005.Could any one help..
I am using Sharepoint Server 2007 and vs.net 2005
AmitHi
"Amit" wrote:

> Hi,
> My problem is that i want to add Web Part library project so that i
> could add more than one web part into one solution.This will
> facilitate me in deploying just one solution on Sharepoint server and
> all webparts would be deployed.I searched through Google and found
> that it was possible in vs.net 2003 through Web Part Template Library
> project.But i could not find out any method of doing so in vs.net
> 2005.Could any one help..
> I am using Sharepoint Server 2007 and vs.net 2005
> Amit
>
This is not really a SQL Server question, you should post to a more
appropriate group such as microsoft.public.sharepoint.* or go to
http://www.microsoft.com/technet/co...sharepoint.mspx
and choose a group.
John

deploying App to 2003 server with SQL2005

I devloped this app with vs2005 and SQL 2005 express, everything seems to work fine, when I deploied the app to my web server I got a few different error messages that I worked through but now stuck on this one. i am sure it is something with SQL 2005 server. is there anywhere that has a good check list for doing things right in asp and SQL deployment?

here is the error message i am getting from debugging.

The SELECT permission was denied on the object 'Categories', database 'Blog', schema 'dbo'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The SELECT permission was denied on the object 'Categories', database 'Blog', schema 'dbo'.

Source Error:

Line 33: SqlConnection connection = CreateConnection();
Line 34: SqlCommand command = CreateCommand(connection, query, parameters);
Line 35: SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
Line 36:
Line 37: Type datatype = factory.GetDataType();

Source File: c:\Inetpub\blogplankroad\App_Code\Utilities\SqlDatabase.cs Line: 35

Hi Planker,

Just as the exception message describes, the user account you're using to connect to the database does not have permission to perform a SELECT on the certain table.

In the SQL Server Management Studio, please open the user property window and grant the proper permission for the user.

HTH. If this does not answer you question, please feel free to mark it as Not Answered and post your reply. Thanks!

deploying a report to a site hosted by 3rd party

I have been trying to deploy a web app that uses sql reports. I have copied the 3 dlls that are talked about.

Microsoft.ReportViewer.Common.dll
Microsoft.ReportViewer.WebForms.dll
Microsoft.ReportViewer.ProcessingObjectModel.dll

When I do this I get the following error:

Server Error in '/' Application.

---

Required permissions cannot be acquired.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Security.Policy.PolicyException: Required permissions cannot be acquired.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[PolicyException: Required permissions cannot be acquired.] System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Boolean checkExecutionPermission) +2737813 System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Int32& securitySpecialFlags, Boolean checkExecutionPermission) +57[FileLoadException: Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)] System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0 System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +211 System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +141 System.Reflection.Assembly.Load(String assemblyString) +25 System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +32[ConfigurationErrorsException: Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)] System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +596 System.Web.Configuration.CompilationSection.LoadAllAssembliesFromAppDomainBinDirectory() +3479097 System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +46 System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +177 System.Web.Compilation.WebDirectoryBatchCompiler..ctor(VirtualDirectory vdir) +267 System.Web.Compilation.BuildManager.BatchCompileWebDirectoryInternal(VirtualDirectory vdir, Boolean ignoreErrors) +36 System.Web.Compilation.BuildManager.BatchCompileWebDirectory(VirtualDirectory vdir, VirtualPath virtualDir, Boolean ignoreErrors) +429 System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath) +73 System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) +580 System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) +93 System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean noAssert) +111 System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp, Boolean noAssert) +54 System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) +31 System.Web.UI.PageHandlerFactory.System.Web.IHttpHandlerFactory2.GetHandler(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) +40 System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig) +139 System.Web.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +120 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

why does this not work?

Thanks,

enak

I would venture that you need to register the dll's in the gac. I'm rolling out an app to a custom webserver and had similiar problems. I need an ide on the machine so I install visual web developer and the reporting services add in and took care of my problem. The install would have taken care of the proper registering.

Deploying a report model

I'm trying to upload a report model to my server using the web interface, the same way I'd upload a report. When I attempt this I get the message

"The DataSourceView is missing for the SemanticModel. SemanticModel

must have exactly one DataSourceView element. (MissingDataSourceView)"

How do I fix this so that I can upload the smdl file?

Thanks

When you deploy a report model from a Visual Studio Model Designer project, it actually embeds the Data Source View (.dsv) inside the Semantic Model (.smdl) file. You can see how this is done by downloading an existing model from the report server.

When you upload the model file yourself, you will need to embed the DSV manually.

Deployed report with custom assembly fail when calling web service

Hi,
I'm developing a report that calls a web service using a custom assembly.
I've got the code working in VS.NET, but when I deploy to my local Report
Server, I get this:
System.Security.SecurityException: Request for the permission of type
System.Security.Permissions.SecurityPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed
I have added the following to RSReportServer.config:
<CustomAssemblies>
<Assembly Name="cmcs.wsclient.dll, Version=1.0.xxx.xxxx,
Culture=neutral, PublicKeyToken=xxx">
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execution, Assertion"
/>
<IPermission class="System.Security.Permissions.WebPermission"
version="1"
Unrestricted="true"
/>
<IPermission
class="System.Security.Permissions.EnvironmentPermission"
version="1"
Unrestricted="true"
/>
</PermissionSet>
</Assembly>
<Assembly Name="cmcs.msrs.webserviceclient, Version=1.0.xxx.xxxx,
Culture=neutral, PublicKeyToken=xxx">
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execution, Assertion"
/>
<IPermission class="System.Security.Permissions.WebPermission"
version="1"
Unrestricted="true"
/>
<IPermission
class="System.Security.Permissions.EnvironmentPermission"
version="1"
Unrestricted="true"
/>
</PermissionSet>
</Assembly>
<Default>
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execute"
/>
</PermissionSet>
</Default>
</CustomAssemblies>
In rssrvpolicy.config, I have changed the PermissionSet for
Report_Expressions_Default_Permissions to FullTrust and added the following:
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Attributes="LevelFinal"
Name="ReportServer-cmcs.msrs.webserviceclient"
Description="Codegroup generated by the .NET
Configuration tool">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="file://C:/Program
Files/Microsoft SQL Server/MSSQL/Reporting
Services/ReportServer/bin/cmcs.msrs.webserviceclient.dll"/>
</CodeGroup>
It works to call a HelloWorld method returning a string from the custom
assembly, so there is no total failure, but calling the method to invoke the
web service fails.
Please help, I feel that I'm totally stuck!
JonasBy moving my CodeGroup in rssrvpolicy.config to right under the first
default CodeGroup, it I got it to work ...
<CodeGroup
class="FirstMatchCodeGroup"
version="1"
PermissionSetName="Nothing">
<IMembershipCondition
class="AllMembershipCondition"
version="1"
/>
***** RIGHT UNDER HERE *****
It seems like my CodeGroup wasn't used by ReportServer until the move. We'll
just have to see how long time it will work before it breaks again ;-)
Jonas" <Jonas@.nospam.pl> wrote in message
news:u$YVj30IGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm developing a report that calls a web service using a custom assembly.
> I've got the code working in VS.NET, but when I deploy to my local Report
> Server, I get this:
> System.Security.SecurityException: Request for the permission of type
> System.Security.Permissions.SecurityPermission, mscorlib,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
failed
> I have added the following to RSReportServer.config:
> <CustomAssemblies>
> <Assembly Name="cmcs.wsclient.dll, Version=1.0.xxx.xxxx,
> Culture=neutral, PublicKeyToken=xxx">
> <PermissionSet class="System.Security.PermissionSet">
> <IPermission
> class="System.Security.Permissions.SecurityPermission"
> version="1"
> Flags="Execution, Assertion"
> />
> <IPermission class="System.Security.Permissions.WebPermission"
> version="1"
> Unrestricted="true"
> />
> <IPermission
> class="System.Security.Permissions.EnvironmentPermission"
> version="1"
> Unrestricted="true"
> />
> </PermissionSet>
> </Assembly>
> <Assembly Name="cmcs.msrs.webserviceclient, Version=1.0.xxx.xxxx,
> Culture=neutral, PublicKeyToken=xxx">
> <PermissionSet class="System.Security.PermissionSet">
> <IPermission
> class="System.Security.Permissions.SecurityPermission"
> version="1"
> Flags="Execution, Assertion"
> />
> <IPermission class="System.Security.Permissions.WebPermission"
> version="1"
> Unrestricted="true"
> />
> <IPermission
> class="System.Security.Permissions.EnvironmentPermission"
> version="1"
> Unrestricted="true"
> />
> </PermissionSet>
> </Assembly>
> <Default>
> <PermissionSet class="System.Security.PermissionSet">
> <IPermission
> class="System.Security.Permissions.SecurityPermission"
> version="1"
> Flags="Execute"
> />
> </PermissionSet>
> </Default>
> </CustomAssemblies>
> In rssrvpolicy.config, I have changed the PermissionSet for
> Report_Expressions_Default_Permissions to FullTrust and added the
following:
> <CodeGroup class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Attributes="LevelFinal"
>
Name="ReportServer-cmcs.msrs.webserviceclient"
> Description="Codegroup generated by the .NET
> Configuration tool">
> <IMembershipCondition class="UrlMembershipCondition"
> version="1"
> Url="file://C:/Program
> Files/Microsoft SQL Server/MSSQL/Reporting
> Services/ReportServer/bin/cmcs.msrs.webserviceclient.dll"/>
> </CodeGroup>
> It works to call a HelloWorld method returning a string from the custom
> assembly, so there is no total failure, but calling the method to invoke
the
> web service fails.
> Please help, I feel that I'm totally stuck!
> Jonas
>