Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ODBC - Connecting to SQL2012 Express from another PC
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
Application:
Desktop
Divers
Thread ID:
01562579
Message ID:
01562612
Vues:
33
>I've used PortQry, on 1433 and 1434, and the results are:
>
>TCP Port 1433: listening
>UDP Port 1433: not listening
>TCP Port 1434: not listening
>UDP Port 1434: not listening


In SSMS, if you look at the Current SQL Server Log under Management/SQL Server Logs, you should see entries stating "Server is listening on" followed by IP protocol name and a port number. Do you see something like that? If not, the server is not using TCP/IP.

As far as firewalls go, if these machine are on an internal network, shut off the firewall on the machine running SQLExpress (at least while troubleshooting). Check A/V and make sure it doesn't have a firewall running as well.
____________________________________

Don't Tread on Me

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

Click here to load this message in the networking platform