9 {{ upvoteCount | shortNum }}
9 {{ upvoteCount | shortNum }}

SQL SEVER 2005 QUESTION

by lloydblinks
7 replies
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.
#2005 #question #sever #sql
  • Profile picture of the author Manfred Ekblad
    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
    {{ DiscussionBoard.errors[2155067].message }}
    • Profile picture of the author lloydblinks
      I tried surface areal configuration, and i receive an error say no component found.
      do i need to install SQL sever 2005?
      {{ DiscussionBoard.errors[2156857].message }}
  • Profile picture of the author Sleaklight
    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.
    {{ DiscussionBoard.errors[2157379].message }}
  • Profile picture of the author lloydblinks
    SO PLEASE HOW CAN I LOCATE AND FIX THIS ERROR
    {{ DiscussionBoard.errors[2203272].message }}
    • Profile picture of the author KirkMcD
      Originally Posted by lloydblinks View Post

      SO PLEASE HOW CAN I LOCATE AND FIX THIS ERROR
      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.
      {{ DiscussionBoard.errors[2203469].message }}
  • Profile picture of the author lloydblinks
    thanks KIrkMcD, i was trying to use default SQL server 2005 that came along with my Visual Studio 2008
    {{ DiscussionBoard.errors[2214423].message }}
  • Profile picture of the author Mohsin Rasool
    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....
    Signature
    Warriors4Hire: WordPress & GENESIS Experts | Custom WP Theme | WordPress Troubleshooting | Customizations | WP Security | Responsive Themes

    My Business site: WarMarks - Web Development | My Personal Blog: Mohsin Rasool
    {{ DiscussionBoard.errors[2217305].message }}

Trending Topics