• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 644
  • Last Modified:

SQL Management studio won't connect over VPN

Hi,

I used to connect to SQL Server 2005 with SQL Management Studio 2005 locally and through VPN no problems under win XP pro. Since fresh install of vista business x64, I can connect locally no problems, but over the vpn I get the following error message.

TITLE: Connect to Server
------------------------------

Cannot connect to 192.168.0.100\ENERNET.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

I tried multiple ways to connect, (FQDN, NetBios ect...) I won't connect. Perhaps my apps using SQL Server run no problems  over the VPN.

Any one has a clue?
0
Enernet
Asked:
Enernet
  • 2
1 Solution
 
James MurrellProduct SpecialistCommented:
Firewall??? check ports
0
 
EnernetAuthor Commented:
No firewall on Server, ports 1433 & 1434 open on router, (connected through vpn on PPTP)
0
 
EnernetAuthor Commented:
It was the firewall of my client machine (vista) that caused the issue
0

Featured Post

SMB Security Just Got a Layer Stronger

WatchGuard acquires Percipient Networks to extend protection to the DNS layer, further increasing the value of Total Security Suite.  Learn more about what this means for you and how you can improve your security with WatchGuard today!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now