Internet - Intranet Data Dilema

asdf

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

Subscribe Reply

1255

S. Justin Gengo [MCP]

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

Andrew Robinson

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

asdf

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

S. Justin Gengo [MCP]

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

asdf

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

Similar topics

1096

Problems migrating applicacion from Intranet to Internet. Underlying connection was closed.

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

ASP.NET

2803

Cookies working on intranet but NOT working on Internet

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

ASP.NET

2129

File sharing between Internet and Intranet for ASP.net application

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,

ASP.NET

1075

Internet - Intranet Data Dilema

by: asdf | last post by:

.NET Framework

1966

Internet/Intranet application

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

.NET Framework

3837

Connecting to local database from Internet

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

PHP

9152

Internet Explorer and Windows registry

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

Microsoft Windows

3352

Connecting Intranet to Internet

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

Networking - Hardware / Configuration

2620

how to force users of a network browsing on internet to an intranet first

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

IIS / Internet Information Server

8457

What is ONU?

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

General

8788

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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

Online Marketing

8563

The easy way to turn off automatic updates for Windows 10/11

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

Windows Server

8646

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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

General

6203

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5675

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4200

Trying to create a lan-to-lan vpn between two differents networks

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

Networking - Hardware / Configuration

2013

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1778

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General