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 |
|
polkmn
Starting Member
4 Posts |
 Posted - 2011-06-26 : 17:50:09
|
| Hi,I'm trying to remotely access a SQL Server 2008 R2 over a VPN tunnel automatically set up by using TeamViewer.I'm trying to set up an ODBC connection and keep getting error messages such as:"Connection Failed:SQLState: '01000'SQL Server Error: 10061[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).Connection Failed:SQLState: '08001'SQL Server Error: 17[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied."Does anybody have any ideas what happened and how I should solve this?Thank you. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-26 : 18:36:44
|
| Make sure that TCP port 1433 is open in both directions in your TeamViewer settings. |
 |
|
|
polkmn
Starting Member
4 Posts |
Posted - 2011-06-27 : 01:02:23
|
| Thanks robvolk.I checked the TeamViewer config settings but didn't see any place to open/close ports... |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-27 : 06:25:58
|
| Do you have TeamViewer configured on the SQL Server? Is Windows firewall running on either machine? |
|
|
|
polkmn
Starting Member
4 Posts |
Posted - 2011-06-27 : 08:17:28
|
| Sorry for the late response (and thank you for your patience).I have TeamViewer configured on the server and Symantec Endpoint Protection instead of Windows' Firewall.I've added a rule for bi-directional data on port 1433.Still nothing...I should probably give you the entire picture:We have an MS Access DB on a computer in the main office and have to start using SQL Server.A user has the Access application only on his laptop and has to connect to the tables in the main office via the internet.1. I used SQL Server Import/Export tool and transformed the DB.2. TeamViewer is used to establish the VPN connection.3. I tried to configure an ODBC connection on the laptop and create a Linked Table. Tis is where I got stuck.Any thoughts? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-27 : 10:06:53
|
| I haven't used the VPN feature of TeamViewer, so I can't advise you on how to troubleshoot it beyond what I've already posted. I'd suggest contacting their support.Normally I'd put the Access application on a computer inside the office and then use TeamViewer or RDP to connect to it, and use it like a local application. This is more secure as data is not sent over the VPN, and the performance will likely be much better, especially for large data sets. |
|
|
|
polkmn
Starting Member
4 Posts |
Posted - 2011-06-27 : 12:59:26
|
| I think I'll do that.Robvolk - thank you very much for your efforts. |
|
|
|
|
|
|
Cannot access SQL Server over TeamViewer VPN