SQL Server Login After Windows 10 upgrade

Mike Eghtebas
Mike Eghtebas used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
David ToddSenior Database Administrator
Commented:
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
Database and Application Developer
Commented:
Hi David,

This is local server on my laptop. No remote device is involved.
HuaMin ChenProblem resolver
Commented:
Check current machine name after the upgrade.
Check Windows's services to see whether the Sql server Instance is up/started
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

HuaMin ChenProblem resolver

Commented:
Maybe Windows machine name is adjusted right after the upgrade
Mike EghtebasDatabase and Application Developer
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ãoIT Engineer
Distinguished Expert 2017

Commented:
Did you check the SQL Server service account? Windows 10 may change the way those internal accounts are working now.
Mike EghtebasDatabase and Application Developer

Author

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
Mike EghtebasDatabase and Application Developer

Author

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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial