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.
| Author |
Topic |
|
llexis20
Starting Member
2 Posts |
 Posted - 2010-10-11 : 21:33:29
|
| Good Day,Scenario: We have main ofice and branch. Are system is in the Main office and we are going to create a VPN. Main office(Local connection) are no problem connecting to the SQL using SQL authentication. Now my problem is how to connect VPN for my branch. tha following are the concerns:1. Are they any configuration of SQL server 2008 r2 for connecting VPN?2. what port are we going to UP to connect per unit and server?3. Where using Zywall usg 300 to main office and USG 200 router for connecting VPN by Authentication PRE-SHARED Key. Is there any configuration that need to configure for SQL server 20089 r24. please gave step by step method to connect our branch to main office?thanks you so much! |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-11 : 22:11:08
|
| Over VPN, if connecting directly to SQL Server, the remote clients need to be part of the same domain that the home office is on.Port doesn't matter. Once connected to the VPN it will be as though the remote users were in the same building/network (as long as they are part of the domain). Changing the port # is never a bad idea, but isn't necessary with VPN.If they aren't part of the domain, they'll need to RDP or Citrix or similar technology to access SQL, as well as other resources. |
 |
|
|
llexis20
Starting Member
2 Posts |
Posted - 2010-10-11 : 22:56:01
|
| HI Russell,Domain means AD right? all my clients mas be a AD user to connect SQL Database to be part of the domain.Im not using AD in our office but eventhough i can connect to SQL database using SQL Authentication and user that i created. Are system is Microsoft Navition "Accounting software connected to the database of SQL server 2008 r2", process for this is to install the NAV cd per computer, once installed open the NAV system and a screen will pop up showing Server Name (IP Addres of the server or Server name) Database Name (database name of SQL connections) Authentication ( Database SQL Authentication not AD authentication) Username & password. DO think if i install the Nav system from our branch and input the server name, database name then connect log in will it connect to the main office? With out Using RDP or etc. VPN is fully configured and allowed port 1433 for SQL. Main office IP 192.168.2.x and Branch IP 192.168.1.X connection for there tunnel is successfull. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-12 : 11:22:00
|
| I should have specified, that need to be same domain if using windows authentication.Glad you're up and running |
|
|
|
|
|
|
SQL Server 2008 R2 connection thru VPN