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.
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:
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:
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with premium.
Start your 7-day free trial.
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.
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
Check current machine name after the upgrade.
Check Windows's services to see whether the Sql server Instance is up/started
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
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
Did you check the SQL Server service account? Windows 10 may change the way those internal accounts are working now.
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
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
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.
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.
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with premium.
Start your 7-day free trial.
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/lapto
HTH
David