How to connect to an SQL Server Remotely

  • Thread starter Thread starter sherwin
  • Start date Start date
S

sherwin

Hi! I hope somebody can help me on this.

I build an application from VB and MS SQL Server. I want to access the
server from a different location via the internet. I have an ordinary
D-Link router (dont know what the model is) connected to a 2GB DSL
Internet connection.

Somebody told me that the server needs to have a fixed IP address for
the application to connect. All I need is an SQL connection with the
server.

So if anybody of you got any ideas on this, pleaseeeeeeeeeee do reply
on this posting. Thanks
 
You'll need to port forward TCP port 1433 and UDP port 1434 to the static IP
address of your SQL server.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Hi! I hope somebody can help me on this.
|
| I build an application from VB and MS SQL Server. I want to access the
| server from a different location via the internet. I have an ordinary
| D-Link router (dont know what the model is) connected to a 2GB DSL
| Internet connection.
|
| Somebody told me that the server needs to have a fixed IP address for
| the application to connect. All I need is an SQL connection with the
| server.
|
| So if anybody of you got any ideas on this, pleaseeeeeeeeeee do reply
| on this posting. Thanks
|
| --
| Posted using the http://www.windowsforumz.com interface, at author's
request
| Articles individually checked for conformance to usenet standards
| Topic URL:
http://www.windowsforumz.com/Work-Remotely-connect-SQL-Server-ftopict400467.html
| Visit Topic URL to contact author (reg. req'd). Report abuse:
http://www.windowsforumz.com/eform.php?p=1323814
 
Back
Top