How to connect to an SQL Server Remotely

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sherwin - 27 Jul 2005 03:35 GMT

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

Signature

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

Reply to this Message

Dave Patrick - 27 Jul 2005 04:05 GMT

You'll need to port forward TCP port 1433 and UDP port 1434 to the static IP
address of your SQL server.

Signature

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.
|
[quoted text clipped - 9 lines]
| So if anybody of you got any ideas on this, pleaseeeeeeeeeee do reply
| on this posting. Thanks

Reply to this Message