Hi, I have SQL Server 2008 Express edition and 123 database. I would like to connet to this database from client MS Access (adp project) from anywhere - school, my team for developing... I don't have public IP, so I guess I have to use VPN - Hamachi. I create Hamachi server with XXX.XXX.XXX.XXX IP adress, my friends connect - now we have "local" network - in the windows we can share folder etc. But if they want to connect from MS ACCESS to my database on my server - error. On the server I have enabled TCP/IP service and in this features I have on the firt place IP from my Hamachi and TCP port 1433. Windows firewall is off. Please, can you help me to solve this problem? I have to solve it, because my team cannot developing project in ACCESS without server :( Thanks!
Is your SQLExpress instance listening on Port 1433? You might want to check that first. Look in the SQL Server Configuration Manager for the protocols that SQL Server is listening in on. If TCP/IP is enabled, then double-click, and search around - it'll tell you which port it's listening in on. I scribbled some notes to myself on this a while ago at
http://thelonedba.wordpress.com/2011/06/11/ports-for-sql-server-services/ - they may be of help in finding what you need. A handy query to find the port that SQL Server is listening on (if it's listening out for TCP/IP traffic in the first place) is: SELECT distinct local_net_address, local_tcp_port FROM sys.dm_exec_connections WHERE local_tcp_port IS NOT NULL AND net_transport = 'TCP'
Along with verifying SQL Server ports are open and listening you will also need to create a SQL Login and grant it access to that database. Your team will need this in order to get the ODBC connection from Access to talk to the SQL Server database.