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

connect
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?
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 DBACommented:
Hi,

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?

HTH
  David
0
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
Hi David,

This is local server on my laptop. No remote device is involved.
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
HuaMin ChenProblem resolverCommented:
Check current machine name after the upgrade.
Check Windows's services to see whether the Sql server Instance is up/started
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

HuaMin ChenProblem resolverCommented:
Maybe Windows machine name is adjusted right after the upgrade
0
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
0
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.
0
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.

Thanks,

Mike

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
0
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.
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.