Avatar of digitalwise
 asked on

Local SQL Server and Broadband Card

I have a local copy of SQL 2014 running on my computer that I use for testing purposes for web development.   It works great as long as I am either A.  not connected to the internet (ie, on travel and just working) or B. on my local dedicated IP address internet connection.   If I use my broadband card for mobile internet, I get The requested instance is either invalid or not running.     I have never had this with my old computer so I clearly am missing some set up in SQL...    Any ideas?
Microsoft SQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon
Rainer Jeschor

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Imran Javed Zia

If you are using IP address to access it then it may not work. It will be better to use Name instance if you have.
Ryan McCauley

Instead of using "localcomputername\instancename", can you connect as ".\instancename" (that's a period)? That tells SSMS to connect to the local server, rather than to the DNS name you provide (which may also be local).

I've seen this before (though in that case, it was an app that would only launch if the wireless connection was inactive - if you activated it first, the app would fail to launch), If this is the case and connecting to the server as a "." (period) works, I suspect it's either something with a firewall on that wireless connection or something to do with how network traffic is routed. When that connection is active, it routes traffic out of the network connection and back in through the external interface, and it might be blocked by the firewall on the connection if that happens.

This worked.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.