Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 313
  • Last Modified:

Connecting a Visual Basic .Net program to an SQL Server over the internet

Hello all.

I'm in charge of maintaining a program written in VB .Net. Currently it connects to an SQL Server 2000 database which resides on a server on our LAN.

Is it possible to allow the program to connect to the database via the internet? The server is connected to the internet and has a fixed ip address. Programming-wise, what are the changes needed?

Hope somebody can point me in the right direction.

Thanks.
0
sis5
Asked:
sis5
2 Solutions
 
gregoryyoungCommented:
I would highly not recommend doing this as it will open your database up to the world, instead I would use remoting to broker objects back to the client over the internet. This way you don't have to open your sql server up to the world ...  esp considerring the recent worms which have targetted sql server.

but if you insist upon doing it, all you would need to do is change the connection string change the server= to the ip address.
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

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