p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2000 (http://p2p.wrox.com/forumdisplay.php?f=20)
-   -   Connect to SQL server 2000 from home! (http://p2p.wrox.com/showthread.php?t=42994)

Jane May 25th, 2006 02:31 AM

Connect to SQL server 2000 from home!

anybody can help me ? how do i connect to sql server 2000 from home?
what should i have and what should i need?

Thks & regards


joefawcett May 25th, 2006 02:41 AM

Perhaps you should read:



Joe (Microsoft MVP - XML)

robprell May 25th, 2006 06:35 PM

port 1433 need to be open assuming you used the default port. The firewall on the server side also needs to allow an external connection and possibly do network address translation. Or your could use VPN.

David_the_DBA May 29th, 2006 05:35 PM

VPN is much safer!

David Lundell
Principal Consultant and Trainer

deepakgnair May 31st, 2006 10:14 AM

We are using VPN to connect to SQL Server from remote system..Its working perfectly..

robprell June 7th, 2006 03:42 PM

It all depends on how your server is configured. You could configure your server to accept port 1433 data only if it comes from your hope ip address, ignoring all requests from other ip addresses. Mysql and Postgres (free sql servers) allow this out of the box. With MS-SQL you can do this with external firewall equipment. It all depends on what you want to accomplish. Some would argue that this solution is more safe than VPN. Your security solution is up to you. Question is not how do you connect from home, but more how is your server configured to allow remote connections. Because the answer to that will tell you how you connect at home.

All times are GMT -4. The time now is 09:03 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.