Jim Lawrence
accessd at shaw.ca
Sun Jul 29 02:23:55 CDT 2007
Hi John: An interesting question; I am working on a similar project since June but have been delayed due to immediate projects. The simplest way would be to create a share on the remote site to the SQL DB, install Hamachi on the remote computer and then you could link from the local SQL server, through the EM to the remote DB. Or connect to the remote DB through a connection string could look like: "Provider=SQLOLEDB; Initial Catalog=Registration; Data Source=\\5.24.64.128\MsDB; Integrated Security=SSPI". Do this all the time for remote backup but have not had a chance to test all the variations for MS SQL. HTH Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Saturday, July 28, 2007 10:47 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Accessing SQL Server over the internet Is it possible to connect to a SQL Server database over a HAMACHI VPN connection? If so how? John W. Colby Colby Consulting www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com