We help IT Professionals succeed at work.
Get Started

Connet to SQL Server 2008 Exp over VPN with Windows 7

970 Views
1 Endorsement
Last Modified: 2012-05-09
Hi,

  I need to connect to a MSSQL 2008 Express over a VPN on my laptop using Windows 7 Pro. The VPN connection is good. It gives me an IP address. I can ping the remote server. But when trying to connect with SSMS it gives me the following:

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)

On my old XP Pro, it works fine (with, of course, the same connection parameters, login, etc). So, I guess it's a Windows 7 stuff. Firewall has been disabled on my Win7.

Any idea what it could be??

thanks for your time
Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE