The TeamViewer app allows you to accomplish all of this as if you were sitting right in front of the remote computer. Provide spontaneous support for friends and family, or access applications on your home computer while on the go. I think I'll do that.Robvolk - thank you very much for your efforts.Remote control Windows, Mac, and Linux computers with TeamViewer: Remote Control within seconds. 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. The prerequisite for this is that the multi-user mode has been activated in the. The server ID can be displayed by clicking on the lamp symbol behind the user ID in the TeamViewer graphical user interface. 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. The server ID enables a login independent of user sessions and brings the user to the login screen of the Windows server in TeamViewer. 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 tried to configure an ODBC connection on the laptop and create a Linked Table. TeamViewer is used to establish the VPN connection.3.
I used SQL Server Import/Export tool and transformed the DB.2. 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. Thanks robvolk.I checked the TeamViewer config settings but didn't see any place to open/close ports.ĭo you have TeamViewer configured on the SQL Server? Is Windows firewall running on either machine? Make sure that TCP port 1433 is open in both directions in your TeamViewer settings. 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: 10061ConnectionOpen (Connect()).Connection Failed:SQLState: '08001'SQL Server Error: 17SQL Server does not exist or access denied."Does anybody have any ideas what happened and how I should solve this?Thank you. All ForumsĬannot access SQL Server over TeamViewer VPN TeamViewer will show the current screen that also the user will see in front of the pc. We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with.
0 kommentar(er)
