• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 236
  • Last Modified:

VB.net and SQL Server - online database

Hi

I have built systems over the past two years using an online SQL database, hosted on a service provider that I use. Their site provides a simplistic way to build new databases & tables

I now want to build something similar for a large corporation and am not sure about a few things.

Firstly, can an online SQL database reside on a corporation's servers or does it need to be hosted by a special service provider?

Secondly, if it is hosted on their servers, will I need one of their administrators to set it up?
0
Murray Brown
Asked:
Murray Brown
3 Solutions
 
Éric MoreauSenior .Net ConsultantCommented:
it all depends on if the corporation has a DMZ (a zone outside the very protected internal network but that still belongs to the company and still protected but visible from the outside world).

Have you tried SQL Azure: http://msdn.microsoft.com/en-us/library/windowsazure/ee336279.aspx
0
 
wrmichaelCommented:
You can setup a SQL server in the corporations network.  Dmz is one way to do this but you typically want external datasources isolated from the corporate network. So it makes the dmz a very good option.
0
 
adriankohwsCommented:
Yes, they are right. You can but security is a major concern. Obviously even not implementing DMZ, a lot of security measures must be considered, so obviously your System administrators must be involved.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thank you for the advice
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Tackle projects and never again get stuck behind a technical roadblock.
Join Now