SQL Server 2008 remote connect to database

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 :(

more ▼

asked Apr 14, 2012 at 02:17 PM in Default

hepios gravatar image

20 2 2 2

(comments are locked)
10|1200 characters needed characters left

2 answers: sort oldest

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'
more ▼

answered Apr 14, 2012 at 03:37 PM

ThomasRushton gravatar image

ThomasRushton ♦
34.2k 18 20 44

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Apr 14, 2012 at 05:09 PM

Shawn_Melton gravatar image

5.4k 20 21 29

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 14, 2012 at 02:17 PM

Seen: 903 times

Last Updated: Apr 14, 2012 at 05:09 PM