1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SQL Express

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

  1. Nelix
    Honorary Member

    Nelix Gigabyte Poster

    1,412
    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
    WIP: 70-294
  2. simongrahamuk
    Honorary Member

    simongrahamuk Hmmmmmmm?

    6,199
    125
    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,412
    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
    WIP: 70-294
  4. simongrahamuk
    Honorary Member

    simongrahamuk Hmmmmmmm?

    6,199
    125
    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,412
    3
    82
    Thats set to restart on all 3 failures.
     
    Certifications: A+, 70-210, 70-290, 70-291
    WIP: 70-294
  7. MLP

    MLP Kilobyte Poster

    305
    19
    42
    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
    WIP: 70-680, 70-270, 70-290
  8. Sparky
    Highly Decorated Member Award

    Sparky Zettabyte Poster Moderator

    10,191
    299
    319
    Slightly messy but perhaps use a logon script to stop\start the service?
     
    Certifications: MSc MCSE MCSA:M MCSA:S MCITP:EA MCTS(x5) Security+ Network+ A+
    WIP: Exchange 2007\2010
  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...