Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor
  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Error: 26 SQL Server does not allow remote connections...

Error: 26 SQL Server does not allow remote connections...

Scheduled Pinned Locked Moved Database
databasesql-serversysadminhelpquestion
3 Posts 3 Posters 1 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • I Offline
    I Offline
    Illegal Operation
    wrote on last edited by
    #1

    Hi! I have recently published a website to a Windows 2008 x64 Server with SQL 2005 Express Edition. I am able to logon to the website but when I navigate to view employees for instance then I get the error 26 message. I enabled the TCP/IP and Named Pipes Protocols, added SQL browser.exe to the firewall including port 1433 and 1434. I also checked to make sure SQL Browser is running. Does anyone have any suggestions?

    Illegal Operation

    N S 2 Replies Last reply
    0
    • I Illegal Operation

      Hi! I have recently published a website to a Windows 2008 x64 Server with SQL 2005 Express Edition. I am able to logon to the website but when I navigate to view employees for instance then I get the error 26 message. I enabled the TCP/IP and Named Pipes Protocols, added SQL browser.exe to the firewall including port 1433 and 1434. I also checked to make sure SQL Browser is running. Does anyone have any suggestions?

      Illegal Operation

      N Offline
      N Offline
      Niladri_Biswas
      wrote on last edited by
      #2

      Hi, I have not worked in Windows 2008 x64 Server with SQL 2005 Express Edition. So I am not able to give a deep insight on that. However, I have searched in google with ur problem and found this site. Please check if it helps. SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified [^] :)

      Niladri Biswas

      1 Reply Last reply
      0
      • I Illegal Operation

        Hi! I have recently published a website to a Windows 2008 x64 Server with SQL 2005 Express Edition. I am able to logon to the website but when I navigate to view employees for instance then I get the error 26 message. I enabled the TCP/IP and Named Pipes Protocols, added SQL browser.exe to the firewall including port 1433 and 1434. I also checked to make sure SQL Browser is running. Does anyone have any suggestions?

        Illegal Operation

        S Offline
        S Offline
        shantanu gupta
        wrote on last edited by
        #3

        I too had the same problem some time back and I too tried many solutions. Here are the few good steps and a video to resolve this error. http://techpint.com/programming/error-26-%E2%80%93-error-locating-serverinstance-specified-sql-server[^]

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes

        • Login
        • Don't have an account? Register
        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups