SQL SEVER 2005 QUESTION

by 7 replies
9
please, i have a problem when trying to create a database or a connection. the error message i have goes like this

(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)

thanks 4 helping me out.
#programming #2005 #question #sever #sql
  • Banned
    [DELETED]
  • Did you configure the server to accept connections from remote clients? This might help you:

    Managing the "Surface Area" of SQL Server 2005 — Developer.com
    • [1] reply
    • I tried surface areal configuration, and i receive an error say no component found.
      do i need to install SQL sever 2005?
  • Perhaps there is a firewall that doesn't allow external connections to the SQL server? I have such setup on my server and that is the error people get when they try and connect to the sql server or mine.
  • SO PLEASE HOW CAN I LOCATE AND FIX THIS ERROR
    • [1] reply
    • Why are you yelling? You are gettig free advice. If it isn't working and it is VERY important, pay someone to fix it.

      Though you did ask "should I install SQL 2005." Well if you haven't, that would be a good place to start. Since it will never be able to connect to something that isn't there.
  • thanks KIrkMcD, i was trying to use default SQL server 2005 that came along with my Visual Studio 2008
  • Hey If you still facing the problem...

    Go to Add/Remove programs in Control panel and uninstall everything related to SQL..studio, server.....

    Then Install SQL Server first and then SQL Studio and it will work....
Join the discussion

Next Topics on Trending Feed

  • 9

    SQL SEVER 2005 QUESTION

    please, i have a problem when trying to create a database or a connection. the error message i have goes like this (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)