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
  1. Home
  2. Web Development
  3. ASP.NET
  4. sql server to web server

sql server to web server

Scheduled Pinned Locked Moved ASP.NET
databasesql-serversysadminhelp
5 Posts 4 Posters 0 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.
  • E Offline
    E Offline
    eyeseetee
    wrote on last edited by
    #1

    Hey I'm having problems connecting from sql server to the web server anyone know any good troubleshooting articles Ive looked on the internet but nothing seems to help me thanks in advance

    V D 2 Replies Last reply
    0
    • E eyeseetee

      Hey I'm having problems connecting from sql server to the web server anyone know any good troubleshooting articles Ive looked on the internet but nothing seems to help me thanks in advance

      V Offline
      V Offline
      Vasudevan Deepak Kumar
      wrote on last edited by
      #2

      Can you quantify what exactly the error message or problem that you are experiencing?

      Vasudevan Deepak Kumar Personal Homepage
      Tech Gossips
      A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

      E 1 Reply Last reply
      0
      • V Vasudevan Deepak Kumar

        Can you quantify what exactly the error message or problem that you are experiencing?

        Vasudevan Deepak Kumar Personal Homepage
        Tech Gossips
        A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

        E Offline
        E Offline
        eyeseetee
        wrote on last edited by
        #3

        An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) do i need to configure remote connections on sql 200 if so how/ i have sorted the ip/tcp do i need to open a port? thanks

        C 1 Reply Last reply
        0
        • E eyeseetee

          An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) do i need to configure remote connections on sql 200 if so how/ i have sorted the ip/tcp do i need to open a port? thanks

          C Offline
          C Offline
          ChrisKo 0
          wrote on last edited by
          #4

          Looks like your SQL server is configured to use Named Pipes and not TCP as the default communications. Use the SQL Network Configuration tool to change the default protocol to TCP and open up port 1433, unless you configure another port.

          1 Reply Last reply
          0
          • E eyeseetee

            Hey I'm having problems connecting from sql server to the web server anyone know any good troubleshooting articles Ive looked on the internet but nothing seems to help me thanks in advance

            D Offline
            D Offline
            dilipv 0
            wrote on last edited by
            #5

            hi Jamie1985, Few days ago i also faced the same issue and got dela with the help of the another forum. I pasted the link, hope this will help you. http://blog.sqlauthority.com/2007/04/23/sql-server-fix-error-40-could-not-open-a-connection-to-sql-server/ If you have any problem after that feel free to share with me. Thanks & Regards Dilip Kumar Vishwakarma

            Programmer .Net Consulting

            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