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?
digitalwiseAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rainer JeschorCommented:
Hi,
I would recommend to configure the SQL server just to listen on IP address 127.0.0.1 (if you do not have to connect from elsewhere to this instance) and not on all IP addresses. It seems that in the moment you use the broadband card, this network connection has an higher rank and is therefore chosen as "primary" return IP.
Therefore open SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols -> TCP/IP -> right click -> Properties -> Listen All -> No and then select the 127.0.0.1 IP address in the second tab.

HTH
Rainer
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Imran Javed ZiaConsultant Software Engineer - .NET ArchitectCommented:
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.
0
Ryan McCauleyEnterprise Analytics ManagerCommented:
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.
0
digitalwiseAuthor Commented:
This worked.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.