Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I need some help i am working on a project and need to deploy my application which currently has a database running on SQL Server 2008 and my software is developed in VB.Net, The client needs to deploy the application to various regions and inter-connect the application. I found it tricky how can i inter-connect my application over the internet or rather place SQL Server online on the internet as the client is NOT interested with SQl Azure or any of those kind of services.

As per my application i know i can play with a few setting and get it connected online i have tested it and it worked! But how to make SQL Server online? Do i need to get a domain? and how to configure it?

I have researched online and didn't get much help so thought to put up this post in case someone would help me.

This question came from our site for professional and enthusiast programmers.

1

I'm not sure, if I understand the core of the problem. But I try to explain it how I understood it and my solution. You have a SQL Server you need to make accessible somewhere on the internet? And your application needs to access there?
–
MartinAug 24 '12 at 13:15

1

You might consider hosting your SQL database at a service provider - there are a lot of security concerns you need to address and a provider is likely to have more experience.
–
StuartLCAug 24 '12 at 13:20

4 Answers
4

As long as you have the TCP/IP protocol enabled for the instance, and you have created an exception on your firewall for the port that SQL Server uses (I hope you are using a firewall!) then connecting to it would be no different to how you would connect to it normally.

However, just remember that as soon as you make it publicly available you are opening yourself up to a world of hurt. Not everyone out there is as honest as you might like and people will try and break in - so be prepared.

An alternative solution is to use some type of connection layer such as VPN or Citrix or any other type of private connection topology. Only as a last resort should you make it publicly available - and if you do, make sure you lock it down.

Basically for security reason Database server is internally connected
to the application server. All the data insert or update request comes
to it through port-80 enabled application server(IIS). Hope through
diag. you are able to understand the arrangement of application and
database server over the internet.

MSSQL uses port 1433 as far as I know. And your app can access to an IP adress with the port 1433 --> xxx.xxx.xxx.xxx:1433. You just need to make this port accessible through routers and firewalls - that's it!