473,847 Members | 1,699 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Internet - Intranet Data Dilema

Hi,

Currently, I have one database for Intranet clients on the server behind the
firewall. But I was asked to allow the extranet users to access the same
data. From the security perspective what is the best way to make that data
accessible.

Should we have two databases one for Intranet and one for Extranet? In that
case the second one would be a replica but that would cost us money for the
extra MS SQL license. Maybe it is OK to have only one physical database.
Maybe MySQL is a good idea to use as a replica that would be refreshed
nightly. Or XML data would be OK to server only extranet.

What would be the best idea to do.

We are all MS shop.

Thanks in advance for any help,
Tom
Feb 9 '06 #1
5 1264
Tom,

Web services may be a nice way to give extranet users access to the data.
That way it's easy to lock down what the users have access to. I don't know
how your network is set up, but that's the solution we used when a few of
our select database had to be opened up read-only to outside users where I
work. We allow the webserver to connect to a webservices server that is only
accessible by it. Then the webservices server connects to the database.

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
"asdf" <as**@asdf.co m> wrote in message
news:vM******** ***********@new s20.bellglobal. com...
Hi,

Currently, I have one database for Intranet clients on the server behind
the
firewall. But I was asked to allow the extranet users to access the same
data. From the security perspective what is the best way to make that data
accessible.

Should we have two databases one for Intranet and one for Extranet? In
that
case the second one would be a replica but that would cost us money for
the
extra MS SQL license. Maybe it is OK to have only one physical database.
Maybe MySQL is a good idea to use as a replica that would be refreshed
nightly. Or XML data would be OK to server only extranet.

What would be the best idea to do.

We are all MS shop.

Thanks in advance for any help,
Tom

Feb 9 '06 #2
Tom,

You have several issues to deal with. One dealing with design and the other
with licensing.

On the licensing side, if you allow external users access to you SQL server
over the internet you technically need an internet connector license. You
need this whether the users are connecting to your internal SQL server or a
second server out on a web server. The easiest way around this is to deploy
either MSDE or SQL Express neither of which requires any kind of license.
MSDE is a light weight version of SQL 2000 and limits databases to 2GB. MSDE
also includes a workload governor that effectively limits you to 5 active
connections. SQL Express is based on SQL 2005 and increases the limit to 4GB
per database. The workload governor is gone. If you are an all MS shop, I
would avoid diving into MySQL.

On the design side, ideally you would have a second database and server that
is external to your network, but I can think of all kinds of exceptions to
this rule. On the other hand, the licensing issues above lend themselves to
using a separate database.

I have deployed a number of intranet / extranet solutions and find that
using an internal database with a replicated external database is usually
the best way to go. There are lots of intangibles and without knowing more
about you particular situation, it is difficult to comment beyond these
generalizations .

Hope this helps a bit,

--

Andrew Robinson
http://blog.binaryocean.com

"asdf" <as**@asdf.co m> wrote in message
news:vM******** ***********@new s20.bellglobal. com...
Hi,

Currently, I have one database for Intranet clients on the server behind
the
firewall. But I was asked to allow the extranet users to access the same
data. From the security perspective what is the best way to make that data
accessible.

Should we have two databases one for Intranet and one for Extranet? In
that
case the second one would be a replica but that would cost us money for
the
extra MS SQL license. Maybe it is OK to have only one physical database.
Maybe MySQL is a good idea to use as a replica that would be refreshed
nightly. Or XML data would be OK to server only extranet.

What would be the best idea to do.

We are all MS shop.

Thanks in advance for any help,
Tom

Feb 9 '06 #3
Is this OK to use webservices also when the Intranet is written in the old
ASP?

"S. Justin Gengo [MCP]" <justin@[no_spam_please]aboutfortunate. com> wrote in
message news:uq******** ******@TK2MSFTN GP10.phx.gbl...
Tom,

Web services may be a nice way to give extranet users access to the data.
That way it's easy to lock down what the users have access to. I don't
know how your network is set up, but that's the solution we used when a
few of our select database had to be opened up read-only to outside users
where I work. We allow the webserver to connect to a webservices server
that is only accessible by it. Then the webservices server connects to the
database.

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
"asdf" <as**@asdf.co m> wrote in message
news:vM******** ***********@new s20.bellglobal. com...
Hi,

Currently, I have one database for Intranet clients on the server behind
the
firewall. But I was asked to allow the extranet users to access the same
data. From the security perspective what is the best way to make that
data
accessible.

Should we have two databases one for Intranet and one for Extranet? In
that
case the second one would be a replica but that would cost us money for
the
extra MS SQL license. Maybe it is OK to have only one physical database.
Maybe MySQL is a good idea to use as a replica that would be refreshed
nightly. Or XML data would be OK to server only extranet.

What would be the best idea to do.

We are all MS shop.

Thanks in advance for any help,
Tom


Feb 9 '06 #4
Tom,

That shouldn't be a problem. Here's an article about consuming webservices
from classic asp:

http://www.4guysfromrolla.com/webtech/070302-1.shtml

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
"asdf" <as**@asdf.co m> wrote in message
news:LW******** ************@ne ws20.bellglobal .com...
Is this OK to use webservices also when the Intranet is written in the old
ASP?

"S. Justin Gengo [MCP]" <justin@[no_spam_please]aboutfortunate. com> wrote
in message news:uq******** ******@TK2MSFTN GP10.phx.gbl...
Tom,

Web services may be a nice way to give extranet users access to the data.
That way it's easy to lock down what the users have access to. I don't
know how your network is set up, but that's the solution we used when a
few of our select database had to be opened up read-only to outside users
where I work. We allow the webserver to connect to a webservices server
that is only accessible by it. Then the webservices server connects to
the database.

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
"asdf" <as**@asdf.co m> wrote in message
news:vM******** ***********@new s20.bellglobal. com...
Hi,

Currently, I have one database for Intranet clients on the server behind
the
firewall. But I was asked to allow the extranet users to access the same
data. From the security perspective what is the best way to make that
data
accessible.

Should we have two databases one for Intranet and one for Extranet? In
that
case the second one would be a replica but that would cost us money for
the
extra MS SQL license. Maybe it is OK to have only one physical database.
Maybe MySQL is a good idea to use as a replica that would be refreshed
nightly. Or XML data would be OK to server only extranet.

What would be the best idea to do.

We are all MS shop.

Thanks in advance for any help,
Tom



Feb 9 '06 #5
Thank you so much Justin!

Tom
"S. Justin Gengo [MCP]" <justin@[no_spam_please]aboutfortunate. com> wrote in
message news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..
Tom,

That shouldn't be a problem. Here's an article about consuming webservices
from classic asp:

http://www.4guysfromrolla.com/webtech/070302-1.shtml

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
"asdf" <as**@asdf.co m> wrote in message
news:LW******** ************@ne ws20.bellglobal .com...
Is this OK to use webservices also when the Intranet is written in the
old ASP?

"S. Justin Gengo [MCP]" <justin@[no_spam_please]aboutfortunate. com> wrote
in message news:uq******** ******@TK2MSFTN GP10.phx.gbl...
Tom,

Web services may be a nice way to give extranet users access to the
data. That way it's easy to lock down what the users have access to. I
don't know how your network is set up, but that's the solution we used
when a few of our select database had to be opened up read-only to
outside users where I work. We allow the webserver to connect to a
webservices server that is only accessible by it. Then the webservices
server connects to the database.

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
"asdf" <as**@asdf.co m> wrote in message
news:vM******** ***********@new s20.bellglobal. com...
Hi,

Currently, I have one database for Intranet clients on the server
behind the
firewall. But I was asked to allow the extranet users to access the
same
data. From the security perspective what is the best way to make that
data
accessible.

Should we have two databases one for Intranet and one for Extranet? In
that
case the second one would be a replica but that would cost us money for
the
extra MS SQL license. Maybe it is OK to have only one physical
database.
Maybe MySQL is a good idea to use as a replica that would be refreshed
nightly. Or XML data would be OK to server only extranet.

What would be the best idea to do.

We are all MS shop.

Thanks in advance for any help,
Tom



Feb 10 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1110
by: Luis Esteban Valencia | last post by:
I have an application on my intranet It works fine there when I copied the proyect to the server of the Internet it gives me this error. The arquitecture of my servers are. There is one Server for Internet another server for Databases and another server for Intranet. The only one that has public IP is the Internet Server and obviously I cant give public access to the database server. The applicacion access data on the database server....
5
2814
by: Martin Heuckeroth | last post by:
Hi We are working on a webservice application and are having some problems with the cookies and/or sessions. We have them working on our intranet but then its not working on the internet. We have been looking our asses off but can not find a working solution. the code we came up with is ...
3
2138
by: sanjeeev | last post by:
I am loooking for the bet way to share files between Internet and Intranet application in real time, means as soon as an file is uploaded to the intranet application it should show up in the internet application. Thanks,
1
1081
by: asdf | last post by:
Hi, Currently, I have one database for Intranet clients on the server behind the firewall. But I was asked to allow the extranet users to access the same data. From the security perspective what is the best way to make that data accessible. Should we have two databases one for Intranet and one for Extranet? In that case the second one would be a replica but that would cost us money for the extra MS SQL license. Maybe it is OK to have...
2
1974
by: =?Utf-8?B?Sm9zZXBo?= | last post by:
I am building an ASP.Net 2.0 application that will be accessible through both internet and intranet. The application will use two different types of security methods, depending on whether the application is being accessed through internet or intranet. I am trying to figure out how to write the code necessary to have the application make the determination and thereby use the appropriate security method. Does anyone have any ideas or...
8
3851
by: mouac01 | last post by:
I'm not sure if this is possible. I would like to have a PHP app on the Internet connect and write to a local database (Intranet). For example, users would go to a web site http://www.internet.com to run the app. The app requires an internet connection and is outside of the user's network. The app would have the option to either store data locally or on the Internet. I would like to give users the option to store data locally because...
9
9161
by: c83 | last post by:
I want programaticaly to change the IE security settings for Intrante Sites. IE Menu: Tools->Internet options->security(Tab)->Local Intranet ->sites i found out that IE stores data in Registry at HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings\ZoneMap and there i-am writing keys: IntranetName = dword:00000001 ProxyByPass = dword:00000001 UNCAsIntranet = dword:00000001. Theese keys appears after we...
1
3360
by: nagmvs | last post by:
Hai all, I want to do a project that Connecting Internet to Intranet with all security.Can any ideas please ? . My project description: We have some clients those are transcript our data through internet.Daily we provide some data to those clients those r working in home.Suppose we send 5 files means they transcribed those files and send to our database using my company database. Now we want to send only one file at a time and after...
3
2626
by: RogerTM | last post by:
Hi, iīm using Window 2003 server, a wireless LAN, and 75 users, all of them need internet, so troughout a proxy i give the internet access to all of them but i need to all my users go to the intranet first to see the new and posts. is there any way to do this?, the user opens the browser, they got into the intranet first and after that they push a button or a comand embeded into the intranet grants them access to the web, whitout returning to...
0
9886
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
9730
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10983
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10647
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10706
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10338
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5719
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5911
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4528
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.