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. General Programming
  3. .NET (Core and Framework)
  4. SQL Connection problem in Windows Service asp.net c#

SQL Connection problem in Windows Service asp.net c#

Scheduled Pinned Locked Moved .NET (Core and Framework)
helpcsharpsysadminasp-netdatabase
5 Posts 5 Posters 1 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.
  • M Offline
    M Offline
    Member 7992635
    wrote on last edited by
    #1

    Hello Sir/Mam I'm trying connect sql server 2000 in windows service with other system on same network. there are 4 system connected without any problem. But on other 4 system, it is giving error on connection open while starting windows service. The error is: "the service on local computer started and then stopped some services stop automatically" etc. Same Connection string working in web service without any error. But giving problem in Window Service. Is there any Configuration setting of that server or sql server 2000. Any help will be highly appreciated.........

    L V 2 Replies Last reply
    0
    • M Member 7992635

      Hello Sir/Mam I'm trying connect sql server 2000 in windows service with other system on same network. there are 4 system connected without any problem. But on other 4 system, it is giving error on connection open while starting windows service. The error is: "the service on local computer started and then stopped some services stop automatically" etc. Same Connection string working in web service without any error. But giving problem in Window Service. Is there any Configuration setting of that server or sql server 2000. Any help will be highly appreciated.........

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #2

      Please do not cross post. You have already posted this in at least 2 other forums.

      Why is common sense not common? Never argue with an idiot. They will drag you down to their level where they are an expert. Sometimes it takes a lot of work to be lazy Please stand in front of my pistol, smile and wait for the flash - JSOP 2012

      S 1 Reply Last reply
      0
      • L Lost User

        Please do not cross post. You have already posted this in at least 2 other forums.

        Why is common sense not common? Never argue with an idiot. They will drag you down to their level where they are an expert. Sometimes it takes a lot of work to be lazy Please stand in front of my pistol, smile and wait for the flash - JSOP 2012

        S Offline
        S Offline
        SoMad
        wrote on last edited by
        #3

        And still failed to post it in the Database forum :doh: Soren Madsen

        1 Reply Last reply
        0
        • M Member 7992635

          Hello Sir/Mam I'm trying connect sql server 2000 in windows service with other system on same network. there are 4 system connected without any problem. But on other 4 system, it is giving error on connection open while starting windows service. The error is: "the service on local computer started and then stopped some services stop automatically" etc. Same Connection string working in web service without any error. But giving problem in Window Service. Is there any Configuration setting of that server or sql server 2000. Any help will be highly appreciated.........

          V Offline
          V Offline
          Vijay Selvaraj
          wrote on last edited by
          #4

          Hi please Setup the COnnection pool size in your connection string vijay

          P 1 Reply Last reply
          0
          • V Vijay Selvaraj

            Hi please Setup the COnnection pool size in your connection string vijay

            P Offline
            P Offline
            Pete OHanlon
            wrote on last edited by
            #5

            While that may be the answer to some question, it's not the answer to this question.

            *pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

            "Mind bleach! Send me mind bleach!" - Nagy Vilmos

            CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

            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