Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connecting to SQL Server from Desktop
Message
From
21/08/2013 05:12:50
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01580771
Message ID:
01580873
Views:
34
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform