Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Allowing Remote Connections
Message
From
20/06/2013 10:57:12
 
 
To
20/06/2013 09:54:41
General information
Forum:
Microsoft SQL Server
Category:
Installation
Environment versions
SQL Server:
SQL Server 2008
Application:
Desktop
Miscellaneous
Thread ID:
01576737
Message ID:
01576777
Views:
40
Thanks, how do I determine if I have a public IP?

I'll look into Hamachi as well.

>That would only work if you have a public IP, and then you have to set port forwarding at the router.
>
>If you don't have a public IP address, a workaround would be to create a network using Hamachi from LogMeIn, I did that once and it was pretty easy to setup, and it's free if I remember correctly.
>
>>I believe that I have that configured as I am able to connect to the database from a different PC on the local network.
>>
>>I understand that I need to know the IP address of the database server, how would I determine that? This is what I would need to use in my connection string from the PC outside the LAN.
>>
>>>In SQL Server Management Studio, did you check "Allow remote connections" in the server properties?
>>>
>>>
>>>>This is actually SQL Server Express 2012 .
>>>>
>>>>I have two PCs in a workgroup at a client. Both running Win 7 Home Premium. I have installed SQL Server Express 2012 on one and my system running on that PC is able to access it.
>>>>
>>>>I have:
>>>>
>>>>1. enabled TCP/IP and named pipes
>>>>2. set dynamic ports to blank and set a TCP port number
>>>>3. Added an exception for this port number in Windows firewall
>>>>
>>>>Is there anything I am missing? I can't access the data from the other PC.
>>>>
>>>>Update
>>>>
>>>>I found that I had changed the dynamic ports on IP2 (or was it IP4?) instead of IPALL. Once I did that I was able to connect.
>>>>
>>>>Now my next challenge is to allow a remote computer access to the database over the internet. Any suggestions of where to find instructions on how to do this?
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform