Hi,
I just had a question regarding forms authentication using a SQL database
backend. If my (planned)architecture is:
Internet -> firewall -> DMZ (IIS - access to User Interface) -> Firewall ->
SQL User Database, Application Server, SQL application database.
then what technology would I typically use to communicate between the IIS
machine in my DMZ and the SQL user database?
remoting?
web service?
Are there advantages/disadvantages to using either of these?
I don't want to host the SQL user database in the DMZ on the IIS machine -
for security reasons.
Is anyone aware of any examnples/tutorials of this sort of setup on the web?
Thanks in Advance,
Dan. 7 1494
I think you would be slowing down you application severely if you
authenticate using remoting or web services. You'll have to do every SQL
call that way, which is ridiculously slow.
Can't the IIS machine have access to your SQL through the firewall?
I'm not really good with networking issues, but I think you should be able
to allow your IIS server to "see" your SQL server securely
"Dan Walls" <wa****@hotmail.com> wrote in message
news:6E*********************@news-server.bigpond.net.au... Hi,
I just had a question regarding forms authentication using a SQL database backend. If my (planned)architecture is:
Internet -> firewall -> DMZ (IIS - access to User Interface) ->
Firewall -> SQL User Database, Application Server, SQL application database.
then what technology would I typically use to communicate between the IIS machine in my DMZ and the SQL user database?
remoting? web service?
Are there advantages/disadvantages to using either of these?
I don't want to host the SQL user database in the DMZ on the IIS machine - for security reasons.
Is anyone aware of any examnples/tutorials of this sort of setup on the
web? Thanks in Advance, Dan.
That's sort of my question I think - how would my asp.net application
(running on the IIS server) talk to the SQL database on another server
behind my second firewall?
Thanks George,
Dan.
"George Durzi" <gdurzi@nospam_hotmail.com> wrote in message
news:e8**************@tk2msftngp13.phx.gbl... I think you would be slowing down you application severely if you authenticate using remoting or web services. You'll have to do every SQL call that way, which is ridiculously slow.
Can't the IIS machine have access to your SQL through the firewall? I'm not really good with networking issues, but I think you should be able to allow your IIS server to "see" your SQL server securely
"Dan Walls" <wa****@hotmail.com> wrote in message news:6E*********************@news-server.bigpond.net.au... Hi,
I just had a question regarding forms authentication using a SQL
database backend. If my (planned)architecture is:
Internet -> firewall -> DMZ (IIS - access to User Interface) -> Firewall -> SQL User Database, Application Server, SQL application database.
then what technology would I typically use to communicate between the
IIS machine in my DMZ and the SQL user database?
remoting? web service?
Are there advantages/disadvantages to using either of these?
I don't want to host the SQL user database in the DMZ on the IIS
machine - for security reasons.
Is anyone aware of any examnples/tutorials of this sort of setup on the web? Thanks in Advance, Dan.
Dan,
I think it becomes a network issue rather than a programmatic one at this
point. Sorry, I'm of no use with network issues :) I'm just a code monkey
"Dan Walls" <wa****@hotmail.com> wrote in message
news:7%********************@news-server.bigpond.net.au... That's sort of my question I think - how would my asp.net application (running on the IIS server) talk to the SQL database on another server behind my second firewall?
Thanks George, Dan.
"George Durzi" <gdurzi@nospam_hotmail.com> wrote in message news:e8**************@tk2msftngp13.phx.gbl... I think you would be slowing down you application severely if you authenticate using remoting or web services. You'll have to do every SQL call that way, which is ridiculously slow.
Can't the IIS machine have access to your SQL through the firewall? I'm not really good with networking issues, but I think you should be
able to allow your IIS server to "see" your SQL server securely
"Dan Walls" <wa****@hotmail.com> wrote in message news:6E*********************@news-server.bigpond.net.au... Hi,
I just had a question regarding forms authentication using a SQL database backend. If my (planned)architecture is:
Internet -> firewall -> DMZ (IIS - access to User Interface) -> Firewall -> SQL User Database, Application Server, SQL application database.
then what technology would I typically use to communicate between the IIS machine in my DMZ and the SQL user database?
remoting? web service?
Are there advantages/disadvantages to using either of these?
I don't want to host the SQL user database in the DMZ on the IIS machine - for security reasons.
Is anyone aware of any examnples/tutorials of this sort of setup on
the web? Thanks in Advance, Dan.
We had the arch and we got the network guys to open up the second firewall
for port (i think 1440, chk sql docs) for communication between the sql and
the webserver. That way thur this open port only these two can communicate.
"George Durzi" <gdurzi@nospam_hotmail.com> wrote in message
news:ek**************@TK2MSFTNGP12.phx.gbl... Dan, I think it becomes a network issue rather than a programmatic one at this point. Sorry, I'm of no use with network issues :) I'm just a code monkey
"Dan Walls" <wa****@hotmail.com> wrote in message news:7%********************@news-server.bigpond.net.au... That's sort of my question I think - how would my asp.net application (running on the IIS server) talk to the SQL database on another server behind my second firewall?
Thanks George, Dan.
"George Durzi" <gdurzi@nospam_hotmail.com> wrote in message news:e8**************@tk2msftngp13.phx.gbl... I think you would be slowing down you application severely if you authenticate using remoting or web services. You'll have to do every
SQL call that way, which is ridiculously slow.
Can't the IIS machine have access to your SQL through the firewall? I'm not really good with networking issues, but I think you should be able to allow your IIS server to "see" your SQL server securely
"Dan Walls" <wa****@hotmail.com> wrote in message news:6E*********************@news-server.bigpond.net.au... > Hi, > > I just had a question regarding forms authentication using a SQL database > backend. If my (planned)architecture is: > > Internet -> firewall -> DMZ (IIS - access to User Interface) -> Firewall -> > SQL User Database, Application Server, SQL application database. > > then what technology would I typically use to communicate between
the IIS > machine in my DMZ and the SQL user database? > > remoting? > web service? > > Are there advantages/disadvantages to using either of these? > > I don't want to host the SQL user database in the DMZ on the IIS machine - > for security reasons. > > Is anyone aware of any examnples/tutorials of this sort of setup on the web? > > Thanks in Advance, > Dan. > >
thanks Rajesh and George,
But I'm actually trying to find out "how" they talk... ie. in asp.net the
code behind file for the login page needs to access the SQL Database which
is on a totally different machine (and behind a firewall).
How does it do this?
Sorry if I'm not being very clear. It's hard to be clear about something you
don't understand :)
Dan.
"Rajesh.V" <Ra***********@hotmail.com> wrote in message
news:uW**************@TK2MSFTNGP11.phx.gbl... We had the arch and we got the network guys to open up the second firewall for port (i think 1440, chk sql docs) for communication between the sql
and the webserver. That way thur this open port only these two can
communicate. "George Durzi" <gdurzi@nospam_hotmail.com> wrote in message news:ek**************@TK2MSFTNGP12.phx.gbl... Dan, I think it becomes a network issue rather than a programmatic one at
this point. Sorry, I'm of no use with network issues :) I'm just a code
monkey "Dan Walls" <wa****@hotmail.com> wrote in message news:7%********************@news-server.bigpond.net.au... That's sort of my question I think - how would my asp.net application (running on the IIS server) talk to the SQL database on another server behind my second firewall?
Thanks George, Dan.
"George Durzi" <gdurzi@nospam_hotmail.com> wrote in message news:e8**************@tk2msftngp13.phx.gbl... > I think you would be slowing down you application severely if you > authenticate using remoting or web services. You'll have to do every SQL > call that way, which is ridiculously slow. > > Can't the IIS machine have access to your SQL through the firewall? > I'm not really good with networking issues, but I think you should
be able > to allow your IIS server to "see" your SQL server securely > > "Dan Walls" <wa****@hotmail.com> wrote in message > news:6E*********************@news-server.bigpond.net.au... > > Hi, > > > > I just had a question regarding forms authentication using a SQL database > > backend. If my (planned)architecture is: > > > > Internet -> firewall -> DMZ (IIS - access to User Interface) -> > Firewall -> > > SQL User Database, Application Server, SQL application database. > > > > then what technology would I typically use to communicate between the IIS > > machine in my DMZ and the SQL user database? > > > > remoting? > > web service? > > > > Are there advantages/disadvantages to using either of these? > > > > I don't want to host the SQL user database in the DMZ on the IIS machine - > > for security reasons. > > > > Is anyone aware of any examnples/tutorials of this sort of setup
on the > web? > > > > Thanks in Advance, > > Dan. > > > > > >
Well Dan, the communication with an Sql server happens thru Tcp/Ip. In tech
terms it uses a port or an address where the server listens for request for
connections. The firewall by default blocks everything which is useless. But
by allowing only certain ports like 80 for http, 25for pop, smtp21, and so
on. Sql i think talks on 1440 port. You can check on the sql documentation.
So here it is of the how the comm happens. Very much from 500 ft ht.
"Dan Walls" <wa****@hotmail.com> wrote in message
news:3O********************@news-server.bigpond.net.au... thanks Rajesh and George,
But I'm actually trying to find out "how" they talk... ie. in asp.net the code behind file for the login page needs to access the SQL Database which is on a totally different machine (and behind a firewall).
How does it do this?
Sorry if I'm not being very clear. It's hard to be clear about something
you don't understand :)
Dan.
"Rajesh.V" <Ra***********@hotmail.com> wrote in message news:uW**************@TK2MSFTNGP11.phx.gbl... We had the arch and we got the network guys to open up the second
firewall for port (i think 1440, chk sql docs) for communication between the sql and the webserver. That way thur this open port only these two can communicate. "George Durzi" <gdurzi@nospam_hotmail.com> wrote in message news:ek**************@TK2MSFTNGP12.phx.gbl... Dan, I think it becomes a network issue rather than a programmatic one at this point. Sorry, I'm of no use with network issues :) I'm just a code monkey "Dan Walls" <wa****@hotmail.com> wrote in message news:7%********************@news-server.bigpond.net.au... > That's sort of my question I think - how would my asp.net
application > (running on the IIS server) talk to the SQL database on another
server > behind my second firewall? > > Thanks George, > Dan. > > "George Durzi" <gdurzi@nospam_hotmail.com> wrote in message > news:e8**************@tk2msftngp13.phx.gbl... > > I think you would be slowing down you application severely if you > > authenticate using remoting or web services. You'll have to do
every SQL > > call that way, which is ridiculously slow. > > > > Can't the IIS machine have access to your SQL through the
firewall? > > I'm not really good with networking issues, but I think you should be able > > to allow your IIS server to "see" your SQL server securely > > > > "Dan Walls" <wa****@hotmail.com> wrote in message > > news:6E*********************@news-server.bigpond.net.au... > > > Hi, > > > > > > I just had a question regarding forms authentication using a SQL > database > > > backend. If my (planned)architecture is: > > > > > > Internet -> firewall -> DMZ (IIS - access to User Interface) -> > > Firewall -> > > > SQL User Database, Application Server, SQL application database. > > > > > > then what technology would I typically use to communicate
between the > IIS > > > machine in my DMZ and the SQL user database? > > > > > > remoting? > > > web service? > > > > > > Are there advantages/disadvantages to using either of these? > > > > > > I don't want to host the SQL user database in the DMZ on the IIS > machine - > > > for security reasons. > > > > > > Is anyone aware of any examnples/tutorials of this sort of setup
on the > > web? > > > > > > Thanks in Advance, > > > Dan. > > > > > > > > > > > >
Well Dan, the communication with an Sql server happens thru Tcp/Ip. In tech
terms it uses a port or an address where the server listens for request for
connections. The firewall by default blocks everything which is useless. But
by allowing only certain ports like 80 for http, 25for pop, smtp21, and so
on. Sql i think talks on 1440 port. You can check on the sql documentation.
So here it is of the how the comm happens. Very much from 500 ft ht.
"Dan Walls" <wa****@hotmail.com> wrote in message
news:3O********************@news-server.bigpond.net.au... thanks Rajesh and George,
But I'm actually trying to find out "how" they talk... ie. in asp.net the code behind file for the login page needs to access the SQL Database which is on a totally different machine (and behind a firewall).
How does it do this?
Sorry if I'm not being very clear. It's hard to be clear about something
you don't understand :)
Dan.
"Rajesh.V" <Ra***********@hotmail.com> wrote in message news:uW**************@TK2MSFTNGP11.phx.gbl... We had the arch and we got the network guys to open up the second
firewall for port (i think 1440, chk sql docs) for communication between the sql and the webserver. That way thur this open port only these two can communicate. "George Durzi" <gdurzi@nospam_hotmail.com> wrote in message news:ek**************@TK2MSFTNGP12.phx.gbl... Dan, I think it becomes a network issue rather than a programmatic one at this point. Sorry, I'm of no use with network issues :) I'm just a code monkey "Dan Walls" <wa****@hotmail.com> wrote in message news:7%********************@news-server.bigpond.net.au... > That's sort of my question I think - how would my asp.net
application > (running on the IIS server) talk to the SQL database on another
server > behind my second firewall? > > Thanks George, > Dan. > > "George Durzi" <gdurzi@nospam_hotmail.com> wrote in message > news:e8**************@tk2msftngp13.phx.gbl... > > I think you would be slowing down you application severely if you > > authenticate using remoting or web services. You'll have to do
every SQL > > call that way, which is ridiculously slow. > > > > Can't the IIS machine have access to your SQL through the
firewall? > > I'm not really good with networking issues, but I think you should be able > > to allow your IIS server to "see" your SQL server securely > > > > "Dan Walls" <wa****@hotmail.com> wrote in message > > news:6E*********************@news-server.bigpond.net.au... > > > Hi, > > > > > > I just had a question regarding forms authentication using a SQL > database > > > backend. If my (planned)architecture is: > > > > > > Internet -> firewall -> DMZ (IIS - access to User Interface) -> > > Firewall -> > > > SQL User Database, Application Server, SQL application database. > > > > > > then what technology would I typically use to communicate
between the > IIS > > > machine in my DMZ and the SQL user database? > > > > > > remoting? > > > web service? > > > > > > Are there advantages/disadvantages to using either of these? > > > > > > I don't want to host the SQL user database in the DMZ on the IIS > machine - > > > for security reasons. > > > > > > Is anyone aware of any examnples/tutorials of this sort of setup
on the > > web? > > > > > > Thanks in Advance, > > > Dan. > > > > > > > > > > > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: RAJESH |
last post by:
I am working with c# and asp.net in developing web applications, iam using
..netframework 1.1 ,i want to know what is the need of 3-tier or 4-tier
architecture in our application development.what...
|
by: Brad |
last post by:
Stupid question time: Why does Forms Auth just keep going to the login page
when access is denied? A 403 error is never raised..at least in my testing
it doesn't.
If I have a particular web...
|
by: Chris Mohan |
last post by:
Hi, I've configured a web app to use windows authentication and also set up two separate subdirectories to use forms authentication. It appears to work fine but I have never seen a sample that...
|
by: 23s |
last post by:
I had this problem in the past, after a server reformat it went away, and
now after another server reformat it's back again - no clue what's doing it.
Here's the flow:
Website root is public, no...
|
by: AVance |
last post by:
Hi,
I've come across this scenario in ASP.NET 1.1 with forms authentication
where the forms auth doesn't seem to timeout correctly, nor redirect to the
login page.
I have done some testing, and...
|
by: code |
last post by:
Hi,
I have stumbled across an interesting problem regarding forms
authentication over multiple sub domains. The topic has been covered in
various forms online but never really gets a definitive...
|
by: =?Utf-8?B?TFc=?= |
last post by:
Hello!
I am just learning about forms authentication so please excuse this basic
question. I am using .NET 1.1 and C#.
I have created my web.config file and my login.aspx and the associated cs...
|
by: =?Utf-8?B?RmFyaWJh?= |
last post by:
It know that we can use the following method
http://msdn2.microsoft.com/en-us/library/eb0zx8fc.aspx
to form authenticate across multiple applications.
I have created an asp.net application...
|
by: tagg3rx |
last post by:
Hi All,
I'm trying to get forms based auth up and working and I'm running into a little snag. My login page needs to access css files and images in my application and when I enable the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |