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. General Programming
  3. C#
  4. Sql Server Express Edition Configuration with C#

Sql Server Express Edition Configuration with C#

Scheduled Pinned Locked Moved C#
helpcsharpdatabasesql-servervisual-studio
2 Posts 1 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.
  • F Offline
    F Offline
    fahiemulleh
    wrote on last edited by
    #1

    Hi. I am using visual studio 2005 with Sql Server Express Edition. I haven't install sql server 2005 Professional edition on my machine. It works fine. The connection string is: You can see I haven't hardcoded machine name and there is no absolute path. I have open the website on another machine and it works fine. Now , i have open this project on third machine but it doesn't work and gives 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)" I think there is some problem with sql server configuration . Please help me in this regards. I will be very thankful to you. Fahim Great Men always help people.

    F 1 Reply Last reply
    0
    • F fahiemulleh

      Hi. I am using visual studio 2005 with Sql Server Express Edition. I haven't install sql server 2005 Professional edition on my machine. It works fine. The connection string is: You can see I haven't hardcoded machine name and there is no absolute path. I have open the website on another machine and it works fine. Now , i have open this project on third machine but it doesn't work and gives 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)" I think there is some problem with sql server configuration . Please help me in this regards. I will be very thankful to you. Fahim Great Men always help people.

      F Offline
      F Offline
      fahiemulleh
      wrote on last edited by
      #2

      Any help please ?

      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