Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Allowing Remote Connections
Message
 
À
19/06/2013 18:43:34
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:
01576760
Vues:
65
>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?

Instructions..

Step 1 - Don't do it!!

Step 2 - See Step 1!

Set up a webservice(s), use a VPN, etc.

Putting your SQL server on the public internet is just inviting DOS and hack attacks. Been there. Done that.
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform