.NET Framework - asp.net web service connecting to another web service
Asked By jazzydance
07-Feb-10 04:31 PM
I have a couple of questions to ask you about a sql server reporting service
connecting to a webservice within the DMZ. I am asking this question since I
want to avoid the double hop problems that occur by using IIS on sql server
2005. (This is when you use windows authenication in sql server 2005 to
connect to IIS.)
Right now my company is using sql server 2005 and may upgrade to sql
server 2008 within the next couple of months.
The following questions pertain to using sql server 2005 and visual
studio.net 2005:
1. If I want to have sql server report service 2005 connect to web service
within the DMZ, is this possible? If so, are there URLS and/or books that I
can look at that would be able to answer this question?
2. If question #1 is not possible, could I create a asp.net web page that
would use some kind of a viewer contol that could display the sql server
reporting service 2005 reports? This asp.net web page would then send the
reports to a web service within the DMZ?
I want to use the web service so that the reports can be opened up on the
internet.
The following questions pertain to using sql server 2008 and visual
studio.net 2008:
(I know that sql server 2008 does not use IIS. There is an http/system url
that is used instead.
1. If I want to have sql server report service 2008 connect to web service
within the DMZ, is this possible? If so, are there URLS and/or books that I
can look at that would be able to answer this question?
2. If question #1 is not possible, could I create a asp.net web page that
would use some kind of a viewer contol that could display the sql server
reporting service 2008 reports? This asp.net web page would then send the
reports to a web service within the DMZ?
Thanks in advance!
IIS
(1)
Report
(1)
Classlib
(1)
Webservice
(1)
Windows
(1)
Contol
(1)
Mr. Arnold replied to jazzydance
Yeah it is possible. But is it the right thing to do?
Maybe, you will want to take a look at this.
I do not know.
I do not know about putting something like that on the Web server that is
sitting in the DMZ that has contact with SQL server. There is nothing
wrong with using a portal type solution where everything is behind the
DMZ, and the user must come into a secure/protected zone.
jazzydance replied to Mr. Arnold
Mr. Arnold:
Thank you for your response. However I want the sql server report service
to connect to another
web service within a DMZ. I do not want to open up the sql server report
service web service directly
on the internet since that is a production server.
Thus I am just wondering if I connect th sql server report service web
service to another
web service within the DMZ, would there be a 'unique' calls that would be
required. Would
this be like a standard web service calling another web service?
thanks!
Mr. Arnold replied to jazzydance
The Web service would use a Classlib Project (client) that has reference
to another Web service, which would be a Web service client to a Web
service.
There is no Web service to Web service. There is a Web service client
and Web service server.
To access local IIS Web sites, you must install the following IIS components .NET Framework To access local IIS Web sites, you must install the following IIS components: IIS 6 Metabase and IIS 6 Configuration Compatibility ASP.NET Windows Authentication In addition, you must run Visual Studio in as an Administrator. . . Any Idea? Visual Studio General Discussions Visual Studio (1) ASP.NET (1) IIS (1) Windows (1) Day (1) Had the same problem on windows 7 with visual studio the following link. It may helpfull for u. http: / / blog.scrappydog.com / 2008 / 06 / enabling-iis-6-metabase-compatibility.html Go through the following link. It may be helpfull for u
I need a way to uninstall IIS 7 (and ASP) under WOW64 .NET Framework About a couple of months ago, I posted that I am maintaining, we keep track of whether or not the installer had installed IIS 7 and / or ASP (under Vista or later) and save an appropriate value to the During an uninstall, if that value is there and no other Web sites are using IIS on that machine, the user is asked whether or not IIS / ASP is to be removed. If so, we remove whatever we installed. The following is the command that we launch in order to remove IIS 7 and ASP (line breaks added for clarity): C: \ Windows \ system32 \ pkgmgr.exe / norestart / uu:IIS-WebServerRole; IIS-WebServer;IIS-CommonHttpFeatures;IIS-StaticContent; IIS-DefaultDocument;IIS-DirectoryBrowsing;IIS-HttpErrors; IIS-ApplicationDevelopment;IIS-ASP;IIS-ISAPIExtensions
simple syntax question .NET Framework hello, in the following code: Dim report As Report = CreateReport() report!OFFICER_1 = Global.Officer1 report!OFFICER_2 = Global.Officer2 report!UNIT_NUMBER = Global.Officer1.UnitNumber . . .can someone please explain what the "!" syntax is in the last three lines? those arent properties of the Report object itself, so i am confused. thanks! sm VB.NET Discussions VB.NET (1) VB (1) Report (1) CreateReport (1) Wagner (1) Arent (1) See: Special Characters in Code -> "Exclamation Point (!) Operator mvps.org / dotnet / faqs / > keywords: simple, syntax, question description: hello, in the following code: Dim report As Report = CreateReport() report!OFFICER_1 = Global.Officer1 report!OFFICER_2 = Global.Officer2 report!UN
with an internal parametrized constructor. .NET Framework Hello, I have the following object: public class Report { public Report() {} internal Report (bool IgnoreCriteria) { / / do stuff } } From another assembly I am loading this Report object via Activator.CreateInstance method. I've tried the following code: Type availableReport = Reports.FirstRptType returns a Report Type object[] constructorParameter = new object[] { true }; Report reportPlugin = Activator.CreateInstance(availableReport, constructorParameter) as Report; This fails with Missing method exception, obviously because it cannot find the internal constructor. If Activator.CreateInstance (1) BindingFlags.Instance (1) Type.EmptyTypes (1) ConstructorInfo (1) Not via Activator, but. . . Report rep = (Report) availableReport.GetConstructor( BindingFlags.NonPublic | BindingFlags.Instance, null, new Type[] {typeof(bool)}, null ).Invoke