SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified [closed]

by

If you are connecting from Windows machine A to Windows machine B (server with SQL Server installed), and are getting this error, you need to do the following:

On machine B:

1.) turn on the Windows service called “SQL Server Browser” and start the service

2.) in the Windows firewall, enable incoming port UDP 1434 (in case SQL Server Management Studio on machine A is connecting or a program on machine A is connecting)

3.) in the Windows firewall, enable incoming port TCP 1433 (in case there is a telnet connection)

4.) in SQL Server Configuration Manager, enable TCP/IP protocol for port 1433

enter image description here

More Related Contents:

  1. Custom MembershipProvider in .NET 4.0
  2. How to combine using Membership API with own application related data?
  3. Is it possible to change the username with the Membership API
  4. How to assign Profile values?
  5. Stored procedure slow when called from web, fast from Management Studio
  6. Multiple applications using same login database logging each other out
  7. Error – SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM
  8. An attempt to attach an auto-named database for file ….database1.mdf failed
  9. ASP.NET authentication login and logout with browser back button
  10. A network-related or instance-specific error occurred while establishing a connection to SQL Server [closed]
  11. HTTP Error 500.22 – Internal Server Error (An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.)
  12. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’
  13. Using one Asp.net Membership database with multiple applications Single Sign On
  14. ASP.NET MVC3 Role and Permission Management -> With Runtime Permission Assignment
  15. Sitecore authenticate users against external membership database
  16. Where does Console.WriteLine go in ASP.NET?
  17. Getting RAW Soap Data from a Web Reference Client running in ASP.net
  18. Reading web.config from JavaScript
  19. The type initializer for ‘System.Data.Entity.Internal.AppConfig’ threw an exception
  20. How to allow download of .json file with ASP.NET
  21. How can I use the button tag with ASP.NET?
  22. ASP.NET Stress Testing
  23. file download by calling .ashx page
  24. asp.net mvc Adding to the AUTHORIZE attribute
  25. Entity Framework 4 – Update database schema from model. Without wiping the table data
  26. “
  27. ASP.Net Text with LineBreak from Multi-Line-TextBox to save in a database
  28. web.config and app.config confusion
  29. How to detect/track postback in javascript?
  30. IIS AAR – URL Rewrite for reverse proxy – how to send HTTP_HOST

Leave a Comment