Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connecting To Named Instance SQL 2005
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01213101
Message ID:
01213423
Views:
14
Also make sure the firewall is not blocking the ports SQL Server uses. The Defaults are TCP 1434 and UDP 1435.

>>I modified my applications login routine to call the SQL 2005 instance, and it works from my workstation if I format the SERVER value as ".\SQL2005". But this will only work on my local workstation. On another workstation, that does not have SQL 2005 loaded, I tried to put it in as 192.168.30.36\SQL2005 but it fails. That format even fails on my local workstation.
>
>Use the Surface Area Configuration Manager and be sure the SQL Browser Service is running.
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain
Previous
Reply
Map
View

Click here to load this message in the networking platform