SQL Server Login After Windows 10 upgrade

With my SQL Server installation and login prior to the upgrade, I had no problems. But after the upgraded, I get:
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)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

Q: After reading the link, my first guess was "The SQL Server Browser service (sqlbrowser) is not started." but when I checked, I had:services
LVL 34
Mike EghtebasDatabase and Application DeveloperAsked:
Who is Participating?

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

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.

David ToddSenior Database AdministratorCommented:

Do you need to make changes to the new Windows Firewall on your pc?

I'm not clear if you are connecting to SQL on your machine (workstation/desktop/laptop), or on a remote machine (server). Can you clarify?

Mike EghtebasDatabase and Application DeveloperAuthor Commented:
Hi David,

This is local server on my laptop. No remote device is involved.

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
HuaMin ChenProblem resolverCommented:
Check current machine name after the upgrade.
Check Windows's services to see whether the Sql server Instance is up/started
SolarWinds® VoIP and Network Quality Manager(VNQM)

WAN and VoIP monitoring tools that can help with troubleshooting via an intuitive web interface. Review quality of service data, including jitter, latency, packet loss, and MOS. Troubleshoot call performance and correlate call issues with WAN performance for Cisco and Avaya calls

HuaMin ChenProblem resolverCommented:
Maybe Windows machine name is adjusted right after the upgrade
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
After 6 or 7 times trying to connect and failing, the last time it self-corrected and worked okay and none of those errors.

Well, after accepting the question, I am having the same problem. I am not able to connect to SQL Server any more.

I have posted a followup question at: http://www.experts-exchange.com/questions/28703620/Windows-10-sql-Server-2014-firewall-issue.html
Vitor MontalvãoMSSQL Senior EngineerCommented:
Did you check the SQL Server service account? Windows 10 may change the way those internal accounts are working now.
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
Hi Vitor,

I am not sure how exactly I could do that. You may want to give me some direction on the link below.



BTW, after deleting to followup question referred in my last post, I posted a new question to better describe the problem at http://www.experts-exchange.com/questions/28703696/SQL-Server-2014-firewall-setting.html
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
After 6 or 7 times trying to connect and failing, the last time it self corrected itself and worked okay and none of those errors.
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.