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. System Admin
  4. please ,, i need a help ,,, for this problem in sql server 2005

please ,, i need a help ,,, for this problem in sql server 2005

Scheduled Pinned Locked Moved System Admin
helpcsharpdatabasesql-serversysadmin
3 Posts 3 Posters 11 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.
  • N Offline
    N Offline
    necib2010
    wrote on last edited by
    #1

    Hello. I am getting the following error when trying to connect: "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) (.Net SqlClient Data Provider)" 1) I tried seeing what services are running and nothing with SQL Server is listed. 2) I ran the Surface Area Configuration and the following message immediately pops up: "No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)" What in blazes is going on? Thanks.

    R M 2 Replies Last reply
    0
    • N necib2010

      Hello. I am getting the following error when trying to connect: "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) (.Net SqlClient Data Provider)" 1) I tried seeing what services are running and nothing with SQL Server is listed. 2) I ran the Surface Area Configuration and the following message immediately pops up: "No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)" What in blazes is going on? Thanks.

      R Offline
      R Offline
      R Giskard Reventlov
      wrote on last edited by
      #2

      Probably a dumb question but is SQL Server installed on the machine? If no services are listed then it may not be.

      me, me, me "The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!" Larry Niven

      1 Reply Last reply
      0
      • N necib2010

        Hello. I am getting the following error when trying to connect: "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) (.Net SqlClient Data Provider)" 1) I tried seeing what services are running and nothing with SQL Server is listed. 2) I ran the Surface Area Configuration and the following message immediately pops up: "No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)" What in blazes is going on? Thanks.

        M Offline
        M Offline
        m4st3rShifu
        wrote on last edited by
        #3

        while installing the SQL server 2005 have you used the windows authentication mode or not........you should always use the default installation mode i mean the windows authentication mode ...!! :-\

        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