SQL Server

[hung_ngole]

I'm working with some people on other countries. I want all people will work on the same database at certain server. Help me ASAP ! Thanks ! Hung

[Christian Graus]

What version of SQL Server are you using ? I know this can be done, as I've connected to a SQL Server instance for a client in the USA, but I'm not sure how it's configured. I know SQL Server 2005 has a lot of new online functionality, but this was SS2000, I am certain. Christian Graus - Microsoft MVP - C++

[Colin Angus Mackay]

I've connected directly to a SQL Server 2000 instance over the internet through a VPN connection. It was a bit slower than on the LAN, but that was only to be expected. You can connect directly too, but even although my SQL Server is patched upto date I wouldn't want to expose it. My firewall log shows several blocked attempts at getting to SQL Server on my machine.

---

My: Blog | Photos WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

[Mandar Patankar]

I think There are several ways of doing this but of which i pretty much sure about is running your sql server instance on a server with Static IP. You also need to configure listener ports on the server. The connection string will look something like this This is Oledb provider Provider=sqloledb;Data Source=10.20.50.100,1521;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd if you are using Sql client on a Net framework skip the provider part and rest is same. I hope this is helpful enough Mandar Patankar Microsoft Certified professional

[Frank Kerrigan]

Create hole in the firewall on a different port than standard SQL server and use NAT to move this each side of the firewall. Also filter the IP address range if possible (providing others have fixed IP addresses.)