Improve company productivity with a Business Account.Sign Up

x
?
Solved

VB.net and SQL Server - online database

Posted on 2013-06-01
4
Medium Priority
?
236 Views
Last Modified: 2014-11-12
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
Comment
Question by:Murray Brown
4 Comments
 
LVL 71

Accepted Solution

by:
Éric Moreau earned 668 total points
ID: 39212863
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
 
LVL 11

Assisted Solution

by:Wayne Michael
Wayne Michael earned 664 total points
ID: 39213600
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
 
LVL 10

Assisted Solution

by:adriankohws
adriankohws earned 668 total points
ID: 39214024
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
 

Author Closing Comment

by:Murray Brown
ID: 39228437
Thank you for the advice
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Simulator games are perfect for generating sample realistic data streams, especially for learning data analysis. It is even useful for demoing offerings such as Azure stream analytics, PowerBI etc.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question