Connecting to sql server 2008

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Vikram Raman
    New Member
    • Feb 2010
    • 24
    #1

    Connecting to sql server 2008

    Hello Everyone,


    I have developed a web application in asp.net with C# in visual Studio 2005. And i used sql server 2008 as back end. When i run the program, it shows the following error..


    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)


    Get me a solution for this...

    Thank You....
    Tags: None
    • ThatThatGuy
      Recognized Expert Contributor
      • Jul 2009
      • 453
      #2
      what's the connection string.... youre using and ensure the Sql Service is running

        Comment

        • Frinavale
          Recognized Expert Expert
          • Oct 2006
          • 9749
          #3
          This is a database connectivity problem.

          The first thing to do is to (do as the error details suggest) check your SQL Server settings to make sure that you allow outside connections to the database.

          If this is configured properly and you're still having problems, check your Connection String to make sure that you've provided the correct credentials and database details required in order to connect to the SQL Server.

          -Frinny

            Comment

            Previous template Next
            Working...