Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Allowing Remote Connections
Message
 
 
À
20/06/2013 10:57:12
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Installation
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Desktop
Divers
Thread ID:
01576737
Message ID:
01576779
Vues:
34
Check http://whatismyipaddress.com/ and see if you can ping this IP from the remote computer.

>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?
Christian Isberner
Software Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform