Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connecting to SQL Server from Desktop
Message
De
21/08/2013 05:12:50
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01580771
Message ID:
01580873
Vues:
33
>Another possible cause could be that the customer network admin says that "SQL Service is not listening on tcp 1433". How do you set SQL Server to listen to this port?

It's in the configuration tool, server protocols, rightclick on TCP/IP, check properties - probably under some advanced button or 2nd page. There's also one of the values just above the port, probably line 3 in each port's section, which is blank but needs to be zero if you want this to work (which I googled out when I needed it, and of course can't find again)

Even better, if the admins frown at the usage of 1433, which every kid knows is the SQL port, try to agree to some other port instead, and activate that port. Then in your connectstring the server section becomes "...;Server=ServerNameHere,12345;" assuming 12345 is the port you opened.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform