How To Fix Microsoft SQL Server Connection Error 26(Error Locating Server/Instance Specified)?


  • Hello everyone, microsoft SQL server working without any problem give "Error 26 - Error Locating Server/Instance Specified" error for no reason. The following steps are followed to solve this problem.



  • First Step: We have tried connection to the our SQL Server. We failed.

 


  • Second Step: We should press at the same time “Windows” and “R” keys. Later, we will write “services.msc” Windows command. And click "OK" button.




  • Third Step: We should find “SQL Server (SQLEXPRESS)" service. Right click and select “Start” button.




  • Fourth Step: To avoid the same error after the computer is turned off and on, we should check “Startup Type” status. Again right click on the “SQL Server (SQLEXPRESS)” service, select “Properties” button. If “Startup Type” is “Manual” or other, we should make “Automatic” it. To save the changes we have made, first click on "Apply" and then on the "OK" button.



  • Fifth Step: Finally, we try to connect again. So, there isn’t any problem, it’s working. :)




" How To Fix Microsoft SQL Server Connection Error 26(Error Locating Server/Instance Specified)?" This was the article, you can submit your questions on the site or via social media. Thank you. 😊











Yorumlar

En Çok Okunanlar

How To Fix Microsoft Visual Studio Code Unins000.exe Error?

Windows İşletim Sisteminde Versiyon ile Sürüm Arasındaki Fark Nedir?

Windows’da Bilgisayar Domaine Nasıl Alınır?