Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Connect to SQL Server over Internet

Author  Topic 

ewe1d@yahoo.de
Starting Member

17 Posts

Posted - 2005-11-10 : 03:51:38
Hi,
We have a client that wants to connect to his SQL Server machine (inside company network) over the internet from a laptop client. We have identified 3 options for this, does anyone have any recommendations for these?

Option 1. Standard TCP/IP connection, open up Port 1433, enter SQL Server name in client "hosts" file. Are there issues here concerning sending unencrypted user/password over the Net?

Option 2. VPN: What additional software do we have to install on cli/serv and what other networking issues are there? What about single sign on: will SQL Server authenticate the Windows User logged in on the Laptop?

Option 3. Microsoft Internet Acceleration Server: is this any good? Also means buying licences, right?

Any help greatly appreciated
10Q
Chidd

Idriss
Starting Member

1 Post

Posted - 2005-11-10 : 06:59:30
Hi,
I've also a problem to connect to a remote sql server?
can some body tell me the right config i must do on both client and server side?

Idriss
Go to Top of Page
   

- Advertisement -