asked on 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]()
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:
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008Databases
Last Comment
Mike Eghtebas
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Maybe Windows machine name is adjusted right after the upgrade
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Did you check the SQL Server service account? Windows 10 may change the way those internal accounts are working now.
ASKER
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 https://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 https://www.experts-exchange.com/questions/28703696/SQL-Server-2014-firewall-setting.html
ASKER
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.