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!
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:
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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/lapto
HTH
David
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
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
Premium Content
You need an Expert Office subscription to comment.Start Free Trial