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
  1. Home
  2. Web Development
  3. ASP.NET
  4. Not Able to connect to Sql server(urgent)

Not Able to connect to Sql server(urgent)

Scheduled Pinned Locked Moved ASP.NET
csharpasp-netdatabasesql-servervisual-studio
4 Posts 3 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.
  • P Offline
    P Offline
    pankaj_gargin rediffmail com
    wrote on last edited by
    #1

    Due to some unknown reason i am not able to connect to sqlserver from my asp.net application since this morming..(i left the system in a stable state last time)...It says.. "Sql server doesnot exist or access denied" i am not able to find the cause to it(because the connection string is same in the web.config as it was running last evening successfully. No firewall is there. I am able to connect to sqlserver through Enterprise manager and also able to open sql server through SERVER EXPLORER.I see no problems there. I sm running VS.net 2003 on Win Xp and sqlserver is hosted on other machine.A friend of mine is able to connect to the same server with the same code with no problems. Does some one has a solution to the problem.I am in desperate situation. Waiting for a reply Pankaj

    P 1 Reply Last reply
    0
    • P pankaj_gargin rediffmail com

      Due to some unknown reason i am not able to connect to sqlserver from my asp.net application since this morming..(i left the system in a stable state last time)...It says.. "Sql server doesnot exist or access denied" i am not able to find the cause to it(because the connection string is same in the web.config as it was running last evening successfully. No firewall is there. I am able to connect to sqlserver through Enterprise manager and also able to open sql server through SERVER EXPLORER.I see no problems there. I sm running VS.net 2003 on Win Xp and sqlserver is hosted on other machine.A friend of mine is able to connect to the same server with the same code with no problems. Does some one has a solution to the problem.I am in desperate situation. Waiting for a reply Pankaj

      P Offline
      P Offline
      Pankaj Kulkarni
      wrote on last edited by
      #2

      Hi Pankaj, This problem may occur, 1) if u will register your computer to another workgroup or Domain. 2) Your Server Name will get changed 3) Your Network cable may get disconnected. 4) You don't have rights to access that Server. regards, Pankaj Kulkarni

      P 1 Reply Last reply
      0
      • P Pankaj Kulkarni

        Hi Pankaj, This problem may occur, 1) if u will register your computer to another workgroup or Domain. 2) Your Server Name will get changed 3) Your Network cable may get disconnected. 4) You don't have rights to access that Server. regards, Pankaj Kulkarni

        P Offline
        P Offline
        pankaj_gargin rediffmail com
        wrote on last edited by
        #3
        1. if u will register your computer to another workgroup or Domain. Still in the same workgroup 2) Your Server Name will get changed Server name has not changed 3) Your Network cable may get disconnected. Not an issue 4) You don't have rights to access that Server. I am able to connect through Enterprise Manager I am able to ping the server I am able to connect to the DB via Visual Studio However I get this error when I run my ASP.NET Code...at the point of Connection.Open().
        I 1 Reply Last reply
        0
        • P pankaj_gargin rediffmail com
          1. if u will register your computer to another workgroup or Domain. Still in the same workgroup 2) Your Server Name will get changed Server name has not changed 3) Your Network cable may get disconnected. Not an issue 4) You don't have rights to access that Server. I am able to connect through Enterprise Manager I am able to ping the server I am able to connect to the DB via Visual Studio However I get this error when I run my ASP.NET Code...at the point of Connection.Open().
          I Offline
          I Offline
          Ista
          wrote on last edited by
          #4

          your connection string is faulty. From server explorer drag a stored proc or table onto the form. This will create a valid connection string. Compare yours with the new one and see what has changed. Nick 1 line of code equals many bugs. So don't write any!!

          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