SQL Express

Discussion in 'Software' started by Nelix, Dec 9, 2009.

  1. Nelix
    Honorary Member

    Nelix Gigabyte Poster

    1,416
    3
    82
    Hi all

    Hoping for some quick answers on this one

    I have a customer that is running SQL Express, when ever they log off and either they log back on or another users logs on the SQL service has to be re-started manually.

    Can this service be configured so that it runs all the time even if there is no-one logged on then machine?

    Cheers :D
     
    Certifications: A+, 70-210, 70-290, 70-291, 74-409, 70-410, 70-411, 70-337, 70-347
    WIP: 70-346
  2. simongrahamuk
    Honorary Member

    simongrahamuk Hmmmmmmm?

    6,205
    136
    199
    Sure can.

    on the machine go to Services, and set the startup type to Automatic. You may need to also tell it to logon as a local system account though.
     
  3. Nelix
    Honorary Member

    Nelix Gigabyte Poster

    1,416
    3
    82
    Yeah, sorry should have mentioned, It's already set to start automatically. It is also set to use the networkservice account

    Cheers
     
    Certifications: A+, 70-210, 70-290, 70-291, 74-409, 70-410, 70-411, 70-337, 70-347
    WIP: 70-346
  4. simongrahamuk
    Honorary Member

    simongrahamuk Hmmmmmmm?

    6,205
    136
    199
    Can you set it to restart automatically after a failure?
     
  5. Qs

    Qs Semi-Honorary Member Gold Member

    3,081
    70
    171
    This.

    Open the service's properties and amend the options in the Recovery tab.

    Qs
     
    Certifications: MCT, MCSE: Private Cloud, MCSA (2008), MCITP: EA, MCITP: SA, MCSE: 2003, MCSA: 2003, MCITP: EDA7, MCITP: EDST7, MCITP: EST Vista, MCTS: Exh 2010, MCTS:ServerVirt, MCTS: SCCM07 & SCCM2012, MCTS: SCOM07, MCTS: Win7Conf, MCTS: VistaConf, MCDST, MCP, MBCS, HND: Applied IT, ITIL v3: Foundation, CCA
  6. Nelix
    Honorary Member

    Nelix Gigabyte Poster

    1,416
    3
    82
    Thats set to restart on all 3 failures.
     
    Certifications: A+, 70-210, 70-290, 70-291, 74-409, 70-410, 70-411, 70-337, 70-347
    WIP: 70-346
  7. MLP

    MLP Kilobyte Poster

    305
    19
    59
    Have you checked dependancies? Open services, right-click on the service, properties, dependancies. On mine, there aren't any, but its work checking.

    Maria
     
    Certifications: HND Computing
  8. Sparky
    Highly Decorated Member Award 500 Likes Award

    Sparky Zettabyte Poster Moderator

    10,718
    543
    364
    Slightly messy but perhaps use a logon script to stop\start the service?
     
    Certifications: MSc MCSE MCSA:M MCSA:S MCITP:EA MCTS(x5) MS-900 AZ-900 Security+ Network+ A+
    WIP: Microsoft Certs
  9. Alex Wright

    Alex Wright Megabyte Poster

    501
    9
    57
    A simple batch script should suffice:

    Code:
    net stop [service name]
    
    net start [service name] 
     
    Certifications: 70-680 Configuring Windows 7
    WIP: 70-642

Share This Page

Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.